Oracle instructions for AIX

Procedure

  1. Make sure the locale on is set to: en_US.ISO8859-1 or en_US.ISO8859-15. The locale setting is required by Cognos® Transformer for building a power cube.
    • Execute the following command first before manually running the script to build a cube.
      export LC_ALL=en_US.ISO8859-1
    • Use the following command to edit the cron jobs to set the locale 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 LC_ALL=en_US.ISO8859-1; /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
      05 00 * * 0 export LC_ALL=en_US.ISO8859-1;  /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
  2. Define the ORACLE_HOME, TNS_ADMIN, and LIBPATH JVM variables to the Cognos server. Add this variable to JVM environment variable list.
    1. Log into 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
      LIBPATH=Cognos_BI_install_path/bin64: /u01/app/oracle/product/11.2.0/client_1/lib
      
  3. Copy the following files to the Cognos_Transformer_install_path/bin directory:
    AIX®:
    • Oracle_client_install_path/lib/libclntsh.so
    • 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; export LC_ALL=en_US.ISO8859-1; /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
      05 00 * * 0 export ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1; export LC_ALL=en_US.ISO8859-1;  /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh