Stop EM. Connect to the database through sqlplus and shutdown the
database (might have to add immediate condition. After shutdown, startup
the database from sqlplus and look at you alert log to see if there were
any errors. If not, startup em again. If that competes successfully and
shows the database open, try your export now...

>>> "Todd Abraham "
<oracledba-ezmlmshield-x76098564.[Email address protected] 7/31/2006
8:28:24 AM >>>
Hello all,



Today I ran into an issue where I was suddenly unable to start up my
database. I am now trying to export to a DMP file, and am
experiencing
problems with the export function.



First off, when I try to start the db from EM, the db will mount, but
when I
try to open the db, it crashes back to the startup page of EM. I can
go to
sql> connect and connect to the db, and I can also TNSping the
listener.



I have checked my services and everything is running. I have also
followed
some advice and added a TNS_ADMIN string in the LOCAL_MACHINE >
SOFTWARE >
ORACLE registry pointing to where the TNS file resides. In addition,
in the
registry at Ora home0 I have set the ORA (SID) AUTOSTART to TRUE and
SHUTDOWN to FALSE.



Here's what's happening when I attempt the export under the above
mentioned
setup:



EXP-00056: ORACLE error 1033 encountered

ORA-01033: ORACLE initialization or shutdown in progress



Any suggestions?



____________________________________________________







--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page