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
ps -ef|grep pmon|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:
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.