If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > Error while export in oracle 9i

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Sep 2003
Posts: 12
Error while export in oracle 9i

Hi ,
My database is oracle9i in winNT. While exporting the database as sys with full=y my export terminated unsucessfully.

. . 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 ix this ?

Many Thanks,
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Jan 2003
Location: Vienna, Austria
Posts: 102
Re: Error while export in oracle 9i

the main problem here is the "ORACLE error 3113"
(also called ORA-3113)
This means your program got disconnected from the database.
there might be many causes, first check the alert-log and any traces, escpecially for ORA-600 or ORA-7445
If there are no such errors you might have a problem on the network-layer.
__________________
^/\x
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Sep 2003
Posts: 12
Hi,
Lines from the alertlog and trc file.ORA-00601 ERROR

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:
Text continued in next action...



Cheers! Thanks
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Jan 2003
Location: Vienna, Austria
Posts: 102
with this information you should contact Oracle Support.
after a short research I guess this is a bug,
but to be sure only Oracle Support can clarify this.

Do you use the latest patchset?
__________________
^/\x
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On