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

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

Go to previous page
Previous
Go to next page
Next
View PDF

2 Prerequisites to Creating and Accessing a Cache Environment

After you establish a connection to the TimesTen database, there are some tasks that you must perform before you can start caching Oracle data in the TimesTen database or access cached data.

Set the cache administration user name and password

You need to 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 and enforce predefined behaviors of particular cache group types. After this user is defined, you must set its user name and password in the TimesTen database. (Cache grids apply only to TimesTen 11g and later.)

To set the cache administration user name and password, right-click the node that contains the name of your database connection and select Set Cache Administration User.

Surrounding text describes setcacheadmin.gif.

In the Prompts tab of the Setting the cache administration user dialog box, specify the cache administration user name in the Cache administration user ID field, if this field does not already contain a user name, and the corresponding password for this user in the Cache administration user password field. Then click the Apply button to set the cache administration user name and password in the TimesTen database.

Surrounding text describes cacheadminpassword.gif.

The cache administration user name and password need to be set only once in each TimesTen database that will cache Oracle data unless it needs to be changed. For example, if the TimesTen database is destroyed and re-created, or the cache administration user name is dropped and re-created in the Oracle database, the cache administration user name and password must be set again.

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 or "Create Oracle users and set privileges" in the TimesTen Cache Connect to Oracle Guide.

Configure a cache grid

Before you can create a cache group in a TimesTen database, you must perform certain tasks 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:

Note:

These tasks apply only with TimesTen 11g and later.

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 need to start the cache agent process if it is not already running. This TimesTen process performs cache operations such as loading a cache group and automatic refresh.

To start the cache agent, right-click the node that contains the name of your database connection and select Start/Stop Cache Agent.

Surrounding text describes cacheagent.gif.

In the Starting/stopping the cache agent dialog box, put a check in the Start agent check box within the Prompts tab. Then click the Apply button to start the cache agent.

Surrounding text describes startcacheagent.gif.

To stop a running cache agent process, right-click the node that contains the name of your database connection 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, put a check in the Stop agent check box within the Prompts tab. Then click the Apply button to stop the cache agent.

Surrounding text describes stopcacheagent.gif.

For more information about the cache agent process, see "Managing the cache agent" in the Oracle In-Memory Database Cache User's Guide or "Starting and stopping the cache agent" in the TimesTen Cache Connect to Oracle Guide.