Shell script and Oracle9i RAC

xblackbox · #1 (**permalink**) 02-01-05, 23:54

I want use a script to check all instance in a RAC database, and listener from a node. Anyone have a script, please show me!
Thanks!

THANKS

vgersh99 · #2 (**permalink**) 02-02-05, 00:16

would using tnsping help in anyway? [hint]

xblackbox · #3 (**permalink**) 02-02-05, 00:22

Please tell me more, please.
I want make sure all of instance in RAC is available using a script! That is similar a script to check listener and instance in a single server. Please!

vgersh99 · #4 (**permalink**) 02-02-05, 00:30

don't know much about RAC......
for tnslistener, you can use 'tnspint $SID'
for 'instance' you can you try to connect with sqlplus and try to 'select from dual'. Something like this should get you started - modifying USER/PASSWD:

Code:

#!/usr/bin/ksh
typeset -irx TRUE=0
typeset -irx FALSE=1

USER='myUser'
PASSWD='myPasswd'

function Is_Oracle_OK
{
   if   print "
         select dummy||'OK' from dual;
         " | sqlplus -s ${USER}/${PASSWD} | grep -q XOK
   then return ${TRUE}
   fi
   return ${FALSE}
}

if   Is_Oracle_OK
then print "Oracle is up"
else print "Oracle is down"
fi

http://www.tek-tips.com/faqs.cfm?fid=2218

xblackbox · #5 (**permalink**) 02-02-05, 00:49

I want use srvctl.
to make sure all instance in RAC is OPEN status, I dont know much about shell script, please show me the way to use ouput of srvctl, and of the results of v$active_instances view. THANKS!

vgersh99 · #6 (**permalink**) 02-02-05, 01:04

how would you use srvctl from the command line?
what would it be its sample output?
what desired end result would you like to have base on the sample output of srvctl?

Try unswering these questions and maybe check the Oracle forum - they might already have an FAQ or something.

Internet Services

Web Development

Digital Marketing

Consumer Tech