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?

Answers


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


Need Your Help

database query hangs to DB2 server, using tomcat connection pool in java code

java tomcat db2 jndi connection-pooling

I have developed a web application and using Tomcat connection pool,Java code is triggering query to DB2 server, sometimes it runs fine and return the result, but sometime it hangs i.e. the query w...

PHP - parsing javascript array using a preg_match()

php html-parsing preg-match

I have a problem with parsing a HTML page. There is a variable in javascript that I need to get it and put it into json format.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.