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 <gurenich@xxxxxxxxx> <gurenich@xxxxxxxxx> > *To:* Oracle L <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 > >