Specifying Oracle Variables on Windows Systems
If there is one instance of Oracle on the system, the Registry settings for ORACLE_HOME
and ORACLE_SID
should be sufficient for Oracle GoldenGate. If those settings are incorrect in the Registry and cannot be changed, you can set an override as follows.
-
On the Desktop or Start menu, right-click My Computer, and then select Properties.
-
In Properties, click the Advanced tab.
-
Click Environment Variables.
-
Under System Variables, click New.
-
For the Variable Name, enter
ORACLE_HOME
. -
For the Variable Value, enter the path to the Oracle binaries.
-
Click OK.
-
Click New again.
-
For the Variable Name, enter
ORACLE_SID
. -
For the Variable Value, enter the instance name.
-
Click OK.
If there are multiple Oracle instances on the system with Extract and Replicat processes connecting to them, use these steps:
- Use the preceding procedure (single Oracle instance on system) to set the
ORACLE_HOME
andORACLE_SID
system variables to the first Oracle instance. - Start all of the Oracle GoldenGate processes that will connect to that instance.
- Edit the existing
ORACLE_HOME
andORACLE_SID
variables to specify the new information., then repeat the procedure for the next Oracle instance. - Start the Oracle GoldenGate processes that will connect to that instance.
- Repeat the edit and startup procedure for the rest of the Oracle instances.
Parent topic: Setting ORACLE_HOME and ORACLE_SID