I followed the instructions at http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php to create a database export.
I used:
expdp scott/tiger@db10g full=Y directory=TEST_DIR dumpfile=DB10G.dmp logfile=expdpDB10G.log
to create the export. However I get this error message:
UDE-00008: operation generated ORACLE error 12154
ORA-01033: ORACLE initialization or shutdown in progress
How do I resolve this issue?
Best Answer
First:
Then:
(Alternatively, use
sqlplus / as sysdba
instead of the above two steps.)Check the status (I guess it will tell you anything but STARTUP):
Then turn it completly off:
Then start it:
If you get errors starting up, check the alert log and your favorite search engine (searching for the
ORA-xxxx
alert number is a good place to start). If you can't figure it out, you can ask a question about that here (including the relevant part of the alert log or any other errors you see).