Shell Programming and Scripting

Hi

How do i cut from this output so i only get db name

ps -ef |grep smon

oracle 29375 1 0 Nov 9 ? 8:08 ora_smon_HWEX62


i.e only want HWEX62

also bearling in mind that some database have been running from hours and some servers have different time and date formats

i.e

oracle 5917 1 0 18:32:18 ? 12:33 ora_smon_REPORT

Try this:

Code:

value="oracle 29375     1  0  Nov  9  ?         8:08 ora_smon_HWEX62"
databasename=`echo ${value} | cut -d " " -f9 | cut -d "_" -f3`

echo $databasename

I may have got the 'f' wrong but its a start...

Code:

ps -ef | grep smon | awk -F_ '{print $(NF)}'

Code:

ps -ef | awk -F_ '/smon/{print $(NF)}'

Or maybe :

Code:

ps -ef|awk -F_ '/[s]mon/{print$NF}'

thanks i get below output

but how do i get rid of top and bottom lines so im only left with db name

$ ps -ef|awk -F_ '/[s]mon/{print$NF}'
client
root 1749 1 0 Jun 11 ? 0:00 /etc/opt/resmon/lbin/emsagent
EUP10ARS
root 29682 1076 0 Jan 8 ? 0:05 /etc/opt/resmon/lbin/registrar


$ ps -ef |grep smon
root 3372 1 0 Jun 11 ? 5066:34 /etc/opt/resmon/lbin/p_client
root 1749 1 0 Jun 11 ? 0:00 /etc/opt/resmon/lbin/emsagent
oracle 11365 1 0 Mar 26 ? 10:35 ora_smon_EUP10ARS
root 29682 1076 0 Jan 8 ? 0:05 /etc/opt/resmon/lbin/registrar
unixadm 18294 17788 1 18:06:45 pts/1 0:00 grep smon

OK,
then try this:

Code:

ps -ef|awk -F_ '/[o]ra_smon/{print$NF}'