Home » RDBMS Server » Server Utilities » SQLLDR (Message 2100 not found)
SQLLDR (Message 2100 not found) [message #136502] Thu, 08 September 2005 07:02 Go to next message
AndyK
Messages: 5
Registered: 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 2100 not found; No message file for product=RDBMS, facility=UL


After torture google I have at least information that probably a file called ORAUS.MSG is missing or has a wrong version.
If that is true, 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
Re: SQLLDR (Message 2100 not found) [message #136509 is a reply to message #136502] Thu, 08 September 2005 07:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account 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

Re: SQLLDR (Message 2100 not found) [message #136515 is a reply to message #136509] Thu, 08 September 2005 08:31 Go to previous messageGo to next message
AndyK
Messages: 5
Registered: September 2005
Junior Member
Mahesh Rajendran wrote on Thu, 08 September 2005 07:53

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





Thanks for reply!
But this looks like a solution for a Linux System. I tried it on my Win2000 System and it didnt work.
Re: SQLLDR (Message 2100 not found) [message #136517 is a reply to message #136515] Thu, 08 September 2005 08:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account 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

Re: SQLLDR (Message 2100 not found) [message #136518 is a reply to message #136517] Thu, 08 September 2005 08:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
or
set it permanently in your environment (mycompute -> environemnts -> system variable).
Re: SQLLDR (Message 2100 not found) [message #136519 is a reply to message #136518] Thu, 08 September 2005 08:47 Go to previous messageGo to next message
AndyK
Messages: 5
Registered: September 2005
Junior Member
No need for apologies.
The Path-Variable is allready set, any ideas what else I could do?
Re: SQLLDR (Message 2100 not found) [message #136526 is a reply to message #136519] Thu, 08 September 2005 09:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
usually, the error rises in these situations.

ORACLE_HOME not properly set
PATH not having proper ORACLE_HOME
there are multiple ORACLE_HOMEs in the machine and you are looking into wrong ORACLE_HOME.
your ORACLE_HOME is set in environment and a different ORACLE_HOME is in your registry.
a very out of normal value for NLS_DATE_FORMAT /NLS_LANG in registry/environment.

in command prompt type 'set'.
It should display the current settings.
check it out.

If nothing works, just reinstall the client

Re: SQLLDR (Message 2100 not found) [message #136641 is a reply to message #136502] Fri, 09 September 2005 04:27 Go to previous message
AndyK
Messages: 5
Registered: September 2005
Junior Member
Thank you for your efforts,


after some more trials I reinstalled the oracle client and now it works very fine. I should have done it much earlier but it is always some trouble to get Admin-rights to install something...

Cya and have a nice weekend,


Andy
Previous Topic: Exporting USER DLL only
Next Topic: User Mode Import
Goto Forum:
  


Current Time: Tue Apr 23 05:03:05 CDT 2024