Re: Message 2100 not found; No message file for product=RDBMS

spraveen2001_at_yahoo.com (Praveen) wrote in message news:<98d8ec76.0302272258.4febc713_at_posting.google.com>...
> Hi All,
>
> I'm running shell script using cronjob, in that shell script, i'm
> running sqlldr..but getting this problem.
>
> Message 2100 not found; No message file for product=RDBMS,
> facility=ULMessage 2100 not found; No message file for product=RDBMS,
> facility=UL
>
> my oracle home is : /usr/oracle/ora81
> running sqlldr using : /usr/oracle/ora81/bin/sqlldr....
>
> I Searched in net for help, some one said that, it is installation
> problem,we have to set environment varaibles. If yes, which are all
> the env variables we need to set to get rid of the above problem.
> Please Help
>
> Thanks in Advance,
> Praveen

Always read Oracle installation docs before and while doing the installtion.

Depending on which *nix flavor you are on, you should modify oracle user's profile and add environment variables and modify path. e.g.

ORACLE_HOME=/usr/oracle/ora81 export ORACLE_HOME PATH=$PATH:$ORACLE_HOME/bin export PATH

Review Oracle docs to setup other env. variables e.g. LD_LIBRARY_PATH etc.

Regards
/Rauf Sarwar Received on Fri Feb 28 2003 - 19:30:45 CET