Providing Cache Administration User Credentials When Connecting

When you are connecting to the TimesTen database with the intent on performing cache operations that require TimesTen to connect to the Oracle database, then the cache administration users and their respective passwords are required.

Supply the cache administration user credentials in the connection string either by:

  • You can provide the Oracle and TimesTen cache administration users credentials within an Oracle Wallet. This method requires you to first save the cache administration user credentials in an identifiable Oracle Wallet with the ttUser utility. After creating the wallet, the particular wallet is identified by UID and PwdWallet connection attributes on the connection string. This is the preferred method as it is more secure. See Connect Using an Oracle Wallet with Credentials.

    Note:

    Most sections in this book provide security credentials for both cache administration users with an Oracle Wallet.

  • You can provide the cache administration user name and passwords on the connection string. Specify the cache administration user name in the UID connection attribute. Specify the TimesTen cache administration user password in the PWD or PWDCrypt connection attribute and the Oracle cache administration user password in the OraclePWD connection attribute. See Connect Using Connection Attributes for Credentials.