SqlLoader - Message 2100 not found

[Nugpot]

Hi,

We are getting the following error message, when we are trying to load data using sqlldr
oracle version -8.1.7.1
OS - Sun 2.6

Message 2100 not found; product=RDBMS; facility=UL
Message 2100 not found; product=RDBMS; facility=UL
Message 2100 not found; product=RDBMS; facility=UL
Message 2100 not found; product=RDBMS; facility=UL
Message 2100 not found; product=RDBMS; facility=UL

Though we are getting this error, we are able to load data successfully. I was not sure if I should ignore this.
Message 2100 is usually a "out of memory" error

Is there anything else I should check for??
Thanks
Vj

[sambavan]

Does this also say that it couldn't find the message, on that case you are missing some .msb and ora.msg files on your oracle install. Check $ORACLE_HOME/rdbms/mesg/

Check to make sure that you have oraus.msg and oraus.msb files under that directory. If not copy that from your server into your client and try again.

Hope this would help you.
Sam

[Nugpot]

Sambavan,
The oraus.msg and oraus.msb are there in the $ORACLE_HOME/rdbms/mesg

However, I compared that with another oracle home and that has 45 files whereas the one in which I'm having problems has 18 files. do you think I should copy all that files?

Thanks for your help
Vj

[sambavan]

Are they both of the same installation type. IF so, go ahead and copy those files that are missing. One other thing that you can do is try running the sql loader on that system and confirm that you are not getting the message on that then you can copy the missing files on to the other and try the same.

Hope this would help you,
Sam

[AgnesJey]

Hi,
I am getting the same error " Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, facility=UL"

I am using Oracle 11g in my unix system.
After searching the solution in the net , i have set the ORACLE_BASE,ORACLE_SID,ORACLE_HOME. Also the files oraus.msg and oraus.msb are under the rdbms/mesg.Eventhough i am getting the same error on running the shell script through putty.
Please help me in getting this resolved

[gandolf989]

You should verify that the LD_LIBRARY_PATH is set properly. Also check to see what character set the database is using compared to what character set the file is using.