Home » Infrastructure » Unix » KUP-04063 SQLNET + NFS (hpux 11.31 Oracle 10.2.0.4)
KUP-04063 SQLNET + NFS [message #511420] Mon, 13 June 2011 00:00 Go to next message
unixman954
Messages: 2
Registered: June 2011
Junior Member
Hi. I will trying to work with HP on this but I wanted to see if anyone out there may know the fix for the issue below:

SQL> select * from ext_harness;
select * from ext_harness
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04063: unable to open log file EXT_HARNESS_27442.log
OS error Permission denied
ORA-06512: at "SYS.ORACLE_LOADER", line 19

The directory it is trying to create the log file in is an NFS mount with 777 permissions and mounted with the following options:
nfs rw,bg,nosuid,intr,wsize=32768,rsize=32768 0 2

The error only occurs when accessing via SQLNET and the directory is an NFS mount. It works the other possible connection ways:

SQL*NET + NFS => FAILURE
IPC + NFS => SUCCESS
SQL*NET + Local FS => SUCCESS
IPC + Local FS => SUCCESS

I am not a DBA so my apologies in advance it I did not include any needed information. Please let me know anyone out there has any suggestions for resolution. Thanks - Steve.
Re: KUP-04063 SQLNET + NFS [message #511444 is a reply to message #511420] Mon, 13 June 2011 02:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is the Oracle instance owner (the one that started the database) able to read and write the NFS directory (just make a "touch" to a new file)?

Do not just explain what you do and get, show us: copy and paste it here (as a text inside the post not image or attached file).

Please read OraFAQ Forum Guide.

Regards
Michel
Re: KUP-04063 SQLNET + NFS [message #511491 is a reply to message #511444] Mon, 13 June 2011 07:40 Go to previous messageGo to next message
unixman954
Messages: 2
Registered: June 2011
Junior Member
Hi -
Yes the oracle instance owner is able to write/read from the directory without a problem. The permission denied error only occurs when trying to perform the writes to the NFS mount through sqlnet. Thanks - Steve.
Re: KUP-04063 SQLNET + NFS [message #511497 is a reply to message #511491] Mon, 13 June 2011 08:33 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As I said: "Do not just explain what you do and get, show us"

Regards
Michel
Previous Topic: Should "max-shm-ids x max-shm-memory" < RAM size?
Next Topic: run sql commands in background
Goto Forum:
  


Current Time: Fri Mar 29 07:34:29 CDT 2024