| SQL*Loader-500 error & OSD-04002 error [message #70599] |
Thu, 04 July 2002 13:53  |
Simone
Messages: 7
Registered: September 2000
|
Junior Member |
|
|
Background:
Error posted in logfile when running job in "batch" that is job has been initiated WinAT schedule entry. This process has been running successfully since '99. FYI: when run interactively record loaded successfully - no error. File path / destination has not been changed. And according to support colleagues no changes made have been made on NT server.
Error Msg in logfile:
"SQL*Loader-500: Unable to open file (input file path)
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied"
Info found on Error msgs on Oracle website:
SQL*Loader-500
Cause:- SQL*Loader could not open the named file
Action:- Check operating system msg below this one in the log file.
Hence OSD Msg search...
OSD-04002 Unable to open file
Cause:- The specified path or filename is invalid, or the destination device is full. This error can also be caused by insufficient Windows NT file handles.
Action:- Make sure the path and file exist, and the device has free space. If this fails, increase the number of Windows NT file handles.
With reference to the Windows NT file handles checked CONFIG.NT file in system32 dir and it was set to 20. We increased to 200 and tested execution of the "batch" job again. No change still same errors posted and interactive still successful, as described in section: Background.
Any ideas out there??? Would appreciated any comments or guidence in this matter.
Thank you.
Regards,
Simone
|
|
|
|
| Re: SQL*Loader-500 error & OSD-04002 error [message #70600 is a reply to message #70599] |
Thu, 04 July 2002 15:19  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
The system is unable to locate the file you specified. If you are running
the command from a directory other than where the actual file resides, then you
will get the above mentioned error.you must specify the full path to where the
file resides.
Oracle server can't use UNC paths (ie. \hostshare)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
