Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr problem

Re: sqlldr problem

From: ultra <ultraman_at_rogers_NOSPAM.com>
Date: Wed, 4 Aug 2004 13:42:47 -0400
Message-ID: <ve9Qc.42261$vO1.215259@nnrp1.uunet.ca>


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=9B1720153E2CF18E29D086F9EEEA9B7A2497B4E4 MAIL=/var/mail/root
ESPAGENTPORT=3031
ORACLE_SID=DWP01
ERASE=^H
PS1=root_at_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_at_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_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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US