Re: How many instances are created in the server?

From: gazzag <gareth_at_jamms.org>
Date: Tue, 15 Apr 2008 02:59:55 -0700 (PDT)
Message-ID: <cb49a065-f9e3-4822-ae68-a17f0961db77@p25g2000hsf.googlegroups.com>


On 14 Apr, 04:14, Woody Ling <woodyl..._at_gmail.com> wrote:
> For DB2, I can use 'db2ilist' to list all created instance in the
> server.
>
> Is there any way in oracle to check and display all created instances
> in the server even though they are not started?
>
> Thanks.
> Woody Ling
> Hong Kong

The following will list all running instances on a Unix box:

$ ps -eaf | grep pmon

HTH -g Received on Tue Apr 15 2008 - 04:59:55 CDT

Original text of this message