Re: Find Oracle Instance Names in UNIX Server

maa_at_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: gedau_at_pobox.com         !  Any views or opinions expressed (OO)
\_,--\_/ Work: gedau_at_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