What is my SID, Where is my DB Home? Such Questions are very common in the comment section of most of my videos. In this tutorial I will show you the easiest way to find out the SID and DB Home which does not involve writing any kind of code or query. But remember this will only work with windows operating system.
One thing which is very obvious about the windows operating system is that it saves all the important information and settings as keys into the windows registries. In order to get that information we just need to know the correct registry to dig for. So let’s see which windows registry we need to open to find out our system identifier and DB home location.
Where is the key registry for your Oracle Home?
Step 1: Open up the registry editor
In order to find out the registry keys you first need to go to the registry editor. For that open up your “Run Command” Box by pressing “Windows Key” and “R” key simultaneously. In order to open up the Registry editor in your windows you have to write REGEDIT in your run dialogue box.
Step 2: Navigate to the Oracle Home Registry
Once you have successfully launched your registry editor then you need to navigate to the key registry for your Oracle Home. The location path of your Oracle Home Registry is as follows:
HKEY_LOCAL_MACHINE >> SOFTWARE >> ORACLE>>
Inside the “Oracle” directory, you will find the key registry for your Oracle Home. The name of that registry will look something like this “Key_OraDB18Home1”. You simple have to click and select it and you will see all the values that it contains.
Which Value should I refer to for my SID?
The key registry for your Oracle Home contains all the important information about your Oracle Database installation. Such as entry
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.
Similarly you can find other information about your Oracle Database as well so feel free to explore these entries.
Is there any other way to find out the SID of my Oracle Database?
Yes, there is another way to find out the SID of your Oracle Database. It involves writing a simple SQL query. Watch this video which I posted on my Facebook where I write the query to find out the SID in just 40 seconds.
That is how we can find out the SID and DB Home of Oracle Database. Hope you enjoyed this tutorial. Thanks & have a great day!