Documentation Center

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

  1. 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.

  2. Select Custom as your installation type and click Next.

    The Select Product Languages step appears.

  3. Select the languages in which you want the client software to be available and click Next.

    The Specify Installation Location step appears.

  4. Specify an Oracle Base location and click Next.

    The Available Product Components step appears.

  5. In this screen, select the following items:
    • Oracle Services for Microsoft Transaction Server
    • Oracle Data Provider for .NET
  6. For maintenance and debugging purposes, SDL recommends that you also select:
    • SQL*Plus
    • Oracle Net
  7. Click Next.

    The Oracle Services for Microsoft Transaction Services step appears.

  8. Leave the port number as it is, and click Next.

    The Summary screen appears.

  9. Click Finish.

    The installer installs the client software and reports success.

  10. Click Close to exit the installer.
    You have now installed the 64-bit client.
  11. Ensure the existence of a Windows environment variable called ORAMTS_SESS_REGISTERUCB and set it to the value false.
  12. 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:
    tnsping.exe ORANETSERVICE
    where ORANETSERVICE is the name of your Oracle net service.
    The command prompt reports back with an OK message.