Setting up Oracle client software
If your Content Manager database is Oracle, you need to install and configure Oracle client software on the machine on which you installed Content Manager server.
Procedure
- If your operating system has a 64-bit architecture, execute the following steps; otherwise, skip ahead to step 9. To start, access the SDL Tridion installation media and in the Redistributables\ folder, open the Web page Readme.htm. The page contains a link to a page where you can download the Oracle client software. 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. Because you will be installing the 32-bit client as well, provide a specific name for the 64-bit client under Software Location by appending, say, client_64 to the path you would normally use. Then click Next.
The Available Product Components step appears.
- In this screen, select the following items:
- SQL*Plus
- Oracle Net
- Oracle Services for Microsoft Transaction Server
- Oracle Data Provider for .NET
and 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. The following steps must be executed on all operating systems, whether 64-bit or 32-bit.
- To start installing the 32-bit client, find the 32-bit client installer in the software package you downloaded and run it.
The initial Select Installation Type screen appears.
- Select Custom 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. If you are on a 64-bit machine, be sure to provide a specific name for the 32-bit client under Software Location by appending, say, client_32 to the path you would normally use. Then click Next.
The Available Product Components step appears.
- Select the following items:
- SQL*Plus
- Oracle Net
- Oracle Services for Microsoft Transaction Server
- Oracle Provider for OLE DB
- Oracle Data Provider for .NET
and click Next to continue.
The Oracle Services for Microsoft Transaction Services step appears.
- Leave the port number as it is and click Next.
The Summary step appears.
- Click Finish to start installing the client.
If you are installing on a 64-bit machine, you now see an error message.
If you see this message, you can ignore it. Click Continue to close this popup.
The installer installs the client software and reports success.
- Click Close to close the installer.
You have now successfully installed all client software for Oracle.
- Configure and test your installed client or clients. Start by creating a plain text file with the following content:
# TNSNAMES.ORA Network Configuration file myoracleserver= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = myoracleserver) (PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = myoracleserver) ) ) )where
myoracleserveris the name of both your Oracle server and database instance.Save this file as TNSNAMES.ORA in the Oracle home directory (or, on a 64-bit machine, home directories) that you specified during installation.
- Open a command prompt and access the bin\ subdirectory of the Oracle home directory or home directories and execute the following command:
wheretnsping.exe myoracleservermyoracleserveris the same as before.The command prompt reports back with an OK message. - If you have a 64-bit architecture, and if your Oracle version is 11.2.0.1.2 or higher, but lower than 11.2.0.2, manually register assemblies for policy DLLs. This is a known bug in Oracle:
9953792: 64-BIT POLICY DLLS REMOVED FROM GAC_64 AFTER INSTALL 32-BIT CLIENT. - Check the folder c:\Windows\assembly for the presence of a number of new assemblies called Oracle.DataAccess or Policy.2.111.Oracle.DataAccess (the number may differ).