Set Up Oracle TimesTen In-Memory Database on Linux

You must perform some prerequisite tasks before setting up Oracle TimesTen In-Memory Database data sources.

To set up Oracle TimesTen In-Memory Database data sources, first follow the instructions in Configure TimesTen Data Sources to set up the TimesTen data source. Ensure that you go to the section Configure Database Connections Using Native ODBC Drivers to obtain the correct steps for Linux systems.

Next, review the best practices described in Improve Use of System Memory Resources with TimesTen Data Sources and implement them as needed.

Finally, if the user that starts OBIS1 doesn't have the path to the TimesTen DLL ($TIMESTEN_HOME/lib) in their operating system LD_LIBRARY_PATH variable, or LIBPATH on AIX, you must add the TimesTen DLL path as a variable in the obis.properties file.

1. Open obis.properties for editing. You can find obis.properties at:

   BI_DOMAIN/config/fmwconfig/bienv/obis

2. Add the required TimesTen variable TIMESTEN_DLL, and also update the LD_LIBRARY_PATH variable (or equivalent), as shown below:

   TIMESTEN_DLL=$TIMESTEN_HOME/lib/libttclient.so
   LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$TIMESTEN_HOME/lib

3. Save and close the file.
4. Repeat these steps on each computer that runs the Oracle BI Server process. If you're running multiple Oracle BI Server instances on the same computer, then ensure that you update the ias-component tag appropriately for each instance in obis.properties, for example, ias-component id="coreapplication_obis1", and ias-component id="coreapplication_obis2".
5. Restart OBIS1.