RE: Automate analyze - can't log in

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Mon, 29 Aug 2005 10:12:56 -0700 (PDT)
Message-ID: <20050829171256.16274.qmail@web80507.mail.yahoo.com>

As cron are you setting up the env upfront. your oracle_Home oracle_SId etc.
its possible that might be the cause of not logging inot the database

"Mercadante, Thomas F (LABOR)" <Thomas.Mercadante_at_labor.state.ny.us> wrote: J. Dex,

Have you tried running this on the command line? My guess is that logging in as SYS is giving you a problem.

You need to connect as sysdba or connect as the schema owner. I would use the schema owner - there is no real reason to use SYS to gather these stats.

Tom

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex Sent: Monday, August 29, 2005 11:39 AM
To: oracle-l_at_freelists.org
Subject: Automate analyze - can't log in

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 "
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/

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 29 2005 - 12:15:03 CDT