Question: I want to clone a
production database into a test server. I restored the datafile from
the production db to the test server and then ran the startup
nomount command. But if I connect using SQL*Plus, it's giving me
this error:
“ORA-01033: ORACLE initialization or shutdown in progress.”
Answer: “The ORA-01033: ORACLE
initialization or shutdown in progress” error happens when the
database is not open. After you create the control file issue the
command:
“alter database open”
That should stop the ORA-01033 error
and make the database available for general use.
The
“ORA-01033: ORACLE initialization or shutdown in progress.” error
can also happen when Oracle is attempting startup or shutdown and is
"hanging" on a resource such as a failed disk, writing to redo, etc.
You may also see the
ORA-19809:
limit exceeded for recovery files related to the ORA-01033
error.
