Installing and configuring the database client

If you have installed Tivoli® Common Reporting on a computer other than the TADDM database server, you must install a database client to connect to the database. You can use either a DB2® or Oracle database client, depending on the TADDM database type. If you have installed Tivoli Common Reporting on the same server as the TADDM database, you do not need to install a database client.

To install and configure the database client, complete the following steps:

Complete one of the following tasks:
  • If you want to use the DB2 database client, complete the following steps:
    1. Install the DB2 client on the machine on which TCR is installed, using the default options presented.
    2. Ensure that the TADDM database has been cataloged. This step is necessary for Tivoli Common Reporting to successfully connect to the DB2 server, using the DB2 client.
  • If you want to use the Oracle database client, complete the following steps to install and configure it using the Oracle Universal Installer wizard and the Oracle Net Configuration Assistant wizard:
    1. In the Select Installation Type page of the Oracle Universal Installer wizard, select Administrator as the installation mode.
    2. In the Specify Home Details page, specify the name of the installation and the path to the location to where you want to install the product.
    3. In the Product-Specific Prerequisite Checks page, ensure that each of the requirements for installation and configuration are met. Do not continue with the installation until each check has a status of Succeeded.
    4. In the Welcome page of the Oracle Net Configuration Assistant wizard, ensure that the Perform typical configuration check box is not selected.
    5. In the Naming Methods Configuration, Select Naming Method page, set Local Naming as the naming method.
    6. In the Net Service Name Configuration, Service Name page, type the service name of your remote Oracle database server, for example, ORCL.
    7. In the Net Service Name Configuration, Select Protocols page, select TCP as the protocol to use to connect to the database.
    8. In the Net Service Name Configuration, TCP/IP Protocol page, type the host name of the computer on which the database is running. Select Use the standard port number of 1521.
    9. In the Net Service Name Configuration, Test page, select Yes, perform a test.
      If your database user name and password are correct, the following text is displayed: 
      Connecting... Test successful.

      If a successful connection to the database is not made, you might need to change your login credentials. To change the database login credentials click Change Login and specify a valid database user name and password.

    10. In the Net Service Name Configuration, Net Service Name page accept the default service name, which should be the service name you specified earlier.
    11. Create a Windows system variable called TNS_ADMIN and set the value to the full path of the folder containing the tnsnames.ora file. During installation the tnsnames.ora file is created in the %ORACLE_HOME%/client_1/NETWORK/ADMIN folder, for example C:/oracle/product/10.2.0/client_1/NETWORK/ADMIN.
    12. Set the TNS_ADMIN variable in thestartTCRserver.sh/bat script to point to the location of the tnsnames.ora file, for example %ORACLE_HOME%/client_1/NETWORK/ADMIN.
    13. Reboot the computer to ensure that the new system variable is available.