How can we enumerate all the instances of Oracle on a machine?
If the server in question is a Windows platform, go to Control Panel->Administrative Tools->Services. Look through the list for services that have a name of the form OracleServiceXXXX. The "XXXX" will be the database identifier or SID. There can be multiple services for multiple instances running on that machine.
If the server in question is a Unix or Linux platform, then you'll want to examine the oratab file. This file is commonly found in the /var/opt/oracle or /etc directories. In that file, there will be one line each instance on the server.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.