Sign up ×
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 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 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:… – Luxspes Jul 12 '12 at 15:00

protected by Community Jun 18 at 16:24

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

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