Re: AIX question

From: De DBA <dedba_at_tpg.com.au>
Date: Wed, 04 Jun 2014 12:28:12 +1000
Message-ID: <538E843C.2060100_at_tpg.com.au>



I use this (linux, GNU awk) to list running instances:
         ps -eo cmd | egrep -i '(ora|xe)_pmon' | awk '{tst = substr ($1, 1,4) ;
                 if (tst != "grep") {
                   if ( tst != "ora_" )
                      print substr($1,9,length ($1) )
                   else
                      print substr($1,10,length ($1) )
                 }
              }' | sort;


Hth,
Tony

On 04/06/14 12:12, Andrew Kerber wrote:
> I have a script that runs the loop below:
>
> for ORACLE_SID in `ps -e -o="CMD" | grep smon|grep -v grep| awk -F "_" '{print$3}'`
> do
> ....
> done
>
> The problem that just came up is a rac one node instance, where the ORACLE_SID is orcl_1 or orcl_2
>
> So the script above, in a standard rac instance would find orcl1 or orcl2, which is what I want. But with Rac one node, and the underscore in the name it just extracts orcl, when I need to extract orcl_1.
>
> Can one of you scripting gurus show me a corrected version of that for loop that gets the correct ORACLE_SID?
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 04 2014 - 04:28:12 CEST

Original text of this message