Oracle instructions for Linux
Procedure
-
Define the LD_LIBRARY_PATH JVM variable to the Cognos® server. Add this variable to JVM environment variable list.
-
Follow the same steps as previously described to add an additional entry:
LD_PRELOAD = /usr/lib64/libfreebl3.so
-
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
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. -
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:
For example, change both daily-refresh.sh and weekly-rebuild.sh cron jobs from:crontab -e
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
- Run the following command first before manually running the script to build cube. For
example: