Counting Oracle Servers

From: <thomasl_at_expansion.com>
Date: 1997/11/17
Message-ID: <64oa9a$rj4@ecuador.earthlink.net>#1/1

If the Oracle server is running on a unix machine, you can always telnet in and do : ps -ef | grep ora

That will return something like:

oracle     148     1  0.0   Oct 24 ??          17:29.72 ora_snp0_<SID>
oracle    3452     1  0.0   Oct 24 ??           5:11.66 ora_smon_<SID>
oracle    9648     1  0.0   Oct 24 ??           4:49.17 ora_lgwr_<SID>
oracle   10214     1  0.0   Oct 24 ??           0:40.76 ora_pmon_<SID>
oracle   10292     1  0.0   Oct 24 ??          19:42.35 ora_dbwr_<SID>
oracle   10294     1  0.0   Oct 24 ??           1:46.33 ora_d000_<SID>
oracle   10307     1  0.0   Oct 24 ??           0:00.34 ora_s000_<SID>
oracle   10308     1  0.0   Oct 24 ??           0:06.74 ora_reco_<SID>

These are processes that are started by the server.

TNSPINGS only tells you if the LISTENER device is running.

Thomas

In article <879668169.21163_at_dejanews.com>, muk_at_giasbga.vsnl.net.in writes:

>Hi,
>
> We wanted to determine if a Oracle server is running on a
>machine from a remote machine. How can this be done? Is it possible
>to check for a process using RPC?
>
>Thanks,
>Mukund S
>muk_at_giasbga.vsnl.net.in
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Mon Nov 17 1997 - 00:00:00 CST