X

Oracle Customer Engineering & Advocacy Lab (CEAL) Blog covers BI Tech, EPM, BI Cloud and EPM Cloud.

EXALYTICS v1 - Changes Required to sys.odbc.ini File After Installation using scripts (ANT)

In OBIEE 11.1.1.6 release for Exalytics v1, when you use the installation scripts to install software on the Exalytics Machine, the scripts automatically add a DSN entry into the sys.odbc.ini file for TimesTen. You must edit this TT_AGGR_STORE DSN entry so that it reads as follows:

[TT_AGGR_STORE] 
Driver=/home/oracle/TimesTen/tt1122/lib/libtten.so
DataStore=/home/oracle/aggregate_store/tt_aggr_store
LogDir=/home/oracle/aggregate_store/logs
DatabaseCharacterSet=AL32UTF8
ConnectionCharacterSet=AL32UTF8
LogFileSize=1024
LogBufMB=1024
LogBufParallelism=16
Preallocate=0
PermSize=25000
TempSize=25000
MemoryLock=4
CkptFrequency=30
CkptLogVolume=0
CkptRate=20
PrivateCommands=1
RecoveryThreads=40

The changes that you must make are the following:

  • Change LogBufParallelism to a value of 16 from the installed value of 12.
  • Remove the following lines:

RangeIndexType=1
Connections=1024

Note: that the settings for PermSize and TempSize are altered per the requirements for each Exalytics Machine. The values that are set as part of the installation are only the initial settings.

In addition, in the section of the sys.odbc.ini file that starts #[sampledb_1122], the scripts incorrectly include duplicate entries that you must delete or comment out, as shown in the following list:

ConnectionCharacterSet=AL32UTF8 
LogFileSize=1024
LogBufMB=1024
LogBufParallelism=16
Preallocate=0
PermSize=25000
TempSize=25000
MemoryLock=4
CkptFrequency=30
CkptLogVolume=0
CkptRate=20
PrivateCommands=1
RangeIndexType=1
Connections=1024
RecoveryThreads=40
Reference: http://docs.oracle.com/cd/E23943_01/relnotes.htm

 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.