CacheAdminWallet

The CacheAdminWallet attribute specifies that credentials for the Oracle cache administration user that are registered with the ttCacheUidPwdSet built-in procedure are stored in a system-managed Oracle Wallet.

Note:

In TimesTen Classic, you can register credentials by using ttAdmin -cacheUidPwdSet or calling the ttCacheUidPwdSet built-in procedure. In TimesTen Scaleout, you register the credentials with the ttGridAdmin dbCacheCredentialSet command.

• Value set to 0: The default value. TimesTen encrypts the credentials you define and stores them in memory.
• Value set to 1: Recommended value. TimesTen creates an Oracle Wallet to store the credentials.

The following scenarios apply when setting CacheAdminWallet:

• Changing the value from 0 to 1. TimesTen creates an Oracle Wallet on disk to store the user ID and password and clears the password from memory on the first connection on the transition from 0 to 1.
• Changing the value from 1 to 0. TimesTen deletes the Oracle Wallet from the disk. Since the password is not in memory, you must set the password again.

This example sets the credentials by calling the ttCacheUidPwdSet built-in procedure.

CALL ttCacheUidPwdSet('cacheadmin','orapwd');

The following shows an odbc.ini file with the cache1 client DSN setting the CacheAdminWallet to 1.

[cache1]
DataStore=/users/OracleCache/ttcache
PermSize=64
OracleNetServiceName=oracledb
DatabaseCharacterSet=AL32UTF8
CacheAdminWallet=1

Required Privilege

No privilege is required to set the value of this attribute.

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is supported in both TimesTen Classic and TimesTen Scaleout.

Setting

Set CacheAdminWallet as follows:

Where to set the attribute	How the attribute is represented	Setting
C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen Classic	CacheAdminWallet	0 (default) - Encrypts the Oracle cache administration user ID and password and stores them in memory. 1 - Creates an Oracle Wallet to store the Oracle cache administration user ID and password. It clears the password from memory if it was previously set with CacheAdminWallet=0.
Windows ODBC Data Source Administrator	Not applicable

Also see

• ttCacheUidPwdSet