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: Hkey_Local_Machine >> Software >> Oracle>> Oracle_Sid Will...
Contents
How do I find the Oracle SID?
The location path of your Oracle Home Registry is as follows:
- HKEY_LOCAL_MACHINE >> SOFTWARE >> ORACLE>>
- Oracle_SID will show your SID.
- Oracle_Home will show the location of your DB Home.
- Oracle_BUNDLE_NAME will show the edition of your Oracle Database.
- 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.