Message 2100 when run sql*loader from UNIX

bash unix sql-loader
May12 picture May12 · May 2, 2012 · Viewed 28k times · Source

I have .sh file with the next content:

#!/bin/bash    
echo -------- uploader.sh v 0.1 --------
ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1/bin/
export ORACLE_HOME
PATH=$ORACLE_HOME
export PATH

sqlldr userid=PR/0611@database control=control_file.ctl LOG=fb_log.log errors=100

So, i want to run sql loader and upload data. When i run uploader.sh i receive the next message from unix:

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

I've read about it and made conclusion that the problem is in the enviroment variables. Could you help me with desision of this mistake?

Answer

Satya picture Satya · May 2, 2012

change this line 

ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1/bin/

to 

ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1

and see it

also check if you have ORAUS.MSB on your system

Related questions

How can I check if a directory exists in a Bash shell script?

What command can be used to check if a directory exists or not, within a Bash shell script?

Read More
Looping through the content of a file in Bash

How do I iterate through each line of a text file with Bash? With this script: echo "Start!" for p in (peptides.txt) do echo "${p}" done I get this output on the screen: Start! ./runPep.sh: line 3: syntax error …

Read More
How to permanently set $PATH on Linux/Unix?

I'm trying to add a directory to my path so it will always be in my Linux path. I've tried: export PATH=$PATH:/path/to/dir This works, however each time I exit the terminal and start a new terminal …

Read More