How
to find Oracle instance names?
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).
Ans1:
/etc/oratab list all the instances
on the machine.
Rene
Ans2:
To find which database are
currently runing, for example :
$ ps -ef | grep pmon
For each process :
ora_<process_name>_<instance_name>