your script should look like ... connect / as sysdba exec blah_1; exec blah_2; exit and then change your sqlplus call in the shell script to $ORACLE_HOME/bin/sqlplus -s /nolog @fully_qualified_script_name_here Raj On 8/29/05, J. Dex <cemail_219@xxxxxxxxxxx> wrote: > > I am trying to automate analyze through cron. The shell script is unable > to > login to Oracle and I am still not sure why. Is there an easier way to do > this or can someone tell what I am doing wrong? > I wanted to be able to pass parameters so that I can use it on various > databases: > > /u01/app/oracle/product/9.2.0/bin/sqlplus sys/$sysdbapass > @/u01/app/tools/analyze_db.sql; > > > > > #!/bin/ksh > > #*************************************************************************** > # Program: Analyze database > # > # Will analyze target database > > #*************************************************************************** > > if [ $# -ne 1 ] > then echo "Usage Error. Usage: $0 <sid name>" > exit 1 > export ORACLE_SID=$1 > fi > ORACLE_SID=$1 > export ORACLE_SID > > . /u01/app/oraconfig/Oracle.env.vars > sysdbapass=`cat /home/oracle/.passwddba.$ORACLE_SID` > export sysdbapass > /u01/app/oracle/product/9.2.0/bin/sqlplus sys/$sysdbapass > @/u01/tools/analyze_db.sql; > > exit > EOF > exit 0 > ~ > > _________________________________________________________________ > Don't just search. Find. Check out the new MSN Search! > http://search.msn.click-url.com/go/onm00200636ave/direct/01/ > > -- > //www.freelists.org/webpage/oracle-l > -- ------------------------------ select standard_disclaimer from company_requirements where category = 'MANDATORY';