Add TNS entries in the TNSNAMES.ORA File

Add TNS entries in the tnsnames.ora file for every schema created for the Application Pack.

To add the TNS name for the entries:

1. Log in to the application using System Administrator privileges.
2. Navigate to System Configuration & Identity Management tab.
3. Click Administration and Configuration, select System Configuration, and click Database Details.
4. Expand Name to get the list of TNS entry names.
   Alternatively, you can connect to the CONFIG schema and execute the following query:
   select dbname from db_master where dbname !='CONFIG'