Skip Headers
Oracle® SQL Developer Oracle TimesTen In-Memory Database Support User's Guide
Release 3.1

Part Number E25286-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

2 Prerequisites to Creating and Accessing a Cache Environment

After you create the TimesTen database, and before you cache Oracle data in the TimesTen database, you must perform the tasks:

Configuring the Oracle and TimesTen databases

Before you cache Oracle 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:

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

For information on configuring Oracle and TimesTen databases, see "Configuring the Oracle database to cache data in TimesTen" and "Configuring a TimesTen database to cache Oracle data" in the Oracle In-Memory 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 creates, owns and maintains Oracle objects that store information used to manage a specific cache grid. This user also 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 1-3, "Viewing a TimesTen connection".

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

Click Apply.

Figure 2-1 Setting the cache administration user dialog

Description of Figure 2-1 follows
Description of "Figure 2-1 Setting the cache administration user dialog"

You must set the cache administration user name and password for each TimesTen database that caches Oracle. 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 In-Memory Database Cache User's Guide.

Configure a cache grid

Before you can create a cache group in a TimesTen database, you must perform certain tasks either outside of SQL Developer using a command-line interface such as the ttIsql utility, or within SQL Developer using SQL Worksheet. See "Configuring a cache grid" in the Oracle In-Memory Database Cache User's Guide for information regarding the following tasks:

Start and stop the cache agent

After you set the cache administration user name and password, create a cache grid and associate the TimesTen database with the cache grid, 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 1-3, "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 2-2 Starting/stopping the cache agent

Description of Figure 2-2 follows
Description of "Figure 2-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 2-2, "Starting/stopping the cache agent".

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