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 12.1.2.1.0 and later
Information in this document applies to any platform.

Symptoms

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

DB alert.trc:

-------

2019-09-30T23:30:27.946768+00:00
Completed redo application of 177.51MB
2019-10-01T00:41:00.049031+00:00
Errors in file /u01/app/oracle/diag/rdbms/<DBNAME>/<INSTANCE NAME>/trace/INSTANCENAME_dbw0_268518.trc:
2019-10-01T00:41:01.531640+00:00
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
2019-10-01T00:56:11.248918+00:00
Errors in file /u01/app/oracle/diag/rdbms/<nodename>/<DBNAME>/trace/<INSTANCENAME>_dbw0_268518.trc:<==========db writer Errors
2019-10-01T01:00:23.917076+00:00

 

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"

 

 

Cause

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
Symptoms
Cause
Solution


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