| SYSTEM GETS HANGED WHEN RUNNING EXP [message #192776] |
Wed, 13 September 2006 09:17  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
