Newsgroups: comp.databases.oracle.server
Subject: Re: How can I find how many instances in a server
References: <5ka675$cle$1@cronkite.seas.gwu.edu>

lovedog@gwis2.circ.gwu.edu (Shaochun Lin) writes:

>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,

There are several options for looking at instances on a server, depending 
on your setup:

1) Issue "ps -ef |grep pmon" or "ps -a|grep pmon"
   This will list all instances UP

2) Issue "cat /etc/oratab". This should show all instances, whether up or 
down. They SHOULD all be in this file.

3) Issue: find / -name "bdump" -print 2>/dev/null
   This will show within the paths returned the names of all instances 
(if you are OFA compliant - Oracle Flexible Architecture).

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 60+ free technical tips, visit my Web Page:               <->
<->                                                               <->
<->              www.arikaplan.com                                <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page o Ari Kaplan's Home Page