Search This Blog

Monday, February 25, 2008

sqlldr not working on Linux/Unix/Solaris or Windows

When we face below message when try to run "sqlldr" on windows system

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

then please check metalink note: 1081848.6



When we face below message on *nix platform during running "sqlldr"

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


Possible Reasons:

1. Oracle Enviourment Variable is not set-up properly

1. ORACLE_HOME, 2. ORACLE_SID, 3. PATH

2. Linux User don't have sufficient permission on $ORACLE_HOME/bin folder
3. Message 2100 not found:

$ oerr sql 2100
02100, 00000, "Out of memory (i.e., could not allocate)"
// *Cause: SQLLIB was unable to allocate enough memory to execute
// the program.
// *Action: Allocate more memory to the user session, then rerun the
program.
// If the error persists, call customer support for
assistance.
$ oerr ul 2100
2100, 0, "%s"

4. Linux user is not a member of DBA group
5. Faulty Oracle Installation

3 comments:

Babu B said...

Thank You taj.

Prashant said...

Taj U r God of DBA. i am a regular visiter of ur blog... Thanks 4 sharing such a valuable info.

Ilangovan said...

Hi Guru,

I run the sqlldr from a shell script and is working fine. I run the same script as a cron job and is giving this error.

How do I run it from a cron job? OR what is missing in the cron job?