Friday, June 20, 2008

database startup process

Actually, it's a 3 step process for Oracle startup:

startup nomount;
alter database mount;
alter database open;

If you use automatic script to startup Oracle DB, then user cannot connect, the error message is :ERROR: ORA-01033: ORACLE initialization or shutdown in progress:

then you need to use 3 steps to startup to see which step got problem:

No comments: