Prepare the Oracle Database for Cache Operations

As a prerequisite for setting up the TimesTen database as a cache for tables from an Oracle database, you need to configure the Oracle database for cache operations. In order to configure the Oracle database for cache operations, you need database administrator access.

Connect to the Oracle database as a database administrator to configure the Oracle database for cache operations. This example uses the SQL*Plus utility:

% sqlplus sys@tnsservicename as sysdba
Enter password: password

Note:

The use of the sys@tnsservicename as sysdba user in this example is applicable only for a test environment.

The following shows the steps necessary for preparing the Oracle database for cache operation:

Description of the illustration preporacle.eps

Note:

If you are using Oracle Autonomous Database Serverless or Oracle Autonomous Database on Dedicated Exadata Infrastructure for the Transaction Processing workload type, use the preconfigured databases services LOW or TP. In addition, if you are using a multitenant container database (CDB) or pluggable database (PDB), note the specific instructions below on how to create the cache administration user and grant this user privileges in a CDB or PDB.

• Task 1: Create the Tablespace for Cache Metadata and Management Objects

• Task 2: Create the Cache Administration User on the Oracle Database

• Task 3: Identify Schema Users on the Oracle Database

• Task 4: Grant SQL Privileges to the Cache Administration User on the Oracle Database