Oracle instructions for Linux

Procedure

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
```
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
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.

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