SqlLoader - Message 2100 not found
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: SqlLoader - Message 2100 not found

  1. #1
    Join Date
    Feb 2001
    Posts
    128
    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

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Feb 2001
    Posts
    128
    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

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Aug 2013
    Posts
    1

    Message 2100 not found; No message file for product=RDBMS, facility=UL

    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

  6. #6
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021
    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.
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width