Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

migrated from stackoverflow.com Jul 12 '12 at 15:43

This question came from our site for professional and enthusiast programmers.

possible duplicate of How to take oracle 10g backup? –  Derek Downey Jul 12 '12 at 16:21

1 Answer 1


sqlplus /nolog 


connect / @bdlocal as sysdba 

(Alternatively, use sqlplus / as sysdba instead of the above two steps.)

Check the status (I guess it will tell you anything but STARTUP):

select status from v$instance; 

Then turn it completly off:

shutdown immediate; 

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).

share|improve this answer
thanks for quick response. After SQL> connect / @bdlocal as sysdba executing this line i got below error message ERROR: ORA-12154: TNS:could not resolve the connect identifier specified –  babu Jul 12 '12 at 14:53
Some possible causes for that: cyberciti.biz/faq/… –  Luxspes Jul 12 '12 at 15:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.