7.4 Add TNS entries in TNSNAMES.ORA file

Add TNS entries in the tnsnames.ora file for every schema created for the Application Pack. To find the tnsname for the entries, follow these steps:

1. Login to the application using System Administrator privileges.
2. Navigate to System Configuration & Identity Management tab.
3. Click Administration and Configuration >> System Configuration >> Database Details.
4. Expand Name to get the list of TNS entry names.
5. Alternatively, you can connect to the CONFIG schema and execute the following query:

   select dbname from db_master where dbname !='CONFIG'