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