C
Installing Oracle Database Cache on the Origin Database System

This chapter guides you through the steps necessary to install Oracle Database Cache on the same machine as the origin database.

Contents

• Introduction

• Pre-installation Tasks

• Installation and Post-installation Tasks

Introduction

To install and run Oracle Database Cache and the origin database on the same machine, you must take special steps before and during installation.

For example, unless you take the steps described here, the Oracle Database Cache Configuration Assistant will fail when it attempts to connect with the origin database because the database had been shut down before launching the installer.

This section guides you through the configuration steps necessary to install and run Oracle Database Cache on the same machine as the origin database.

Pre-installation Tasks

Before you start the Oracle Database Cache installation, perform the following configuration steps for the origin database:

1. Edit the listener.ora file for the origin database, adding the following entries:

   # listener configuration file for an origin database
   
   CONNECT_TIMEOUT_LISTENER = 0
   
   LISTENER = 
   (DESCRIPTION_LIST =
   

   (DESCRIPTION = 
   

   (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL=tcp) (HOST= <hostname>) (PORT = 1521))
   )
   

   )
   

   )
   
   SID_LIST_LISTENER = (SID_LIST =
   

   (SID_DESC =
   

   (SID_NAME = <origin_sid>)
   

   (GLOBAL_DBNAME=<origin_dbname>) (ORACLE_HOME=<origin_home_spec>))
   
   (SID_DESC = (SID_NAME = extproc)
   (GLOBAL_DBNAME = extproc)
   (ORACLE_HOME = <origin_home_spec>) (PROGRAM = extproc))
   

   )
   

   The listener must be listening on a TCP port, such as 1521.

2. Configure the listener for the origin database so that it listens for external procedure calls, as described in "Configure the Listener for External Procedures".

3. Allow remote access to origin database through Oracle Database Cache, such as described in "Allow Remote Access to the Origin Database".

4. Make sure that the following environment variables are set before you start the listener:
   • ORACLE_HOME: Defined as the ORACLE_HOME for the origin database.

   • LD_LIBRARY_PATH: Defined as ORACLE_HOME/lib for the origin database.

   • PATH: Defined as ORACLE_HOME/bin for the origin database.

5. Start the listener and be sure that the origin database is started.

Installation and Post-installation Tasks

During the Oracle Database Cache installation, follow the installation instructions in "Enterprise Edition", with the following exceptions:

1. If possible, install Oracle Database Cache using a different user than for the origin database. At a minimum, you must start the installation from a different process from which you started the origin database.

2. For that user (or process), make sure that the following environment variables are not set during the Oracle9i Application Server installation:
   • ORACLE_HOME

   • ORACLE_SID

   • TNS_ADMIN

3. For that user (or process), make sure that either the environment variable LD_LIBRARY_PATH is not set or, if it is set, that it does not include ORACLE_HOME/lib for the origin database.

4. For that user (or process), make sure that the environment variable PATH does not include ORACLE_HOME/bin for the origin database.

5. You must install Oracle Database Cache in a separate Oracle home.

6. When the Oracle Database Cache Configuration Assistant - It enables you to configure your middle-tier caches. For instructions on running the Oracle Database Cache Configuration Assistant, refer to "Oracle Database Cache" on page A-3. appears, during the installation, do not click Next immediately. Instead, open another terminal window and look at the listener.ora file for Oracle Database Cache. This file is located in:

   <ORACLE_HOME>/network/admin
   
   

   Verify that there are no conflicts between port numbers for the origin database and the cache. If there are, edit the listener.ora file to change the port numbers for the cache.

7. In the Configuration Assistant, click Next to continue the configuration. For instructions on running the Configuration Assistant, refer to "Oracle Database Cache".

After the installation completes, be sure to perform the post-installation steps described in "Oracle Database Cache".