Ask the Expert

Enumerating all instances of Oracle on a machine

How can we enumerate all the instances of Oracle on a machine?

    Requires Free Membership to View

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.


This was first published in September 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.