I want to find out how many Oracle instances (SIDs) are created on any
machine. If I use the command "Select * from v$database" I get only the current
instance name in the output.
If you are running Oracle on a Windows server, go to Control
Panel->Administrative Tools->Services. Look for any services titled
OracleServiceSID. The word SID will be replaced by your ORACLE_SID database identifier.
If you are running Oracle on a Unix/Linux server, look for your oratab file (typically in /var/opt/oracle or /etc). It will contain an entry for each Oracle instance on that server.
This was first published in August 2005
Join the conversationComment
Share
Comments
Results
Contribute to the conversation