* Implementation steps of the tnsnames.ora in Integrator

Resolution

1. Stop Integrator Server

2. Create the file tnsnames.ora with the description of the connection to the database. The connection description should look like:

COMP3.x =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dartagnian.lab.buch.axway.int)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = comp3)
)
)

3. Modify the file $CORE_ROOT/config/environment.dat:

- Add to LD_LIBRARY_PATH the path to $ORACLE_PATH/lib. It should look like:
LD_LIBRARY_PATH=${CORE_ROOT}/bin:${CORE_LOCAL}/4edi/load:${CORE_ROOT}/4edi/load:${CORE_LOCAL}/load:${CORE_ROOT}/load:${CORE_ROOT}/c/component:${CORE_LOCAL}/java/load:${CORE_ROOT}/java/load:/usr/lib:${JAVA_HOME}/lib/amd64/server:${JAVA_HOME}/lib/amd64/native_threads:${JAVA_HOME}/lib/amd64:/oracle/product/1x.x.x/lib

- Add the variable ORACLE_HOME as

ORACLE_HOME=/oracle/product/1x.x.x

- Add the variable
TNS_ADMIN=path_to_the_folder_where_tsnames.ora_is_located
Example:
TNS_ADMIN=/home/Axway/Synchrony/ORACLE

4. Run the profile so that the environment variables are taken into account

5. Start Integrator