Shareplex in Unix environment references oratab file for querying the Oracle SID to carry out a number of functions, including installation, activation, etc. The question arises as to where does it get the similar information in a Windows or NT environment which does not have the oratab file.
General information.
The information is found in the Registry of the Windows server. Each time install Oracle products is installed into a new Oracle home on a computer, HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME registry entry is created.
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME includes the following parameters for an Oracle home directory which are of interest to us:
ORACLE_HOME
This specifies Oracle home directory in which Oracle products are installed. This directory is immediately beneath the Oracle base directory in the Oracle directory hierarchy.
ORACLE_SID
This specifies the name of the Oracle Database instance on the host computer. The value of this parameter is the SID for the instance.
Since the structures (registry entries, path, etc) can be subject to change, it is advisable to refer to Windows latest documentation for up to date information.
