Setting up Oracle client software
If your Audience Manager Content Manager-side database is Oracle, you need to install and configure Oracle client software on the Content Manager server machine.
Procedure
- Download the Oracle client software from the following location: https://www.oracle.com/technetwork/topics/dotnet/downloads/odacdeploy-4242173.html. Download and unpack it to a location of your choice, then start the 64-bit Oracle client installer.
After a few minutes of initializing, the installer starts, showing its initial screen.
- Select Custom as your installation type and click Next.
The Select Product Languages step appears.
- Select the languages in which you want the client software to be available and click Next.
The Specify Installation Location step appears.
- Specify an Oracle Base location and click Next.
The Available Product Components step appears.
- In this screen, select the following items:
- Oracle Services for Microsoft Transaction Server
- Oracle Data Provider for .NET
- For maintenance and debugging purposes, SDL recommends that you also select:
- SQL*Plus
- Oracle Net
- Click Next.
The Oracle Services for Microsoft Transaction Services step appears.
- Leave the port number as it is, and click Next.
The Summary screen appears.
- Click Finish.
The installer installs the client software and reports success.
- Click Close to exit the installer.
You have now installed the 64-bit client.
- Ensure the existence of a Windows environment variable called
ORAMTS_SESS_REGISTERUCBand set it to the valuefalse. - To configure and test your installed client or clients, open a command prompt and access the bin\ subdirectory of the Oracle home directory or home directories and execute the following command:
where ORANETSERVICE is the name of your Oracle net service.tnsping.exe ORANETSERVICEThe command prompt reports back with an OK message.