Heh, good point Mark. Sometines, I make a simple problem
complicated...;-)
On Mon, 2002-10-28 at 18:58, Mark Richard wrote:
> I could be mistaken, but isn't all this discussion about the "awk '{ print
> $8 }'" problem unwarranted...
>
> The very next portion of the command is an awk using a field seperator of
> underscore. It doesn't care if it receives the entire line from ps. Just
> remove that component and the problem is fixed. From what I can tell:
>
> ps -ef | grep smon | grep -v grep | awk -F_ '{ print $3 }'
>
> Is one way of many to get your result.
>
>
>
>
>
> Ross Collado
>
> <Ross.Collado@te To: Multiple recipients of list
>ORACLE-L <[EMAIL PROTECTED]>
> chpac.com> cc:
>
> Sent by: Subject: RE: Unix Q: Substring-ing an
>output.
> [EMAIL PROTECTED]
>
>
>
>
>
> 29/10/2002 10:24
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
> Very clever! But unfortunately, -F accepts only 1 character. I tried that
> though...
>
> Ross
>
>
> > -----Original Message-----
> > From: Henry Poras [mailto:hporas@;etal.URI.EDU]
> > Sent: Tuesday, 29 October 2002 3:43
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Unix Q: Substring-ing an output.
> >
> >
> > Quick thought. What about just setting awk -F_ to awk -Fpmon_ ???
> >
> > Henry
> >
> > -----Original Message-----
> > Bobak
> > Sent: Sunday, October 27, 2002 11:49 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hmm...good point. You know, I use this technique in various
> > places. I
> > never noticed that bug before, cause it will only appear if
> > the database
> > has been up less than 1 day. Guess it's time to do a bit of script
> > auditing.
> >
> > Ok, try this instead:
> > ps -ef|grep pmon|grep -v grep|cut -c49- |awk -F_ '{ 'print $3 }'
> >
> > I replaced the first awk w/ cut. the -c option says to cut
> > that output
> > from position 49 to the end of the line. You may have to adjust the
> > value from 49 to something else.
> >
> > That ought to work for you.
> >
> > -Mark
> > On Sun, 2002-10-27 at 22:53, Ross Collado wrote:
> > > 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).
> > >
> --
> --
> 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: Henry Poras
> 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).
>
>
>
> <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> Privileged/Confidential information may be contained in this message.
> If you are not the addressee indicated in this message
> (or responsible for delivery of the message to such person),
> you may not copy or deliver this message to anyone.
> In such case, you should destroy this message and kindly notify the sender
> by reply e-mail or by telephone on (61 3) 9612-6999.
> Please advise immediately if you or your employer does not consent to
> Internet e-mail for messages of this kind.
> Opinions, conclusions and other information in this message
> that do not relate to the official business of
> Transurban City Link Ltd
> shall be understood as neither given nor endorsed by it.
> <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>
--
--
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).
