Friday, October 28, 2022

[SOLVED] Message 2100 when run sql*loader from UNIX

Issue

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



Answered By - Satya
Answer Checked By - Dawn Plyler (WPSolving Volunteer)
at