RE: can't run sql script inside ksh script

doh.

 

use should be able to use start in place of the @.

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Masha Gurenich
Sent: Friday, November 20, 2009 4:59 PM
To: Martin Ruthner
Cc: pegramrg@xxxxxxxxx; 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 "@script.sql"  way for some reason.. 

Thanks again,
M

On Fri, Nov 20, 2009 at 8:01 AM, Martin Ruthner <ruthner@xxxxxxxxxxx> wrote:

Did you try this already?

/u01/app/oracle/product/bin/sqlplus dwmgr/u_pick_it@pds1_PURPLE  <<SQLPLUS


@/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@xxxxxxxxx> <gurenich@xxxxxxxxx>
To: Oracle L  <mailto:oracle-l@xxxxxxxxxxxxx> <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

 

 

-- 
Martin Ruthner
Database Administrator - The Pythian Group, Inc.
Email  : ruthner@xxxxxxxxxxx
Work   : 1.877.PYTHIAN x250
Mobile : 1.613.218.8402
IM     : pythianruthner

 

Other related posts: