RE: can't run sql script inside ksh script
Date: Thu, 19 Nov 2009 20:40:52 -0600
Message-ID: <AD0CB572A820AB4E8E52ABD38950FD36085668D2_at_a0001-xpo0150-s.hodc.ad.allstate.com>
Make sure that you specify and export the ORACLE_SID, ORACLE_HOME and PATH in your script.
ORACLE_SID=BLAH;export ORACLE_SID
ORACLE_HOME=`grep BLAH: /etc/oratab|awk -F: '{print $2}'`;export
ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH;export PATH
Then run your sql command. It should be fine.
HTH, Bambi.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Masha Gurenich
Sent: Thursday, November 19, 2009 4:11 PM
To: Oracle L
Subject: can't run sql script inside ksh script
Hi all,
This one just drives me nuts..
I have a shell script that works OK while I am running it manually. It
runs OK via cron up to the point where sql script should be executed:
<<<bla-bla>>>
/u01/app/sghe/dw/dwprod/app/scripts/dapstart
/u01/app/sghe/dw/dwprod/app/scripts/webstart
/u01/app/oracle/product/bin/sqlplus dwmgr/u_pick_it_at_pds1_PURPLE
_at_/home/dwadmin/scripts/bannerstudents.sql <<SQLPLUS
exit
SQLPLUS
the bannerstudents.sql is not being executed.. this is what i see in log
file:
<<<bla-bla>>>
- DegreeWorks Web Message Queue: Key: 513 = 0x201 ===== MsgQ Key MsgId Owner Perms #Bytes #Msgs 0x00000201 2326529 dwadmin 666 0 0
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Nov 19 15:13:08 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
Disconnected from Oracle Database 10g Enterprise Edition Release
10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
~
that's it!! it connects to sqlplus, but doesn't execute the script.
WHY???
Please, help me. I have tons of scripts like that and all of them are
working. what is wrong with that one??
thanks beforehand,
M
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 19 2009 - 20:40:52 CST