5.7.2.3 Add Atomic Schema Details in the tnsnames.ora File

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

To add the Atomic Schema in the tnsnames.ora file, follow these steps:

1. Log in to the system as a non-root user.
2. Navigate to the OFS_PM_PACK/Schema_Creator/conf directory.
3. Edit the tnsnames.ora file using a text editor and add the Atomic Schema as follows and save the file.

   <ATOMICSCHEMANAME> =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <HOST NAME>)(PORT = <PORT NUMBER>))
   )
   (CONNECT_DATA =
   (SERVICE_NAME = <SID NAME>)
   )