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