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.

1. On the Desktop or Start menu, right-click My Computer, and then select Properties.

2. In Properties, click the Advanced tab.

3. Click Environment Variables.

4. Under System Variables, click New.

5. For the Variable Name, enter ORACLE_HOME.

6. For the Variable Value, enter the path to the Oracle binaries.

7. Click OK.

8. Click New again.

9. For the Variable Name, enter ORACLE_SID.

10. For the Variable Value, enter the instance name.

11. Click OK.

If there are multiple Oracle instances on the system with Extract and Replicat processes connecting to them, use these steps:

1. Use the preceding procedure (single Oracle instance on system) to set the ORACLE_HOME and ORACLE_SID system variables to the first Oracle instance.
2. Start all of the Oracle GoldenGate processes that will connect to that instance.
3. Edit the existing ORACLE_HOME and ORACLE_SID variables to specify the new information., then repeat the procedure for the next Oracle instance.
4. Start the Oracle GoldenGate processes that will connect to that instance.
5. Repeat the edit and startup procedure for the rest of the Oracle instances.