Home » RDBMS Server » Backup & Recovery » SYSTEM GETS HANGED WHEN RUNNING EXP
SYSTEM GETS HANGED WHEN RUNNING EXP [message #192776] Wed, 13 September 2006 09:17 Go to next message
vinodrw
Messages: 1
Registered: September 2006
Junior Member
WHEN WE ARE RUNNING THE EXP (EXPORT) COMMAND IN ORACLE 10G
TO TAKE THE BACKUP IT GETS HANGED FOR A LONG TIME AND THEN IN THE LOG FILE WE FIND THE FOLLOWING ERROR MESSAGE.

SOMETIMES AFTER RESTARTING THE SERVER WE ARE ABLE TO RUN THE EXP COMMAND.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user MANHAR
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user MANHAR
About to export MANHAR's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
******************************** AT THIS POINT THE SYSTEM HANGS.
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00000: Export terminated unsuccessfully

THE EXP COMMAND THAT WE USE IS AS FOLLOWS:

EXP MANHAR/MANHAR FILE=F:\BACKUP\MANHAR.DMP LOG=F:\BACKUP\MANHAR.LOG BUFFER=1000000 GRANTS=Y CONSTRAINTS=Y

The above command is given in a batch file and is scheduled to run in the night when no users are using the application.

THE DATABASE INSTANCE IS UP AS DURING THIS TIME THE NETWORK USERS CAN ACCESS THE APPLICATION FROM THE CLIENT PC'S.

WE ARE RUNNING THE EXP COMMAND ON THE SERVER ITSELF.
THE SERVER OPERATING SYSTEM IS WINDOWS 2003 SERVER.

We would be grateful if someone could give a solution for the above issue
Re: SYSTEM GETS HANGED WHEN RUNNING EXP [message #192782 is a reply to message #192776] Wed, 13 September 2006 09:34 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>BUFFER=1000000
Any rationale for using this?
Did you try with the default?
Did someone execute catapatch/catalog.sql recently?
post the relevent contents of the database alert_sid.log
Previous Topic: Server crash when exporting database
Next Topic: Oracle 9i backup scenario
Goto Forum:
  


Current Time: Wed Dec 07 08:53:14 CST 2016

Total time taken to generate the page: 0.05533 seconds