Oracle instructions for Linux

Procedure

  1. Define the LD_LIBRARY_PATH JVM variable to the Cognos® server. Add this variable to JVM environment variable list.
    1. Log in to the WebSphere® Application Server Integrated Solutions Console of the Cognos® BI Server.
    2. Click Servers > Server Types > WebSphere application servers.
    3. Click the link of the Cognos® server.
    4. Click JAVA and then Process Management > Process definition > Environment Entries.
    5. Add or edit entries as needed, such as:
      ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1
      TNS_ADMIN=ORACLE_HOME/network/admin
      LD_LIBRARY_PATH =Cognos_BI_install_path/bin64: /u01/app/oracle/product/11.2.0/client_1/lib
  2. Follow the same steps as previously described to add an additional entry:
    LD_PRELOAD = /usr/lib64/libfreebl3.so
  3. Copy the following files to the Cognos_Transformer_install_path/bin directory:
    • Oracle_client_install_path/lib/libclntsh.so.11.1
    • Oracle_client_install_path/lib/libnnz11.so
    If you are not logged in as root, change the permissions on the two files using chmod 755.
    Note: If you are using a different version of the Oracle client, you should find similar files (named for the version) in the same location and can use those files instead.
  4. Make sure ORACLE_HOME is set before building a cube.
    • Run the following command first before manually running the script to build cube. For example:
      export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1
    • Use the following command to edit the cron jobs to set the ORACLE_HOME for scheduled cube generation tasks:
      crontab -e
      For example, change both daily-refresh.sh and weekly-rebuild.sh cron jobs from:
      05 00 * * 1-6 /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
      05 00 * * 0 /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
    • To:
      05 00 * * 1-6 export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1; /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
      05 00 * * 0 export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1;   /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh