Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01033: ORACLE initialization or shutdown in progress

603447Oct 16 2007 — edited Oct 17 2007

I regularly restart OracleService (thru net stop/start) and there are times that I encounter this error. According to http://www.dba-oracle.com/t_ora_01033_initialization_shutdown_progress.htm, it happens due to database is not open. Is there a way that on a batch file, I can check the status of the database so I may start it automatically. Here is the actual steps that I do when this happens:

1. Go to command prompt.
2. set oracle_sid=oraprod
3. sqlplus /nolog
4. connect sys/sys_pwd as sysdba;
5. shutdown abort
6. startup
7. recover database
8. alter database open
9. Exit
10. net stop/start oracleserviceoraprod

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 14 2007

Added on Oct 16 2007

#general-database-discussions

6 comments

1,080 views