1. Cache Guide
  2. Setting Up a Caching Infrastructure
  3. Configuring a TimesTen Database to Cache Oracle Database Data
  4. Providing Cache Administration User Credentials

Providing Cache Administration User Credentials

If you are running a request that does not require access to the Oracle database, you can proceed without needing to provide credentials for the Oracle database. That is, you can connect with only the user name and password for connecting to the TimesTen database. However, when you want to perform cache operations that require connecting to the Oracle database, then you must provide the appropriate credentials to be able to connect to both the TimesTen and Oracle databases.

Once the cache administration users are created with their respective passwords, these credentials need to be provided in two places for cache operations to proceed.

  • Provided on the connection string: When you are connecting to the TimesTen database and are planning on performing cache operations that require TimesTen to connect to the Oracle database, the cache administration users and respective passwords are required. You can provide these either with the cache administration user and passwords saved in an Oracle Wallet (preferred) pointed to by the PwdWallet connection attribute or specified distinctly within the UID, PWD, PWDCrypt, and OraclePWD connection attributes. Providing credentials in a wallet is more secure than supplying a password on the connect string with the PWD or PWDCrypt connection attributes.

    See Providing Cache Administration User Credentials When Connecting.

  • Registered internally within TimesTen: There are cache operations that TimesTen performs for you. In order for TimesTen to connect to the Oracle database successfully to perform these cache operations, TimesTen needs to have the Oracle cache administration user and password credentials registered internally. In TimesTen Classic, the internal registration is accomplished when you run the ttCacheUidPwdSet built-in procedure. You can specify that the results of the ttCacheUidPwdSet built in procedure are saved in an Oracle Wallet (preferred) or in memory. The credentials are saved within an Oracle Wallet when you set the CacheAdminWallet=1 in the DSN as a first connection attribute (which is best set in the DSN).

    See Registering the Cache Administration User Name and Password.