6.9 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:
- Log in to the system as a non-root user.
- Navigate to the
OFS_BSP_PACK/Schema_Creator/conf
directory. - 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>) )