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 intend to install Content Manager server.
Procedure
- Download the Oracle client software from the following location: http://www.oracle.com/technetwork/database/windows/downloads/index-101290.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. - Configure and test your installed client or clients. Start by creating a plain text file with the following content:
# TNSNAMES.ORA Network Configuration file ORANETSERVICE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = ORAHOST) (PORT = 1521) ) (LOAD_BALANCE = YES) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORASERVICE) ) ) )where ORANETSERVICE is the name of your Oracle net service, ORAHOST is the host name or IP address of your database server machine, and ORASERVICE is the name of the Oracle service to access (that is, an alias for one or more Oracle database instances).
Save this file as TNSNAMES.ORA in the Oracle 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:
where ORANETSERVICE is the same as before.tnsping.exe ORANETSERVICEThe command prompt reports back with an OK message. - 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).