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

lovedog_at_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+ technical tips, visit my Web Page:                    <->
<->                                                               <->
<->              http://homepage.interaccess.com/~akaplan         <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->