Shell Programming and Scripting

Hi,

I am not sure whether i can post this question in this forum or not. because it is not completely releated to unix, but also oracle.

My question is,
How can we know the instance name(particularly the last number, eg., in INST_DB12, i need 12) when it is OFFLINE(i.e., down) through a Shell script.

Suppose if we have 2 instances INST_DB11 and INST_DB12, and we have made one of them, say INST_DB12, down.

And if we know the instance names, we can directly export it from Linuz prompt and startup the instance using sqlplus as below:

Code:

 
$ export ORACLE_SID=INST_DB12
$ sqlplus as sysdba
SQL>startup;
...
...
...
SQL>exit;
$

But if we dont know the instance name, how can we know the instance name to export it before starting up..?

To my knowledge, we can get the instance names by 3 ways.
one is

Code:

 
ps -ef | grep pmon

from which we can get the instance name.

Other one is

Code:

 
/opt/oracle/product/10.2.0/crs/bin/crs_stat -t

using the above command, we can know which one is online or offline.
but i am unable to trust its output because sometimes, the status is showing as UNKNOWN instead of either ONLINE or OFFLINE.

Third one is using file.
But this file consists of all the instance names, but no information whether they are online or offline.

so unable to trust in all the three ways, and so failed to solve this issue.

I need to get the insance name including with the number at the end(12 in INST_DB12) through a shell script.

Please help me in this regard.

So what keeps you from combining the 2 methods you trust partly?
The result could look like this:

Code:

OIFS=$IFS
IFS=:
while read O_SID DUMMY
do
   if ps -ef |grep pmon |grep -v grep >/dev/null
   then
      echo $O_SID is up
   else
      echo $O_SID is down
   fi
done </etc/oratab
IFS=$OIFS