8 Prerequisites to Creating and Accessing a Cache Environment

Configuring the Oracle and TimesTen databases

Before you cache Oracle database data in a TimesTen database, you must perform certain tasks either outside of SQL Developer using command-line interfaces such as SQL*Plus and the ttIsql utility, or within SQL Developer using the SQL Worksheet.

The tasks include:

• Creating the timesten user, a schema user and the cache administration user in the Oracle database.

• Granting privileges required to perform cache operations to the Oracle database users.

• Creating the cache manager user and the cache table users in the TimesTen database.

• Granting cache privileges to the TimesTen users.

For information about creating Oracle database users and TimesTen users, see "Create the Oracle database users" and "Create the TimesTen users" in the Oracle TimesTen Application-Tier Database Cache User's Guide.

For information on configuring Oracle and TimesTen databases, see "Configuring the Oracle database to cache data in TimesTen Classic" and "Configuring a TimesTen database to cache Oracle Database data" in the Oracle TimesTen Application-Tier Database Cache User's Guide.

Set the cache administration user name and password

You must create a cache administration user in the Oracle database. This user enforces predefined behaviors of cache groups.

After you create the cache administration user in the Oracle database, you must set the name and password for the user in the TimesTen database.

To set the cache administration user name and password, right-click the node of the connection name for the TimesTen database and select Set Cache Administration User. See Figure 3-7, "Viewing a TimesTen connection".

The Setting the cache administration user dialog appears. For the Prompts tab, in the Cache administration user ID field, enter the cache administration user name. In the Cache administration user password field, enter the Oracle database password for the cache administration user.

Click Apply.

Figure 8-1 Setting the cache administration user dialog

Description of ''Figure 8-1 Setting the cache administration user dialog''

You must set the cache administration user name and password for each TimesTen database that caches an Oracle database. If you drop and re-create the TimesTen database or drop and re-create the cache administration user in the Oracle database, then the cache administration user name and password must be reset in the TimesTen database.

For more information about the cache administration user, see "Set the cache administration user name and password" in the Oracle TimesTen Application-Tier Database Cache User's Guide.

Start and stop the cache agent

After you set the cache administration user name and password, you must start the TimesTen cache agent process. The cache agent processes cache operations such as loading a cache group and automatic refresh.

To start the cache agent, right-click the node of the connection name for the TimesTen database and select Start/Stop Cache Agent. See Figure 3-7, "Viewing a TimesTen connection".

In the Starting/stopping the cache agent dialog box, select Start agent within the Prompts tab. Then click Apply to start the cache agent.

Figure 8-2 Starting/stopping the cache agent

Description of ''Figure 8-2 Starting/stopping the cache agent''

To stop a running cache agent process, right-click the node of the connection name for the TimesTen database and select Start/Stop Cache Agent in an identical fashion as was done when starting the cache agent.

In the Starting/stopping the cache agent dialog box, select Stop agent within the Prompts tab. Then click Apply to stop the cache agent. See Figure 8-2, "Starting/stopping the cache agent".

For more information about the cache agent process, see "Managing the cache agent" in the Oracle TimesTen Application-Tier Database Cache User's Guide.