Hi there,
When I tried to run sqlldr command from a script under HP, I got

SQL*Loader-941: Error during describe of table DBADDW2INTF.ACR_LOC_ITO
ORA-03114: not connected to ORACLE

SQL*Loader: Release 9.2.0.4.0 - Production on Fri Jul 23 07:50:57 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Anyone have any idea why it failed? All the environment are setup right....

Hi

Probably need to ensure that the environment is set up correctly when the
script runs. Make sure you set oracle_sid and oracle_home etc.

Alistair

"ultra" <ultraman@rogers_NOSPAM.com> wrote in message
news:ywRPc.41944$vO1.212309@nnrp1.uunet.ca...
> Hi there,
> When I tried to run sqlldr command from a script under HP, I got
>
> SQL*Loader-941: Error during describe of table DBADDW2INTF.ACR_LOC_ITO
> ORA-03114: not connected to ORACLE
>
> SQL*Loader: Release 9.2.0.4.0 - Production on Fri Jul 23 07:50:57 2004
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Anyone have any idea why it failed? All the environment are setup
right....
>
>

Hi there,
I think all the env are there. Here is the output.

_=/usr/bin/env
MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/ma
n:/usr/local/man/%L:/usr/local/man:/opt/graphics/common/man:/opt/ignite/shar
e/man/%L:/opt/ignite/share/man:/opt/ipf/man:/opt/mx/share/man:/usr/dt/share/
man:/opt/samba/man:/opt/resmon/share/man:/opt/perf/man/%L:/opt/perf/man:/opt
/prm/man/%L:/opt/prm/man:/opt/sec_mgmt/share/man:/opt/gnome/man:/opt/wbem/sh
are/man:/opt/sec_mgmt/share/man/%L:/opt/ssh/share/man
SHLIB_PATH=/u01/oracle/app/product/9.2.0/lib
SSH_TTY=/dev/pts/0
PATH=/u01/oracle/app/product/9.2.0/bin:/usr/bin:/etc:/usr/ccs/bin:/usr/bin/X
11:/usr/local/bin:/u01/oracle/app/product/9.2.0/jlib:/u01/oracle/app/product
/9.2.0/Apache/Apache/bin:/opt/perl/bin:/u01/oracle/app/product/9.2.0/OPatch:
/usr/sbin:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/pe
rl/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/fcms/bin:/usr/contrib/kwdb/bi
n:/opt/upgrade/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/graphics/common/bi
n:/opt/ipf/bin:/opt/cfg2html:/opt/resmon/bin:/opt/perf/bin:/opt/prm/bin:/opt
/sec_mgmt/bastille/bin:/opt/gnome/bin:/opt/mozilla:/opt/wbem/bin:/opt/wbem/s
bin:/opt/Netscape:/opt/mx/bin:/opt/sec_mgmt/spc/bin:/opt/ignite/bin:/opt/net
worker/bin:/opt/OV/bin/OpC:/opt/OV/bin:/sbin:/home/root:/opt/java1.3/bin:/op
t/java1.3/lib
ESPAGENT=DWHDB1P1
COLUMNS=132
ORACLE_BASE=/u01/oracle
ESPAPGEN=43
SSH_AUTH_SOCK=/tmp/ssh-oODb7254/agent.7254
EDITOR=vi
HISTFILE=/.sh_history
CLASSPATH=:/opt/java1.3/bin:/opt/java1.3/lib
LOGNAME=root
ESPAGENTHASH=9B1720153E2CF18E29D086F9EEEA9B7A2497B 4E4
MAIL=/var/mail/root
ESPAGENTPORT=3031
ORACLE_SID=DWP01
ERASE=^H
PS1=root@dwhdb1p1:$PWD\#
ORA_SID=DWP01
USER=root
ESPAPPL=APPNW4
TNS_ADMIN=/u01/oracle/app/product/9.2.0/network/admin
ESPOBJECT=SHELLESP/APPNW4.43/MAIN
SHELL=/sbin/sh
ORA_NLS33=/u01/oracle/app/product/9.2.0/ocommon/nls/admin/data
ESPAPPLMGR=JavaAgent#TCPIP@CENTRAL_MANAGER
HOME=/seatapp/dwh/estrazioni
ORA_LOGIN=dbaddw2intf/dbaddw2intf
ESPAGENTDIR=/opt/esp
SSH_CLIENT=10.174.69.168 2973 22
LD_LIBRARY_PATH=/u01/oracle/app/product/9.2.0/lib
TERM=vt100
ORACLE_HOME=/u01/oracle/app/product/9.2.0
PWD=/opt/esp
ESPWOB=SHELLESP
TZ=MET-1METDST
LINES=47
SQL*Loader-941: Error during describe of table DBADDW2INTF.ACR_LOC_ITO
ORA-03114: not connected to ORACLE

SQL*Loader: Release 9.2.0.4.0 - Production on Mon Aug 2 15:45:49 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

1

and the script

#!/sbin/sh

#HOME=/home1/seatapp/dwh/estrazioni

export ORA_LOGIN=dbaddw2intf/dbaddw2intf
export ORA_SID=DWP01
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=$ORACLE_BASE/app/product/9.2.0
export ORACLE_SID=DWP01
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export SHLIB_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export
PATH=$ORACLE_HOME/bin:/usr/bin:/etc:/usr/ccs/bin:/usr/bin/X11:/usr/local/bin
:$ORACLE_HOME/jlib:$ORACLE_HOME/Apache/Apache/bin
:/opt/perl/bin:$ORACLE_HOME/OPatch:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin

env
#cd /home1/seatapp/dwh/estrazioni/shell

############
sqlldr userid=dbaddw2intf/dbaddw2intf
data=/seatapp/dwh/estrazioni/input_bck/F_PGO/2004-07-16/F_PGO_acr_loc_ito.da
t control=/seatapp
/dwh/estrazioni/ctl/F_PGO/acr_loc_ito.ctl
log=/seatapp/dwh/estrazioni/logs/F_PGO/shell_ESP.log
bad=/seatapp/dwh/estrazioni/logs/F_PG
O/acr_loc_ito.bad discard=/seatapp/dwh/estrazioni/logs/F_PGO/acr_loc_ito.dsc
direct=true

# === Controllo errore
echo $?
#env
#cat /seatapp/dwh/estrazioni/logs/F_PGO/shell_ESP.log | grep "ORA-" >
shell_ESP.check
#if [[ -s shell_ESP.check ]]

"Alistair Thomson" <alistair@despammed.com> wrote in message
news:41110a25$0$41797$65c69314@mercury.nildram.net ...
> Hi
>
> Probably need to ensure that the environment is set up correctly when the
> script runs. Make sure you set oracle_sid and oracle_home etc.
>
> Alistair
>
> "ultra" <ultraman@rogers_NOSPAM.com> wrote in message
> news:ywRPc.41944$vO1.212309@nnrp1.uunet.ca...
> > Hi there,
> > When I tried to run sqlldr command from a script under HP, I got
> >
> > SQL*Loader-941: Error during describe of table DBADDW2INTF.ACR_LOC_ITO
> > ORA-03114: not connected to ORACLE
> >
> > SQL*Loader: Release 9.2.0.4.0 - Production on Fri Jul 23 07:50:57 2004
> >
> > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> >
> > Anyone have any idea why it failed? All the environment are setup
> right....
> >
> >
>
>