Unix Scripting for an Oracle Database

[waterpologuy]

Is there any specific UNIX Scripting I can Use to Determine if an Oracle Database is running?

If so, What is it?

 

[PHV]

Have you searched the FAQ area ?
faq822-2218

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mrn]

echo "‘ps -ef | grep smon|grep -v grep|awk '{print $8}'| awk -F \"_\" '{print$3}'‘"

Mike

"A foolproof method for sculpting an elephant: first, get a huge block of marble, then you chip away everything that doesn't look like an elephant."

http://www.airport-parking-site.co.uk/

 

[Annihilannic]

Is that the UUOG police I can hear coming?

Annihilannic.

 

[vgersh99]

nope, we ain't here - we IDGAF to that particular one.

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[mrn]

You guys......kill me

Mike

"A foolproof method for sculpting an elephant: first, get a huge block of marble, then you chip away everything that doesn't look like an elephant."

http://www.airport-parking-site.co.uk/

 

[p5wizard]

Well you overdid it a bit - 2 greps and 2awks...

echo $(ps -ef|awk '{if ($NF ~ /^ora_smon_...$/) print substr($NF,10,3)}')

But your pipeline shows step by step what you're doing I suppose.


HTH,

p5wizard

 

[Annihilannic]

Another variation, this is a script I call SIDswhich I use to query which DBs are running on the system:

ps -ef | sed -n '/_[p]mon_/{s/.*_[p]mon_//;p;}'

Annihilannic.

 

[mrn]

Ok Ok, I'll try harder to suppress my greppy awkness next time.

Mike

"A foolproof method for sculpting an elephant: first, get a huge block of marble, then you chip away everything that doesn't look like an elephant."

http://www.airport-parking-site.co.uk/