Browsing through my Sed and Awk book following up on Mark's lead, I came up
with this:
ps -ef|grep pmon|grep -v grep|awk '{ print $NF }'|awk -F_ '{ print $3 }'
TLDEV
TLQA
TLQAVAR
DBMON
RMAN
PRDINF
TLDVVAR
That'll do fine !
Thanks again.
Ross
> -----Original Message-----
> From: Ross Collado
> Sent: Monday, 28 October 2002 14:50
> To: '[EMAIL PROTECTED]'
> Subject: RE: Unix Q: Substring-ing an output.
>
>
> Thanks Mark.
>
> Yes that helps, in a way. I could use good ol' awk to parse
> the last field! However, a slight problem in the ps -ef
> output. If I do what you have suggested on my 'ps -ef'
> output below, I would only get RMAN as it is the only one in
> field #8. All the rest are in field #9. All I need now is
> figure out how to cut the last field then pipe it to your awk command.
> Ok I'm getting somewhere!
>
> Rgds,
> Ross
>
>
>
> > -----Original Message-----
> > From: Mark J. Bobak [mailto:mark@;bobak.net]
> > Sent: Monday, 28 October 2002 13:54
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Unix Q: Substring-ing an output.
> >
> >
> > As is often the case, there are a million ways to do this.
> Given the
> > output listed, I'd do something like:
> >
> > ps -ef|grep pmon|grep -v grep|awk '{ print $8 }'|awk -F_ '{
> > print $3 }'
> >
> > ps -ef -- get the programs that are running
> > grep pmon -- get only those lines that have 'pmon' in them
> > grep -v grep -- drop out the line that has 'grep pmon'
> > awk '{ print $8 }' -- get the eighth column, the program name
> > awk -F_ '{ print $3 }' -- parse the program name on the '_'
> and return
> > the third field, the database name.
> >
> > Hope that helps,
> >
> > -Mark
> >
> > On Sun, 2002-10-27 at 20:43, Ross Collado wrote:
> > >
> > > Hi All,
> > >
> > > I want to feed my shell script with the names of currently running
> > > databases. I thought of using ps -ef|grep [p]mon. What I
> > got was the
> > > following:
> > > oracle 20113 1 0 Oct 25 ? 0:01 ora_pmon_TLDEV
> > > oracle 898 1 0 Jul 22 ? 0:06 ora_pmon_TLQA
> > > oracle 944 1 0 Jul 22 ? 0:07 ora_pmon_TLQAVAR
> > > oracle 19588 1 0 Oct 25 ? 0:00 ora_pmon_DBMON
> > > oracle 13509 1 0 12:16:13 ? 0:00 ora_pmon_RMAN
> > > oracle 20450 1 0 Oct 25 ? 0:00 ora_pmon_PRDINF
> > > oracle 13026 1 0 Oct 26 ? 0:00 ora_pmon_TLDVVAR
> > >
> > > What I wanted is get only the db name part eg. TLDEV, RMAN,
> > DBMON,etc. I
> > > don't want to rely on oratab file.
> > > I was thinking of using 'cut' to cut out the last field and
> > do some ${X##}
> > > (variable pattern substitution) to get to the dbname bit.
> > The trouble is
> > > the number of fields in a ps -ef output is not consistent.
> > As you can see
> > > I've just restarted RMAN and now it only has 8 fields as
> > compared to 9 for
> > > the others.
> > >
> > > Any suggestions? Or another way of doing it?
> > > Using KSH on Solaris 8.
> > >
> > > Thanks.
> > > Ross
> > --
> > --
> > Mark J. Bobak
> > Oracle DBA
> > [EMAIL PROTECTED]
> > "It is not enough to have a good mind. The main thing is to use it
> > well."
> > -- Rene Descartes
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Mark J. Bobak
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ross Collado
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
