WebSphere brand IBM WebSphere XML Document Management Server, Version 7.0

Configuring the Oracle thick client

If you are using Oracle Database, install the Oracle thick client and configure it to work with IBM® XDMS.

About this task

You can configure a thick client or a thin client for Oracle. To configure the thin client, you will need to install XDMS 7.0 interim fix 1. Contact your IBM representative for more information.

If you elect to use the thin client, you do not need to install the Oracle on any server where WebSphere® Application Server is running. You can disregard this procedure.

However, if you do not plan to install XDMS 7.0 interim fix 1 immediately, you must continue with the steps for installing and configuring the Oracle thick client. Install the client on the deployment manager and on all managed nodes.

In this procedure, you will set up the Oracle thick client to use the tnsnames.ora file.

In the following steps, oracle_home is the directory in which the Oracle thick client is installed.

  1. Open a command prompt and type the following command:
    mkdir -p oracle_home/network/admin
  2. Retrieve the tnsnames.ora file from the database server with which the Oracle thick client will communicate.
  3. Put the tnsnames.ora file into the oracle_home/network/admin directory on the Oracle client.
  4. Change (cd) to the following directory: was_root/profiles/app_server_name/bin.
  5. Edit the setupCmdLine.sh file as follows:
    1. Add the following environment variables at the end of the file:
      Table 1. Environment Variables
      Variable Description Example
      ORACLE_HOME= Path where the Oracle client is installed /opt/app/oracle/product/11.1.0/client_1
      TNS_ADMIN= TNS Admin directory $oracle_home/network/admin
      CLASSPATH= Class path For WebSphere 7.0.0.1: $oracle_home/ojdbc6.jar
      For WebSphere 6.1.0.21: $oracle_home/ojdbc5.jar
      LIBPATH= Library path
      (normally used for AIX®)
      $LIBPATH:/usr/lib:/lib:/usr/local/lib:$oracle_home
      LD_LIBRARY_PATH= Library path
      (normally used for Linux®)
      $LD_LIBRARY_PATH:$oracle_home/network/lib:$oracle_home/lib:$oracle_home
    2. Add the following export command at the end of the file:
      export ORACLE_HOME TNS_ADMIN CLASSPATH LIBPATH LD_LIBRARY_PATH
  6. Save your changes and exit the editor.
  7. Restart the application server and the node agent.



Terms of use
(C) Copyright IBM Corporation 2009. All Rights Reserved.