Oracle9i Application Server Migrating from Oracle Internet Application Server 1.0.0 Release 1.0.2 for Sun SPARC Solaris Part Number A86723-01 |
|
This chapter explains the process of migrating from Oracle Database Cache version 1.0.0 (formerly known as Oracle8i Cache) to 1.0.2 in Oracle9i Application Server.
Before migrating to Oracle9i Application Server, Release 1.0.2, you must first deinstall Oracle Database Cache.
The recommended method of deinstalling Oracle Database Cache consists of the following steps:
prompt> wtacca -deinstall
Then, install Oracle Database Cache by installing Oracle9i Application Server, Enterprise Edition. Follow the instructions in the Oracle9i Application Server Installation Guide, Release 1.0.2 for Sun SPARC Solaris.
No pre-migration tasks are necessary.
The following sections explain any environment variable changes you must make for Oracle Database Cache to access the proper executables, libraries, and configuration parameters. You must make the changes for the process in which you will run applications that access the cache.
You will need to make changes to the environment variables described in Table 10-1.
Variable | Description |
---|---|
PATH |
Defines the search order for executables. |
LD_LIBRARY PATH |
Defines the search order for libraries. |
ORA_OCI_CACHE |
Enables routing of queries to the cache. |
Update any PATH entries that refer to OLD_HOME so they point to NEW_HOME.
Set LD_LIBRARY_PATH so that the Oracle Database Cache library directory (NEW_HOME/lib) precedes library directories from other Oracle homes.
Set ORA_OCI_CACHE to "1" so that all applications started from the process will use the cache. (Alternatively, you use parameters within OCI applications to control which applications or statements use the cache. For more information, see the Oracle Database Cache Concepts and Administration Guide in the Oracle9i Application Server Documentation Library.)
If you use the environment variable TNS_ADMIN, make sure that it is set to the NEW_HOME/network/admin directory.
After you install Oracle Database Cache, you use Cache Manager to set up your cache. If you have Oracle Database Cache on more than one node and you have the same tables cached on all nodes, you can install the new version on one middle-tier node, then use Cache Manager to copy tables to the newly installed cache.
After you have installed the new version on one middle-tier node, take the following steps:
Because of new and changed features in this release, you must take the following action:
This release of Oracle Database Cache includes the following new or changed features:
You can cache PL/SQL packages, procedures, and functions. To cache the PL/SQL objects, use the supplied PL/SQL procedure DBMS_ICACHE.ADD_PLSQL_OBJECT
.
Now, Oracle Database Cache routes PL/SQL subprograms and anonymous blocks to the cache. To enable or disable this routing, use the supplied PL/SQL procedure DBMS_ICACHE.SET_FLAG
with the parameter PLSQL_ROUTING_ENABLED
.
You can enable or disable the gathering of statistics by using the supplied PL/SQL procedure DBMS_ICACHE.SET_FLAG
with the parameter STATS_REPORTING_ENABLED
.
For more information about these features, see the Oracle Database Cache Concepts and Administration Guide in the Oracle9i Application Server Documentation Library.
This release of Oracle Database Cache provides PL/SQL packages that allow you to manage caches using a utility such as SQL*Plus. These packages provide the same functionality as that provided by Cache Manager. In addition, they allow you to:
For more information see the Oracle Database Cache Concepts and Administration Guide in the Oracle9i Application Server Documentation Library.
|
Copyright © 2000 Oracle Corporation. All Rights Reserved. |
|