one change, I would check the alert log first.

-----Original Message-----
From: Michael Porter
[mailto:oracledba-ezmlmshield-x19983296.[Email address protected]
Sent: Monday, July 31, 2006 7:40 AM
To: LazyDBA Discussion
Subject: Re: Exporting 10g data to .dmp file...


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



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


-----------------------------------------
CONFIDENTIALITY NOTICE

This message and any attachments are from the NAIC and are intended
only for the addressee. Information contained herein is
confidential, and may be privileged or exempt from disclosure
pursuant to applicable federal or state law. This message is not
intended as a waiver of the confidential, privileged or exempted
status of the information transmitted. Unauthorized forwarding,
printing, copying, distribution or use of such information is
strictly prohibited and may be unlawful. If you are not the
addressee, please promptly delete this message and notify the
sender of the delivery error by e-mail or by calling the NAIC Help
Desk at (816)783-8500.


Oracle LazyDBA home page