Configure access to Oracle configure-access-to-oracle

Install the Oracle full client corresponding to your version of Oracle.

Add your TNS definitions to your installation. To do this, specify them in a tnsnames.ora file in the /etc/oracle repository. If this repository does not exist, create it.

Then create a new TNS_ADMIN environment variable: export TNS_ADMIN=/etc/oracle and restart the machine.

Integrate Oracle into your Adobe Campaign server (nlserver). To do this, check that the customer.sh file is present in the “nl6” folder of the Adobe Campaign server tree structure and that it includes the links to the Oracle libraries.

For example, for a client in 11.2:

export ORACLE_HOME=/usr/lib/oracle/11.2
export TNS_ADMIN=/etc/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/client64/lib:$LD_LIBRARY_PATH

Install the libraries necessary for Oracle:

• libclntsh.so

  code language-none
  cd /usr/lib/oracle/<version>/client<architecture>/lib ln -s libclntsh.so.<version> libclntsh.so

• libaio1

  code language-none
  aptitude install libaio1 or yum install libaio1

In Campaign Classic, you can then configure your Oracle external account. For more on how to configure your external account, refer to this section.

Install the Oracle client.

In the C:Oracle folder, create a tnsnames.ora file containing your TNS definition.

Add a TNS_ADMIN environment variable with C:Oracle as value and restart the machine.

In Campaign Classic, you can then configure your Oracle external account. For more on how to configure your external account, refer to this section.

From Campaign Explorer, select Administration ‘>’ Platform ‘>’ External accounts.

Choose New.

Select External database as your external account’s Type.

Configure the Oracle external account, you must specify:

• Type: Oracle

• Server: Name of the DNS

• Account: Name of the user

• Password: User account password

• Time zone: Server time zone