Category Archives: ORA- ERRORS

ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database

Oracle database instance hung due to recovery area full causing “Archival Stopped Error”. Check alert.log with below ORA errors: — Alert.log ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database. ORA-17502: ksfdcre:4 Failed to create file … Continue reading

Posted in ORA- ERRORS | Tagged , , , , | Leave a comment

ORA-15137: The ASM cluster is in rolling patch state

While adding a new disk into an existing diskgroup, below errors occurred: ORA-15032: not all alterations performed ORA-15137: The ASM cluster is in rolling patch state. 1) On both nodes, it shows the cluster in “In Rolling Patch”, and the … Continue reading

Posted in GI and RAC, ORA- ERRORS | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

ORA-27140 ORA-27300 ORA-27301 ORA-27302 ORA-273003 When Start Up or Shut Down RAC Instance

ORACLE_HOME is shared by both RAC instance A and RAC instance B. Both instance A and B are shut down, then ORACLE_HOME is patched, the ORACLE_HOME/bin/oracle binary will be as below just after the patching: $ id oracle uid=122(oracle) gid=202(oinstall) … Continue reading

Posted in ASM, GI and RAC, ORA- ERRORS | Tagged , , , , , , , , , , , , , , , | Leave a comment

ORA-04021: timeout occurred while waiting to lock object

Application job failed with below trace file contents: *** 2018-06-16 11:03:17.044 *** SESSION ID:(2437.25769) 2018-06-16 11:03:17.044 *** CLIENT ID:() 2018-06-16 11:03:17.044 *** SERVICE NAME:(BATCH) 2018-06-16 11:03:17.044 *** MODULE NAME:(DBMS_SCHEDULER) 2018-06-16 11:03:17.044 *** ACTION NAME:(IMMEDIATE16_06_2018_10_10_01) 2018-06-16 11:03:17.044 ORA-12012: error on auto … Continue reading

Posted in AWR, dbms_scheduler, ORA- ERRORS | Tagged , , , , , | Leave a comment

ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 28: No space left on device

When try to start up an Oracle database, the below errors occur: ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 28: No space left on device Additional information: 3773 Additional information: 3221225472 CAUSE Kernel parameter kernel.shmall is not set properly. … Continue reading

Posted in Configuration, ORA- ERRORS | Tagged , , , , , | Leave a comment

ORA-00904: “SYS”.”DBMS_RCVMAN”.”NUM2DISPLAYSIZE”: invalid identifier

The below errors occurred from 11.2.0.4 standby databases: SQL> select open_mode from v$database; OPEN_MODE ——————– MOUNTED SQL> select * from v$rman_backup_job_details; select * from v$rman_backup_job_details * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 2 ORA-00904: “SYS”.”DBMS_RCVMAN”.”NUM2DISPLAYSIZE”: … Continue reading

Posted in ORA- ERRORS, RMAN Restore and Recovery | Tagged , , | Leave a comment

ORA-16857: standby disconnected from redo source for longer than specified threshold

One single 11.2.0.4 instance Oracle database alert log shows below information; RFS[1]: No standby redo logfiles available for thread 1 Data Guard shows ORA-16857 error: DGMGRL> show database “TESTSTY”; Database – TESTSTY Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 10 … Continue reading

Posted in CDB/PDB, DataGuard, ORA- ERRORS | Tagged , , , , , | Leave a comment

Warning: ORA-16857: standby disconnected from redo source for longer than specified threshold

One single 11.2.0.4 instance Oracle database alert log shows below information; RFS[1]: No standby redo logfiles available for thread 1 Data Guard shows ORA-16857 error: DGMGRL> show database “TESTSTY”; Database – TESTSTY Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 10 … Continue reading

Posted in 12c new features, CDB/PDB, DataGuard, ORA- ERRORS | Tagged , , , , , , , | Leave a comment

“ORA-01017: invalid username/password; logon denied” While Data Guard Switchover

Data Guard switchover failed with “ORA-01017” error : DGMGRL> connect / Connected as SYSDG. DGMGRL> switchover to STDBYDB; Performing switchover NOW, please wait… Operation requires a connection to instance “STDBYDB2” on database “STDBYDB” Connecting to instance “STDBYDB2″… ORA-01017: invalid username/password; … Continue reading

Posted in DataGuard, GI and RAC, ORA- ERRORS | Tagged , , | Leave a comment

“DGM-17016: failed to retrieve status for database” in Data Guard Broker

Below error occurs in DG broker command on primary database side: DGMGRL> show database verbose ‘STDBYDB’ Database – STDBYDB  Role: PHYSICAL STANDBY … .. . Database Status: DGM-17016: failed to retrieve status for database “STDBYDB” ORA-16664: unable to receive the … Continue reading

Posted in DataGuard, ORA- ERRORS | Tagged , , , , , | 2 Comments