SQL*Loader: Release 188.8.131.52.0 - Production on Tue Aug 21 09:13:31 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL*Loader-128: unable to begin a session
ORA-03113: end-of-file on communication channel
Environment : Oracle 8.1.7 Enterprise Ed.[64 Bits] HP-UX 11.00 64 Bits
I appreciate your valuable help.
It could be due to a wide array of problems. There is a Note in the metalink which talks about the possible scenarios. Note: 1003596.6
Check to make sure that you have your LD_LIBRARY_PATH, had been set correctly. Were you able to make a normal sqlplus connection to the database? How do you pass the SID to chich the oracle has to make connection to? Check your oratab file to make sure the paths had been set correctly.
I checked the path. It's okay. I could run the loader when I login with oracle id from unix box. But it fails when I login with developer id(who actually execute the job) from unix box.
I can't even invoke sqlplus. Echo $PATH and echo $ORACLE_SID shows me the right env. variable. I check the
Note: 1003596.6, however it does not point to my problem.
I am running the statement from the box itself.