-
Error during export in oracle 9i
Hi,
An eror occured during export as sys user with full=y
. . exporting table DESSTEPS 157500 rows exported
. . exporting table GROUPS 11 rows exported
. . exporting table HISTORY 127134 rows exported
. . exporting table HOSTS 0 rows exported
. . exporting table HOST_GROUP 0 rows exported
. . exporting table HOST_IN_GROUP 0 rows exported
. . exporting table LOCKS 0 rows exported
. . exporting table MAILCOND 0 rows exported
. . exporting table MODULES 5 rows exported
. . exporting table REPORTS 0 rows exported
. . exporting table REQ 479 rows exported
. . exporting table REQ_COVER 2736 rows exported
. . exporting table RUN 15619 rows exported
. . exporting table SEQUENCES 21 rows exported
. . exporting table STEP
EXP-00056: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
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-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully
How to fix this?
cheers!
-
Have a look at the server alert log, and any trace files produced, for more details -- there may be more error information there.
-
Hi,
The ALERT LOG and SMON TRC file informations
ALERT LOG:
Wed Sep 24 03:35:59 2003
Errors in file E:\oracle\admin\TD\bdump\tdSMON.TRC:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
Thu Sep 25 06:02:15 2003
Errors in file E:\oracle\admin\TD\bdump\tdSMON.TRC:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
SMON.TRC:
*** 2003-09-24 03:35:59.000
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
*** 2003-09-25 06:02:15.000
SMON: following errors trapped and ignored:
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00601: cleanup lock conflict
Many Thanks,
-
The 601 error is not common, and you would probably do well to open a tar with Oracle for this.
Also, what version are you on? I saw a mention of a problem with this in 8.1.6.0.0 that was solved by an upgrade to 8.1.6.2.0
-
Oracle 9i(9.0.1) on WINNT
Thanks,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|