Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr problem
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
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:/optbin:/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
/sec_mgmt/bastille/bin:/opt/gnome/bin:/opt/mozilla:/opt/wbem/bin:/opt/wbem/s
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
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_at_despammed.com> wrote in message news:41110a25$0$41797$65c69314_at_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_at_rogers_NOSPAM.com> wrote in message > news:ywRPc.41944$vO1.212309_at_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.... > > > > > >Received on Wed Aug 04 2004 - 12:42:47 CDT