Oracle instructions for AIX

Procedure

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

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