1. Reference
  2. TimesTen Scaleout Utilities
  3. ttGridAdmin
  4. Cache Operations
  5. Set Credentials (dbCacheCredentialSet)

Set Credentials (dbCacheCredentialSet)

Use the dbCacheCredentialSet command to register the Oracle cache administration user name and password in the TimesTen database.

You must register these credentials before any cache group operation can be issued. The cache agent connects to the Oracle database as the Oracle cache administration user to create and maintain Oracle Database objects that store information used to enforce predefined behaviors of particular cache group types. In addition, cache agents connect to the Oracle database with the credentials set to manage Oracle database operations.

You only need to register the cache administration user ID and password once for each new database. See Set the Cache Administration User Name and Password in the TimesTen Database in Oracle TimesTen In-Memory Database Cache Guide.

You can also use the ttGridAdmin dbCacheCredentialSet command to change the Oracle cache administration user name and password. You cannot change the Oracle cache administration user name if there are existing cache groups. In this case, drop all cache groups before attempting to modify the Oracle cache administration user name. See Changing Cache User Names and Passwords in Oracle TimesTen In-Memory Database Cache Guide. 

ttGridAdmin dbCacheCredentialSet name

Options

The dbCacheCredentialSet command has the option:

Option Description

name

The name of the database.

Examples

Use the ttGridAdmin dbCacheCredentialSet command to set the Oracle cache administration user name and password. This user name and password are saved in an Oracle Wallet, which each instance in the database can access and use.

When prompted, specify the Oracle cache administration user name as the Oracle user id and the Oracle cache administration user password as the Oracle password. 

% ttGridAdmin dbCacheCredentialSet database1
Enter your Oracle user id: cacheadmin
Enter Oracle password:
Password accepted
Configuring cache.....................................................OK

Notes

  • The CacheAdminWallet connection attribute specifies if credentials for the Oracle cache administration user that are registered with the ttGridAdmin dbCacheCredentialSet command are stored in an Oracle Wallet or in memory. See CacheAdminWallet.

  • For TimesTen Scaleout, Oracle Wallets are always located on data instances.