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.