ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired The above error accour while creation of the table in database. Create table statement create table MIR.RELATION ( ID VARCHAR2(255 char) not null primary key, DESTINATION_ID VARCHAR2(255 char) not null, SOURCE_ID VARCHAR2(255 char) not null, ); Error… Read more..

Error occur while configuration of OEM 13c as installation failed with The referenced database doesn’t contain a valid management Repository. This error is occur due to the database objects already created earlier which needs proper cleanup of the Repository Database before proceeding for the fresh of OEM installation.

ORA-30032: The Suspended (Resumable) Statement has Timed Out in Oracle Database 11gR2(11.2.0.4) Issue: This issue was occur while doing a transaction in real-time database & it’s was hung for few seconds & get the error SQL> select instance_name, version, status, open_mode from V$database, v$instance; INSTANCE_NAME VERSION STATUS OPEN_MODE —————-… Read more..

ORA 01665 control file is not a standby control file This error occour while starting the recovery process on standby database. Check the status of database SQL> select instance_name,open_mode,status from V$instance, v$database; INSTANCE_NAME OPEN_MODE STATUS —————- ——————– ———— testdb-std1 MOUNTED MOUNTED SQL>… Read more..

ORA-04031: unable to allocate ** bytes of shared memory and could not startup the database This ORA error occur due the less shared memory allocated in shared pool. Start up database failed SQL> startup ORA-01012: not logged on Process ID: 0 Session ID: 0 Serial number: 0 Check the current available memory assign to this Read More

ORA-01665: control file is not a standby control file Receive the below error after the configuration of standby database manually & started the recovery process on standby database. SQL> alter database recover managed standby database using current logfile disconnect from session; alter database recover managed standby database using current logfile disconnect from session * ERROR… Read More