To start with, ensure the tnsnames.ora file is correct and the account running the Node Manager service has access to it. "tnsnames.ora" can also be copied from a working environment.
If it still doesn't work, perform the following steps:
- Make sure "TNS_ADMIN" registry key is created at "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE".
- If it exists, ensure it has the correct value pointing to the Oracle client location. This location is "C:\Oracle\product\12.1.0\client_2\Network\Admin" by default. Copy "tnsnames.ora" file at this location.
- If "TNS_ADMIN" key does not exist, create this key and point it to the same location as above.
Note: In the event of Oracle Client is installed at a non-default location, you may want to uninstall the client and instal it at the default location. By default, the Oracle client is installed under "C:\Oracle\product\". Once this is done, follow the steps :
- Copy the "tnsnames.ora" file to the Oracle client default location that is "C:\Oracle\product\12.1.0\client_2\Network\Admin"
- Change the registry to point "TNS_ADMIN" to "C:\Oracle\product\12.1.0\client_2\Network\Admin"
Screenshot(TNS_ADMIN.JPG) attached for reference.
DISCLAIMER :
TIBCO does not provide support for problems that arise from improper modification of the registry. The Windows registry contains information critical to your computer and applications. Make sure you back up the registry before modifying it. For more information on the Windows Registry Editor and how to back up and restore it, refer to Microsoft KnowledgeBase