Your Question: How Do I Find the Sid of an Oracle Database in Linux?
Contents

How do I find the Oracle SID?

The location path of your Oracle Home Registry is as follows:

  1. HKEY_LOCAL_MACHINE >> SOFTWARE >> ORACLE>>
  2. Oracle_SID will show your SID.
  3. Oracle_Home will show the location of your DB Home.
  4. Oracle_BUNDLE_NAME will show the edition of your Oracle Database.
  5. Oracle_SVCUSER will show the windows user for your Oracle Database.

What is the SID of my Oracle database?

The SID is a site identifier. It plus the Oracle_home are hashed together in Unix to create a unique key name for attaching an SGA. If your Oracle_sid or Oracle_home is not set correctly, you’ll get “oracle not available” since we cannot attach to a shared memory segment that is identified by magic key.

James H. Sterling

James H. Sterling

Environmental Science & Climate Journalist

James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.

Share this article
Twitter Facebook Pinterest