Operating System - HP-UX
1748201 Members
3091 Online
108759 Solutions
New Discussion юеВ

Why does oracle export job always fail on the pnjoblog_old table?

 
SOLVED
Go to solution
Jan Shu
Regular Advisor

Why does oracle export job always fail on the pnjoblog_old table?

Hi All,

My DBA team has a database with 1000+ tables, and one of them called PNJOBLOG_OLD table which caused export job failure all the times. Other tables are fine with export jobs. Below is the export error log. This is on a HPUX 11.23 server rx7620. What can I (SA) check on the hpux OS side to help my DBA on this problem? Thank you.

. . exporting table PNJOBLOG_OLD
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-00000: Export terminated unsuccessfully
4 REPLIES 4
A. Clay Stephenson
Acclaimed Contributor

Re: Why does oracle export job always fail on the pnjoblog_old table?

As a guess, has the size of your export reached 2GiB on a filesystem that is not largefiles enabled? Have you reached a ulimit value? ... or a quota?
If it ain't broke, I can fix that.
Hein van den Heuvel
Honored Contributor
Solution

Re: Why does oracle export job always fail on the pnjoblog_old table?

Have you tried exporting just that table?

Does that work?
DOes it make any progress? dot . dot . dot .

If not, how about a simple:
select count(*) from pnjoblog_old

Any error details in alert.log or a .trc file around the time of the problem?

Is the export done with indexes=yes?
Try no: without indexes! (my preference all the time)

Hope this helps some,
Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting
Jan Shu
Regular Advisor

Re: Why does oracle export job always fail on the pnjoblog_old table?

Hi A. Clay,
Thanks for the reply. The file system does support large files > 2GB.


Hi Hein,
Thanks for the update. I will forward your message to my DBA team for future reference. 10 min ago, my DBA team decided to drop that pnjoblog_old table and the full export can be completed successfully. I am closing this case, though I still don't know what's wrong with this particular table.

Thank you.

Regards,
Jan Shu
Jan Shu
Regular Advisor

Re: Why does oracle export job always fail on the pnjoblog_old table?

Case is close.