Oracle Sqlldr Error 2100
Contents |
#136502] Thu, 08 September 2005 07:02 AndyK Messages: 5Registered: September 2005 Junior Member Hello, does someone of you have experience with that error message: Message 2100 not found; No message file product=RDBMS, facility=ULMessage sqlldr message 2100 not found linux 2100 not found; No message file for product=RDBMS, facility=UL After torture google I have sql*loader-704: internal error: ulconnect: ocienvcreate [-1] at least information that probably a file called ORAUS.MSG is missing or has a wrong version. If that is true,
Sqlldr Command Not Found
could someone please tell me where I can find the right file for my system? I am using german Win2000 and Oracle 9i. Much thanks in advance, Andy Report message to a moderator
Oracle_base
Re: SQLLDR (Message 2100 not found) [message #136509 is a reply to message #136502] Thu, 08 September 2005 07:53 Mahesh Rajendran Messages: 10672Registered: March 2002 Location: oracleDocoVille Senior MemberAccount Moderator before invoking sqlldr, set your ORACLE_HOME,ORACLE_BASE and include both in PATH. export ORACLE_BASE=/u01/home export ORACLE_HOME=/u01/9i export PATH=$PATH:$ORACLE_HOME/bin Report message to a moderator Re: SQLLDR (Message 2100 not found) [message #136515 is a oracle_home reply to message #136509] Thu, 08 September 2005 08:31 AndyK Messages: 5Registered: September 2005 Junior Member Mahesh Rajendran wrote on Thu, 08 September 2005 07:53before invoking sqlldr, set your ORACLE_HOME,ORACLE_BASE and include both in PATH. export ORACLE_BASE=/u01/home export ORACLE_HOME=/u01/9i export PATH=$PATH:$ORACLE_HOME/bin Thanks for reply! But this looks like a solution for a Linux System. I tried it on my Win2000 System and it didnt work. Report message to a moderator Re: SQLLDR (Message 2100 not found) [message #136517 is a reply to message #136515] Thu, 08 September 2005 08:37 Mahesh Rajendran Messages: 10672Registered: March 2002 Location: oracleDocoVille Senior MemberAccount Moderator My apologies. I have completely ignored this. >> I am using german Win2000 and Oracle 9i. (replace export with set) use set ORACLE_HOME=youroraclehome Report message to a moderator Re: SQLLDR (Message 2100 not found) [message #136518 is a reply to message #136517] Thu, 08 September 2005 08:40 Mahesh Rajendran Messages: 10672Registered: March 2002 Location: oracleDocoVille Senior MemberAccount Moderator or set it permanently in your environment (mycompute -> environemnts -> system variable). Report message to a moderator Re: SQLLDR (Message 2100 not found) [message #136519 is a reply to message #136518] T
- Message 2100 not found If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you
Oracle Home Path
can post: click the register link above to proceed. To start viewing messages, ld_library_path select the forum that you want to visit from the selection below. Results 1 to 6 of 6 Thread: SqlLoader - Message 2100 not found Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 07-06-2001,12:06 PM #1 http://www.orafaq.com/forum/t/51572/ Nugpot View Profile View Forum Posts Member Join Date Feb 2001 Posts 129 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; http://www.dbasupport.com/forums/showthread.php?12889-SqlLoader-Message-2100-not-found 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 Reply With Quote 07-06-2001,03:11 PM #2 sambavan View Profile View Forum Posts Senior Advisor 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! Reply With Quote 07-06-2001,06:29 PM #3 Nugpot View Profile View Forum Posts Member Join Date Feb 2001 Posts 129 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 co
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create https://www.experts-exchange.com/questions/20118626/SQL-Loader-problem.html a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > SQL Loader problem Want to Advertise Here? Solved SQL Loader problem Posted on 2001-05-15 Oracle Database 1 Verified Solution 3 Comments not found 8,892 Views Last Modified: 2008-11-03 Hi I'm running a SQL*Loader command and I get the following message: Message 2100 not found; No message file for product=RDBMS, facility=UL I know that this description is very short anyone can give me an explanation for this error? 0 Question by:odnanref Facebook Twitter LinkedIn Google LVL 9 Best Solution bydbalaski Hi, There was oracle sqlldr error a note on that specific error. here it is: ======================================= Note:1081848.6 Subject: NT: MESSAGE 2100 NOT FOUND: WHEN ATTEMPTING TO START SQLLDR AT COMMAND Go to Solution 3 Comments LVL 9 Overall: Level 9 Oracle Database 8 Message Accepted Solution by:dbalaski2001-05-15 Hi, There was a note on that specific error. here it is: ======================================= Note:1081848.6 Subject: NT: MESSAGE 2100 NOT FOUND: WHEN ATTEMPTING TO START SQLLDR AT COMMAND PROMPT Type: PROBLEM Status: PUBLISHED Creation Date: 17-JAN-2000 Last Revision Date: 23-APR-2001 Copyright (c) Oracle Corp Problem Description: ==================== From an NT server, you open a DOS window and type SQLLDR. You receive the following error: MESSAGE 2100 not found: No message file for product=RDBMS, facility=ULMessage 2100 not found: No message file for product=RDBMS, facility=UL Solution Description: ===================== 1. Right click the MY COMUTER icon and select properties 2. Select the ENVIRONMENT tab 3. Look for any SYSTEM or USER variable called ORACLE_HOME 4. Delete these variables. 5. Reboot the server. Once all references to ORACLE_HOME are removed from the environment settings