Local naming resolves service names to network addresses by using information configured in the TNSNAMES.ORA file that is stored locally on each client node. The TNSNAMES.ORA file is comprised of two parts; Service Names and Connect Descriptors.

With Local Naming, clients must have a TNSNAMES.ORA file with service names that map to the service addresses listed in the Database server's LISTENER.ORA file before they can connect. Client configuration is accomplished by creating a list of service names (which are aliases for a database network address) and addresses of network destinations (database server name or IP address) in the TNSNAMES.ORA file.

 

Each ORACLE HOME can have their own TNSNAMES.ORA file.

In the ConnectMaster Client Installation you find the TNSNAMES.ORA file in the following folder:

- For Oracle11g:

<drive>:\cm\oracle\product\11.1.0\client_1\network\admin

If there are other TNSNAMES.ORA files (from other applications) copy the ConnectMaster entry in all files to avoid connection problems