Category Archives: ORA- ERRORS

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 , , , , , | Leave a comment

ORA-16849 ORA-16816 After Uncompleted Data Guard Switchover

For some reason, DG ( Data Guard ) switchover command is incomplete with below warnings: Database Error(s): ORA-16849: a previous switchover from this database was interrupted and aborted ORA-16816: incorrect database role After detailed checks, it is confirmed that database … Continue reading

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

“Duplicate from Active Database” Failed With ORA-12528 When Connecting to Auxiliary Instance

RMAN “duplicate target database for standby from active database” failed with below errors: Connection from target database server to the auxiliary database  fails with error: ORA-12528: TNS:listener: all appropriate instances are blocking new connections. CAUSE Since Auxiliary instance is started in … Continue reading

Posted in 12c new features, DataGuard, GI and RAC, ORA- ERRORS, RMAN Restore and Recovery | Tagged , , , , | Leave a comment

WARNING: FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so

Database instance starts up failure with below errors: ORA-15183: ASMLIB initialization error [driver/agent not installed] Wed Jan 31 17:48:16 2018 WARNING: FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so Check “oracleasm.service” with errors: # systemctl status oracleasm.service oracleasm.service – Load oracleasm Modules Loaded: … Continue reading

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

ORA-600 [kwqmnuji: bad option] In 11.2.0.4 RAC

SYMPTOMS There are a lot of ORA-600 [kwqmnuji: bad option] errors in alert.log of 11.2.0.4 RAC database. ORA-00600: internal error code, arguments: [kwqmnuji: bad option], [2], [], [], [], [], [], [], [], [], [], [] Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] … Continue reading

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