Re: How can I find how many instances in a server

Shaochun Lin wrote:
>
> How many instances in a server(down or up). Is there a
> way we can find it or some UNIX file storing this kind of info.
> Any words would be appreciated. Thanks, Shaochun,

        An easy way to determine is instances are up on a server would be to type a command like the following

        ps -elf | grep ora_pmon

which would return the process monitor processes on a server for each Oracle instance, where the ora_pmon is suffixed by the ORACLE_SID.

Later,
Spencer Olson
spencer_olsen_at_ssb.com Received on Thu May 01 1997 - 00:00:00 CDT