RE: can't run sql script inside ksh script
Date: Sat, 21 Nov 2009 02:23:10 -0500
Message-ID: <1BB3D91289B741398B1AAE9A40919EFC_at_rsiz.com>
doh.
use should be able to use start in place of the _at_.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Masha Gurenich
Sent: Friday, November 20, 2009 4:59 PM
To: Martin Ruthner
Cc: pegramrg_at_yahoo.com; Oracle L
Subject: Re: can't run sql script inside ksh script
Thank you all!!!
The issue was resolved by copy/pasting the sql script and running it between
the <<SQLPLUS tags. it won't run "_at_script.sql" way for some reason..
Thanks again,
M
On Fri, Nov 20, 2009 at 8:01 AM, Martin Ruthner <ruthner_at_pythian.com> wrote:
Did you try this already?
/u01/app/oracle/product/bin/sqlplus dwmgr/u_pick_it_at_pds1_PURPLE <<SQLPLUS
_at_/home/dwadmin/scripts/bannerstudents.sql
exit
SQLPLUS
Martin Ruthner
Oracle DBA
The Pythian Group
Robert Pegram wrote:
This may be a long shot, but check /tmp. We just had a very similar issue the other day on a solaris machine, and /tmp was 100%.
Rob Pegram
Duke University
From: Masha Gurenich <mailto:gurenich_at_gmail.com> <gurenich_at_gmail.com>
To: Oracle L <mailto:oracle-l_at_freelists.org> <oracle-l_at_freelists.org>
Sent: Thu, November 19, 2009 5:11:09 PM
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
-- Martin Ruthner Database Administrator - The Pythian Group, Inc. Email : ruthner_at_pythian.com Work : 1.877.PYTHIAN x250 Mobile : 1.613.218.8402 IM : pythianruthner -- http://www.freelists.org/webpage/oracle-lReceived on Sat Nov 21 2009 - 01:23:10 CST