Removing unwanted characters 1

[mhauff65]

Hello

Here's the code
ps -ef |grep pmon |grep -v grep |awk '{print $9}'
which returns this:
ora_pmon_DEV_ORCL1
ora_pmon_ORCL2
ora_pmon_DEV_ORCL3
ora_pmon_ORCL4
ora_pmon_DEV_ORCL5

When I tried another iteration to awk to just get the SIDS
with this code:
ps -ef |grep pmon |grep -v grep |awk '{print $9}' |awk -F_ '{print $3}'
which returns this:
DEV
ORCL2
DEV
ORCL4
DEV

I tried using the sub function but I can not get the syntax correct. How do I get just the SIDs
i.e.
DEV_ORCL1
ORCL2
DEV_ORCL3
ORCL4
DEV_ORCL5

Any help anyone can provide is greatly appreciated

 

[PHV]

ps -ef | awk '$9~/^ora_pmon/{x=$9;sub(/ora_pmon_/,"",x);print x}'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mhauff65]

Thank You Thank You Thank You. Nice and Clean!

Thanks for your help.