How to Map tnsnames.ora to a Different Location for Forms and Reports

By default in every Oracle Forms and Reports 11g (and 11gR2) deployment, the application(s) look for the TNS connection details inside the tnsnames.ora location in %ORACLE_INSTANCE%\config ($ORACLE_INSTANCE/config in Unix). An example location could be C:\Oracle\Middleware\asinst_1\config.

If you need to deploy to a seperate tnsnames.ora location such as a network drive or in the same location as your Oracle database (only if one is installed in the same environment as WebLogic), you will need to follow these steps to configure this deployment.

What you’ll learn in this article:

✓ How to map tnsnames.ora to a different location for Oracle Forms and Reports
✓ Instructions for both Windows and Unix