- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Why does oracle export job always fail on the ...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-04-2007 07:01 AM
тАО04-04-2007 07:01 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-04-2007 07:11 AM
тАО04-04-2007 07:11 AM
Re: Why does oracle export job always fail on the pnjoblog_old table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-04-2007 07:24 AM
тАО04-04-2007 07:24 AM
SolutionDoes 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-04-2007 08:09 AM
тАО04-04-2007 08:09 AM
Re: Why does oracle export job always fail on the pnjoblog_old table?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-04-2007 08:09 AM
тАО04-04-2007 08:09 AM