Registering the Cache Administration User Name and Password in TimesTen Classic

In TimesTen Classic, you can register the Oracle cache administration user name and password by calling the ttCacheUidPwdSet built-in procedure after connecting as the Timesten cache administration user.

Before you register the Oracle cache administration user and password internally within the TimesTen database, you must decide if you want to save these credentials in an Oracle Wallet (recommended) or within memory (the default). To save the Oracle cache administration user credentials within an Oracle Wallet, ensure that the CacheAdminWallet connection attribute is set to 1 (best set in your DSN).

This example connects as the cacheadmin cache administration user providing credentials in a wallet. After connection, the example calls ttCacheUidPwdSet providing the Oracle cache administration user name and password, which registers the Oracle cache administration user name and password within TimesTen.

% ttIsql "DSN=cache1;UID=cacheadmin;PwdWallet=/wallets/cacheadminwallet"
Command> call ttCacheUidPwdSet('cacheadmin','orapwd');

The credentials can also be registered from a command line by running a ttAdmin -cacheUidPwdSet utility command as a TimesTen external user with the CACHE_MANAGER privilege. The ttAdmin utility prompts for the password.

% ttAdmin -cacheUidPwdSet -cacheUid cacheadmin orapwd cache1
Enter password:

See ttCacheUidPwdSet and ttAdmin in Oracle TimesTen In-Memory Database Reference.