| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Automate analyze - can't log in
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 <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
~
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 29 2005 - 10:49:00 CDT
 |
 |