Cannot start SQL*loader on UNIX box

[pdtt]

I am trying to invoke SQL*loader on a Sun OS box. Oracle 8.1.7 is installed on the machine and I am connecting to the database on the box. the set command shows that the oracle bin directory is in the path. However when I type in sqlldr I get this error:

Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDB
MS, facility=UL

Has anyone seen this message before? what does it mean?

Thank you

 

[Turkbear]

Hi,
Check your environment settings -
Be sure ORACLE_HOME and TNS_ADMIN ( or ORACLE_SID if you only want to connect to one instance) is set as well as checking the Shared Library paths to be sure the Oracle ones are included..

 

[pdtt]

Hi Turkbear,

When I run the set command, I do not have an ORACLE_HOME
or TNS_ASMIN setting. ORACLE_SID is "ORACLE_SID=pwd". I am new to this. How would I set those variables?

Thank you

 

[Turkbear]

It depends a little on the shell but
set ORACLE_HOME=/wherever/you/haveit/installed;export ORACLE_HOME
same method for TNS_ADMIN and set it to $ORACLE_HOME/network/admin

Look closely at the installation docs and release notes..There is a script that set these for you and needs to be run as root, I believe..Be sure you follow all the release notes/docs exactly if you expect this to be a stable and useful installation.

After determining your settings for these, add the set commands to your .profile ( or similar)..

 

[pdtt]

Thanks again Turkbear,

The variables were blank for some reason. I had someone reset them for me.

sqlldr is now running for me.