Registering the Cache Administration User Name and Password

You must register the Oracle database cache administration user name and password internally in the TimesTen database before any cache group operation can be issued.

The TimesTen database and some TimesTen utilities and built-in procedures perform cache operations on your behalf. In order to connect to the Oracle database, TimesTen must have the credentials of the Oracle cache administraiton user and password registered internally.

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, both the cache and replication agents connect to the Oracle database with the internally registered Oracle cache administration user credentials to manage Oracle database operations.

The Oracle database cache administration user name and password need to be registered only once in each TimesTen database that caches Oracle Database data unless the cache administration user name or its password is changed. For example, if you modify the password of the cache administration user, if the TimesTen database is destroyed and re-created, or if the Oracle cache administration user name is dropped and re-created in the Oracle database, the Oracle cache administration user name and password must be registered again.

The Oracle cache administration user name cannot be changed if there are cache groups in the database. The cache groups must be dropped before you can drop and recreate the cache administration user. See Changing Cache User Names and Passwords.

The following sections detail the different tools provided in TimesTen Classic and TimesTen Scaleout:

• Registering the Cache Administration User Name and Password in TimesTen Classic

• Registering the Cache Administration User Name and Password in TimesTen Scaleout