My Oracle Support Banner

RAC DB startup fails with error - 'ORA-1154 signalled during: alter database open' (Doc ID 2595327.1)

Last updated on AUGUST 17, 2023

Applies to:

Oracle Exadata Storage Server Software - Version and later
Information in this document applies to any platform.


DB startup fails with error ORA-1154 signalled during: alter database open

DB alert.trc:


Completed redo application of 177.51MB
Errors in file /u01/app/oracle/diag/rdbms/<DBNAME>/<INSTANCE NAME>/trace/INSTANCENAME_dbw0_268518.trc:
System state dump requested by (instance=1, osid=392054), summary=[SYSTEMSTATE_GLOBAL: global system state dump request (kjdgdss_g)].
System State dumped to trace file /u01/app/oracle/diag/rdbms/<nodename>/DBNAME/trace/DBNAME_diag_268460_20191001004101.trc
Errors in file /u01/app/oracle/diag/rdbms/<nodename>/<DBNAME>/trace/<INSTANCENAME>_dbw0_268518.trc:<==========db writer Errors


Manually startup from sqlplus:


SQL> alter database open;
alter database open
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now


 Media recovery is expected when tried to start the DB in standalone option(Cluster_database=false) by shutting down other instances.

Running "recover database" initiates the DB media recovery and the hangs at "check point completed" wait event and it waits for the idle waits(rdbms ipc message)as per the per the oredebug/Hang trace :


Hang trace shows "Signature: 'rdbms ipc message'<='checkpoint completed"




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.