- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: KUP-04001: error opening file
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
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
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
09-23-2005 07:30 PM
09-23-2005 07:30 PM
Am getting the following errors
-------
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04001: error opening file /home/MSC01_8684_0509221213A_EXT.dat
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1
...
KUP-04001: error opening file /home/MSC01_8684_0509221213A_EXT.dat
KUP-04017: OS message: Permission denied
---
when I use external tables. My oracle version is 9.2.0.6.0 and os is HP-UX B.11.11 .
The file and directory exists and full permisions are granted. The Oracle directory exists and full grants assigned.
What could be the reason why I can't 'select' from the external table? Your help is highly appreciated.
regards;
Edward
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-24-2005 11:50 AM
09-24-2005 11:50 AM
Re: KUP-04001: error opening file
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:8128892010789
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2005 05:17 PM
09-25-2005 05:17 PM
Re: KUP-04001: error opening file
see metalink note:170974.1 "ORA-29913: ODCIEXTTABLEFETCH Callout - When Selecting from External Table"
the main reason for this error is "Wrong data in the flat file of the External Table or invalid delimiter specification in the create table statement"
Three things that you can immediately check are:
A. Check the end of the file to be 'loaded' specified by 'LOCATION'
This file should not contain an extra 'empty line'
B. Check that the external table definition matches the datafile format
After adding a column to the external table definition, a value or at least a zone for the new field has to be added in the records of the file to be 'loaded' specified by 'LOCATION'.
C. Check the TAB delimiter or the HEX delimiter
a. The TAB delimiter '\t', used by Oracle, is represented by a HEX value '09'
b. The HEX value in the datafile should match the HEX value specified in the CREATE statement
c. The HEX specification in the CREATE statement should look like 0X'
hope this helps!
regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-28-2005 04:34 PM
09-28-2005 04:34 PM
Re: KUP-04001: error opening file
Your suggestions helped trace the problem, though where not directly related.
I have established this as probably related to the HP-UX 11 handles links, soft or hard or rather how Oracle 9.2.0.6.0 interpretes these links.
If I have a normal data file I don't get the said error, however, if the same file is accessed via any sort of link I do get the errors mentioned.
Incidently am using links in my processing!!
Any suggestions on how I can resolve this is highly appreciated.
Regards;
Edward Mugerwa
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-28-2005 10:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-28-2005 10:43 PM
09-28-2005 10:43 PM
Re: KUP-04001: error opening file
regards!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-31-2014 05:30 AM - edited 07-31-2014 05:33 AM
07-31-2014 05:30 AM - edited 07-31-2014 05:33 AM
Re: KUP-04001: error opening file
If you are not able to open an external table on the Oracle then it results to error:
“ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04063: unable to open log file EXTERN_17063.log
KUP-04040: file TEST.TXT in TEST_DIR not found
ORA-06512: at “SYS.ORACLE_LOADER”, line 19”
It is the most common ORA-29913 error is caused when the Oracle fails to open the OS files that it needs for opening. In such a situation Oracle Repair Tool can be highly helpful to overcome such a situation. It is powerful and comprehensive data recovery software that is especially designed for recovering corrupted or damaged Oracle database file and the tables and the contents in it that are exported from the external source.