Question: How do I find all
instances on my Oracle server? What command would I use to
list all instances?
Answer: In UNIX/Linux you can use the
processes (ps) command to find all instances on a
server. In this case, we display the process monitor
process:
ps -ef|grep pmon|grep
-i grep
In Windows you must enter the registry
to find all instances on a Windows server.
Open the registry with regedit. Navigate to the key
entry in the Windows registry:
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\oracle_home_name.
There will be a key called:
ORA_SID_AUTOSTART. SID is
your database SID.
This key should be set to TRUE.
Also see my notes on
multiple instances on a server.
