Home » RDBMS Server » Server Utilities » SQL*Loader/Cron
SQL*Loader/Cron [message #73430] Mon, 26 April 2004 04:40 Go to next message
Maxim
Messages: 2
Registered: July 2003
Junior Member
Hello.

I have some problem with SQL*loader. I can run shell script, using CLI mode. Script works properly and data has been loaded into the DB. Whenever I try to use SQL*Loader from a shell script in cron I get an error:

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



If somebody has any ideas, please tell.

Thank you in advance.

Maxim.

Report message to a moderator

Re: SQL*Loader/Cron [message #73478 is a reply to message #73430] Fri, 07 May 2004 23:41 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

You will get this error if your environment is not properly set-up. You need to explicitly set all the Oracle environment variables like ORACLE_HOME, ORACLE_SID, etc.

TIP: Add the "env" command in your shell script so you can see the variables that is missing or incorrect.

Best regards.

Frank

Report message to a moderator

Re: SQL*Loader/Cron [message #73928 is a reply to message #73478] Wed, 04 August 2004 03:10 Go to previous messageGo to next message
sajeesh vijayan
Messages: 1
Registered: August 2004
Junior Member
How to add the "env" variable into tha script.
Can you give an examole script?

Report message to a moderator

Re: SQL*Loader/Cron [message #74249 is a reply to message #73430] Wed, 20 October 2004 08:14 Go to previous messageGo to next message
Fabio
Messages: 23
Registered: October 2001
Junior Member
Try to set ORACLE_HOME variable using ORACLE path.

Report message to a moderator

Re: SQL*Loader/Cron [message #74342 is a reply to message #73928] Thu, 18 November 2004 23:19 Go to previous message
kzy
Messages: 1
Registered: November 2004
Junior Member
Because sqlldr will
fork a new shell you must set and export the necessary Oracle
environment variables within the cron script.
add new lines into your shell file like the following:
# ------------------------------------
RACLE_BASE=/u01/product
export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/oracle9i
export ORACLE_HOME

ORACLE_SID=zxin
export ORACLE_SID

PATH=.:$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib
export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
export NLS_DATE_FORMAT="YYYY.MM.DD HH24:MI:SS"
export LIBPATH=$LIBPATH:$ORACLE_HOME/lib
export ORACLE_BASE ORACLE_HOME PATH LD_LIBRARY_PATH ORA_NLS33 CLASSPATH
# ------------------------------------------

Report message to a moderator

Previous Topic: Data source name not found and no default driver
Next Topic: TAB delimiter problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 01:57:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.