Understanding the Microsoft Windows Client Configuration

After running the SetupPTClient, you will need to update the tnsnames.ora file located in your oracle_home directory with the tnsnames entry from the tools_client folder. If your target database is also Oracle, you will also need to add the target databases tnsnames entry. To update the tnsnames.ora file:

Open the tnsnames.ora file in the tools_client directory.
Copy the entry in the tnsnames.ora file to the tnsnames.ora file located in your oracle_home directory.

Depending on your installation, the location of the tnsnames.ora file in the oracle_home directory will vary. If you installed the oracle client using SetupPTClient, the tnsnames.ora file is located in oracle_home\network\admin\tnsnames.ora; for example: C:\oracle\product\12.1.0\client_1\network\admin\tnsnames.ora:
If your target database is on Oracle, copy the tnsnames entry for your target database into the tnsnames.ora file.

The location of the tnsnames.ora file will vary depending on the Windows client installation. If SetupPTClient detects an existing Oracle DB Client 12c with 64-bit installation, it will use that version of Oracle Database, if SetupPTClient needs to install the DB Client 12c , the default location is: C:\oracle\product\12.1.0\client_1.

The tnsnames entry for your target databases must use the SERVICE_NAME in order for your PeopleTools or Change Assistant clients to connect to the PUM source database within the 12c database server. This is an example of the entry:
```
PT855GA1 = 
  (DESCRIPTION = 
     (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.domain)(PORT = 1521)) 
     (CONNECT_DATA = 
      (SERVER = DEDICATED) 
      (SERVICE_NAME = PT855GA1) 
    ) 
  )
```
Save the file.