Find Oracle Instance Names in UNIX Server

[m...@molhk.com.hk]

Pls kindly advise how I can find out which Oracle instances and Database exist
in UNIX Server. For a Server with multi-instance, I want to know the
combination of instance/database name (even they haven't started up).

Tks!!

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

[Rene van Geijn]

/etc/oratab list all the instances on the machine.

Rene

[Emmanuel Bontemps]

To find which database are currently runing, for example :

$ ps -ef | grep pmon

For each process :
ora_<process_name>_<instance_name>

m...@molhk.com.hk a écrit :

[George Dau]

m...@molhk.com.hk wrote:

]Pls kindly advise how I can find out which Oracle instances and Database exist

]in UNIX Server. For a Server with multi-instance, I want to know the
]combination of instance/database name (even they haven't started up).

As Rene suggested, /etc/oratab is the place to look. Also check for a
/var/opt/oracle/oratab

These will list database SIDs, but also oracle home directories. Go to these
oracle home directories and look in $ORACLE_HOME/dbs/pfile and see what
init$SID.ora files are there - could be more SIDs defined in there that are not
in oratab files.

--
,-,_|\ George Dau - Unix (Solaris, DEC Unix, Linux), Oracle, Internet. __
/ * \ Home: ge...@pobox.com ! Any views or opinions expressed (OO)
\_,--\_/ Work: ge...@isa.mim.com.au ! above may be mine, but are NOT ( \/ )
v WWW: http://pobox.com/~gedau ! necessarily those of M.I.M. W--W