Tuesday, October 1, 2019

ORA-01033: ORACLE initialization or shutdown in progress

You will see this error very often during data guard setup, the main reason for this error is the password files are not copied to from primary to standby.

ORA-01033: ORACLE initialization or shutdown in progress.
Cause: An attempt was made to log on while Oracle is being started up or shutdown.
Action: Wait a few minutes. Then retry the operation 



If you don’t have any password file then create one using below command on primary and copy to standby node.

$orapwd file=orapwDG password=xxxxxx

In case of RAC, the password file might be on Primary cluster DB which was stored in ASM, but on standby you have copied the password file to $ORACLE_HOME/dbs

Run below commands to on both primary and standby

For ex:- On Primary
$ srvctl config database -d DG 
Database unique name: DG
Database name: DG
Oracle home: /home/oracle/product/12.2.0.1/dbhome_1
Oracle user: oracle
Spfile: +DISK1/DG/ parameterfile/spfileDG.ora
Password file: +DISK1/DG/ parameterfile/pwdDG

For ex:- On standby
$ srvctl config database -d DG_std
Database unique name: DG_std
Database name: DG
Oracle home: /home/oracle/product/12.2.0.1/dbhome_1
Oracle user: oracle
Spfile: +DISK1/DG/ parameterfile/spfileDG.ora
Password file: /home/oracle/product/12.2.0.1/dbhome_1/dbs/orapwDG

Also users see this error on normal database. There are many possible reasons for this error.
1. You may get this error if Database might not opened
2. Startup/shutdown is in the middle and hung up.
3. If you are trying to connect to wrong database
4. Database might be in down for recovery

Please make sure you check below

1. If the database is not opened then use command “alter database open” .
2. Check target DB is in the middle of startup or shutdown as system is very busy or has some issues. You need to verity alert.log to find out the real issue.
3. Verify all environment variable are set correct and In case if DB is down startup the database
4. In case if user doing recovery and not successful and below steps will help to recover the DB
SQL> startup mount
ORACLE Instance started
SQL> recover database
Media recovery complete
SQL> alter database open;
Database altered

Regards
Satishbabu Gunukula, Oracle ACE

8 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Amazing and useful article for all. Keep it up thanks
    Ecostal removals is one of the reliable Packers and Movers in Siliguri. You can trust on us. We are an organization of highly confident staff. Fully handle the staff transfer process. If you are with us, we keep you from stress. Our aim is to bring satisfaction to the customer. We at Movers and Packers Siliguri, provide you high level packing facility.


    Packers and Movers Siliguri

    ReplyDelete
  3. Christmas Christian Festivals 2022 competition celebrating the birth of Savior. Country term Christmas (“mass on Christ’s day”) is of fairly recent origin. The sooner term yuletide could have derived from the Germanic jōl or the Anglo-Saxon geōl, that mentioned the feast of the solstice. The corresponding terms in alternative languages—Navidad in Spanish, Natale in Italian, Yule in French—all in all probability denote nativity. The German word Weihnachten denotes “hallowed night.”

    Ecostal removals™️ | Christmas Christian Festivals 2022

    ReplyDelete
  4. Good useful post and the writer perfectly explained. we are interstate packers and movers Trivandrum kerala

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. Thanks for sharing this useful information I shared our best experience with Office Shifting in Trivandrum, Such a very good staff.

    ReplyDelete