Oracle Net service resolution on Teamcenter clients

Under Oracle Net, there is a requirement that each Oracle client have some means of translating the service alias supplied in the database connect string into its equivalent connect descriptor. On Windows, Teamcenter accomplishes this by creating a copy of the tnsnames.ora and sqlnet.ora files in the Teamcenter data directory during installation and setting the value of the TNS_ADMIN environment variable to %TC_DATA% in the tc_profilevars.bat file, to force Teamcenter to use this file. On Linux, Teamcenter accomplishes this by creating a copy of the tnsnames.ora file in the Teamcenter data directory during installation and setting the value of the TNS_ADMIN environment variable to $TC_DATA in the tc_profilevars file, to force Teamcenter to use this file. The Teamcenter data directory was chosen as the location for this file as it makes the file immediately visible to all Teamcenter clients who want to use this database and because this directory is guaranteed writable by the installer. The tnsnames.ora file contains one entry—the entry for the database associated with that Teamcenter data directory. This file is regenerated every time the data directory is reconfigured. You can override the setting of the TNS_ADMIN environment variable from the external environment or commented out in the TC_DATA\tc_profilevars file, depending on the requirements of the site. Caution If you maintain copies of the Oracle Net configuration files in various locations in the system, be careful not to duplicate service aliases within those files. Duplication of service aliases could lead to connection to the wrong database and can result in lost or corrupted data. Ensure that the TNS_ADMIN environment variable is set correctly before running Teamcenter Integration for NX/NX Integration.