Re: can't run sql script inside ksh script
- From: Robert Pegram <pegramrg@xxxxxxxxx>
- To: gurenich@xxxxxxxxx, Oracle L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 20 Nov 2009 04:53:42 -0800 (PST)
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 <gurenich@xxxxxxxxx>
To: Oracle L <oracle-l@xxxxxxxxxxxxx>
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@pds1_PURPLE
@/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
Other related posts:
