fbpx

ORA-02019: connection description for remote database not found

Hi, I’m facing this error “ORA-02019: connection description for remote database not found” during making a connection with the DB link. ORA-02019 This could be happening because of the wrong DB link name or a TNS entry missing of the remote database. In my case my DB link name is xdb_link. Find DB Link Using … Read more

ORA-12954: The request exceeds the maximum allowed database size of 12 GB

ora 12954

In this article, we are going to solve ORA 12954 the request exceeds the maximum allowed database size of 12 GB. The above error comes because of oracle XE (Express Edition), we faced this error in the oracle 18c XE PDB database. Steps to solve ORA 12954 In that case, don’t have only two choices … Read more

ORA-19913 unable to decrypt backup

ORA-19913 unable to decrypt backup

Today we facing the ORA-19913 unable to decrypt backup error during RMAN backup restoration. After troubleshooting we found, this backup belonged to the encryption-enabled database and there is a wallet also configured. while backup restoration, open database in nomount state then check wallet status, it is showing closed. SQL> select status from v$encryption_wallet; STATUS ————– … Read more

ORA-00054 resource busy and acquire with nowait

ORA-00054 resource busy and acquire with nowait

The error ORA-00054 occurs if DDL or DML currently running without commits on the target table. The ORA-00054 mostly occurs in sessions that try to change table data or the structure of a table. Read: ORA-00031: session marked for kill Solution You can get the information about the locks using the below lists views: DBA_BLOCKERS: … Read more

ORA-19502 Solutions

ORA-19502

What is ora 19502? Today I’m just performing the database full backup and suddenly I’m facing an ORA-19502 error message. I didn’t understand why this error came because I did not see any ora error in the alert file. I’m suffering on google but didn’t get any solution then I just checked my mount points … Read more

TNS-00583: Valid Node Checking: Unable To Parse Configuration

ORA 00583

TNS-00583 Actually, in today’s session I am facing the error TNS-00583 Valid Node Checking first time in my career, and unable to find the proper solution. Then I’m suffering on Google and found one solution on oracle support which I am going to discuss with you. Doc-id 1680353.1 ORA-00031: session marked for kill Solution I … Read more

ORA-00031: session marked for kill Solution

ora-00031 session marked for kill

In this tutorial, we will learn how to solve the ORA-00031 session marked for kill error. “How do I fix the ORA 00031 error?” | “ora-00031 session marked for kill” How do you resolve ORA 00031? Step 1. Login in Database with administrator (sys) user and find spid to kill at os level. If you … Read more

ORA-01244: unnamed datafile(s) added to control file by media recovery

ORA-01244

Hi friends, in this article we are going to solve the ORA-01244 error, that you will be facing during manual database recovery. ORA-01244 unnamed datafiles added to control file by media recovery Cause: Actually that error most of the time you will face during the recovery, due to the datafile entry is not in the … Read more

Load oracleasm module

loading module oracleasm failed

In this article we are going to learn how to load oracleasm module or solve if oracleasm not mounted. Some time we face loading module oracleasm failed error. During creating the ASM disk we are facing the below error Read: Oracle Database Migration from Non-ASM to ASM oracleasm module not loaded or /dev/oracleasm not mounted. … Read more

ORA-12919: Can not drop the default permanent tablespace

ORA-12919 Can not drop the default permanent tablespace

Hi, Today I am getting the “ORA-12919: Can not drop the default permanent tablespace” error. Actually, I tried to drop users tablespace which is the default tablespace for the database user and I’m getting the above error. ORA-12919 Can not drop the default permanent tablespace Cause – We tried to drop default tablespace. Action – … Read more

Resize Oracle datafiles down to the minimum without facing ORA-03297

ORA 03297

Hi, Today we are going to discuss how to Resize Oracle datafiles down to the minimum without facing ORA-03297. As we know the data-files stored our data and they are growing daily basis. suppose your data-files have grown in the past but now you want to reclaim as much space as possible, because you are … Read more

How to solve ORA 12560 TNS protocol adapter error?

ORA-12560

ORA-12560 TNS protocol adapter error mostly arrives if the listener not running or you type the wrong name of tns service and if you are on a windows machine which is hosts the oracle database server here database service is stopped in windows services. So using the following steps you can solve this error. Click … Read more

ORA-10456 cannot open the standby database

ORA-10456 cannot open the standby database

Here we are going to discus how to solve ORA-10456: cannot open standby database media recovery session may be in progress. The ORA-10456 is Oracle Data guard error. Note: The following error is coming at that time when you trying to open your standby database in read-only mode without stopping the archive process. ORA-10456 cannot open the standby database Solution Step-1. Stop MRP process using following … Read more

PRCR 1086 resource ora.mgmtdb is already registered

Solution PRCR 1086 resource ora.mgmtdb

In this article, I’m going to discuss the PRCR 1086 resource ora.mgmtdb resource which I was facing at the time of grid configuration on the Oracle Linux 6.7 platform. I have checked the logfile for grid configuration which is existing on the following path “/u01/app/oraInventory/logs/installActions2019-03-16_09-10-07PM.log“, and got the following information from the log. PRCR 1086 resource ora.mgmtdb … Read more