RDA execution

[grapes12]

Morning guys,

I am running oracle 11g, on solaris 10.
I need to run the rda.sh script everyday, via a crontab.Problem is it needs operator intervention to type in the password, how can I pass the password in the script?

Any help will be much appreciated

 

[grapes12]

setup this script

#!/bin/ksh

export ORAENV_ASK=NO
export ORACLE_SID=MAC
PATH=$PATH:/usr/local/bin
. oraenv
unset ORAENV_ASK

PASS="sun8"
WORKDIR=/u1/oracle/product/11.2.0/db_1/rda
echo "$PASS" | $WORKDIR/rda.sh -v > $WORKDIR

But not accepting password
Any help will be highly appreciated

 

[LKBrwnDBA]

Try using "expect".


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Beilstwh]

There is a nice linux tool called expect that will allow you to pass the password. see

http://expect.sourceforge.net/

Bill
Lead Application Developer
New York State, USA

 

[Beilstwh]

I missed the message from LKBrwnDBA. Sorry

Bill
Lead Application Developer
New York State, USA

 

[grapes12]

Morning,

We dont have expect on our Solaris box.
Is there any other way?

 

[Beilstwh]

no one does, you have your system administrator download and install it. every linux box I have used has had it installed.

Bill
Lead Application Developer
New York State, USA