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
$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
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
Superb post, we enjoyed each and everything as per written in your post. Thank you for this informative article because it’s really helpful, I really like site. @ Packers And Movers Gurgaon
ReplyDeleteGet Shifting/Relocation Quotation from ###Packers and Movers Delhi. Packers and Movers Delhi 100% Affordable and Reliable ***Household Shifting Services. Compare Transportation Charges and Save Time, Verified and Trusted Packers and Movers in Delhi, Cheap and Safe Local, Domestic House Shifting @
ReplyDeletePackers And Movers Delhi
Packers And Movers Bangalore Local Household Shifting Service, Get Free Best Price Quotes Local Packers and Movers in Bangalore List, Compare Charges, Save Money And Time at
ReplyDeleteLocal Packers And Movers Bangalore
This comment has been removed by the author.
ReplyDeletePackers and Movers Delhi to Allahabad.
ReplyDeletePackers and Movers Delhi to Asansol.
Packers and Movers Delhi to Ajmer.
Packers and Movers Delhi to Ambattur.
Packers and Movers Delhi to Aligarh.
Packers and Movers Delhi to Amravati.
Packers and Movers Delhi to Bhopal.
Packers and Movers Delhi to Bareilly.
Packers and Movers Delhi to Bhiwandi.
Packers and Movers Delhi to Bikaner.
Packers and Movers Delhi to Bhavnagar.
Packers and Movers Delhi to Bhilai Nagar.
Packers and Movers Delhi to Belgaum.
Packers and Movers Delhi to Bhiwadi.
Packers and Movers Delhi to Coimbatore.
Packers and Movers Delhi to Chandigarh.
Packers and Movers Delhi to Cuttack.
Many thanks for sharing this wonderful article. Keep posting such articles. I look forward to seeing more of your posts!
ReplyDeletepackers and movers in Noida
packers and movers in Bangalore
packers and movers in Faridabad
packers and movers in Gurgaon
packers and movers in Ghaziabad
packers and movers in Hyderabad
packers and movers in Chennai
packers and movers in Mumbai
packers and movers in Delhi
packers and movers in Dwarka
Your article was excellent. Keep writing articles like this. When I read articles, I get a lot more knowledge. Thank You so much for sharing these types articles.
ReplyDeleteBike transport service in Delhi
Bike transport service in Gurgaon
Car courier service in Noida
Car transport service in Bangalore charges
Best transport service Pune
Courier service in Mumbai
Bike transport service in Kolkata
Car transport service in Chennai
Transport service in Jaipur charges
Transport Service in Ghaziabad
Very well written article. Thanks for sharing. ppc bid management tools
ReplyDelete