High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Standby database & ORA-01033 Error

Just been building a standby database in 11.2.0.4.

The view  V$ARCHIVE_DEST_STATUS was showing

ORA-01033: ORACLE initialization or shutdown in progress

in the column ERROR.

It turns out that this was caused by not having the orapw file copied over to the standby database.

So, if you get this error when checking on the primary:

SELECT ERROR FROM V$ARCHIVE_DEST_STATUS

ORA-01033: ORACLE initialization or shutdown in progress

Check that the password files have been set up properly!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center