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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: