Search code examples
bashunixsql-loader

Message 2100 when run sql*loader from UNIX

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?

Solution

  • 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