Upgrade the database instance
On the database server node, as the owner of the Oracle8i
file system and database instance, perform steps 8-20 of the
"Upgrade the Database Manually" subsection of the "Upgrading the
Database to the New Oracle8i Release" section of Chapter 7
of Oracle8i Migration, Release 3 (8.1.7).
When you perform the task of adjusting the initialization
parameter file for use with the new release, in addition to the
changes that the Migration manual directs you to make, add or
update the following parameter in the init<SID>.ora file:
compatible = 8.1.7
If the init<SID>.ora file contains the following parameter,
remove it:
event="10943 trace name context forever, level 2"
Add or update the following parameters in the ifilecbo.ora file:
optimizer_features_enable = 8.1.7
_new_initial_join_orders = TRUE
_sqlexec_progression_cost = 0
optimizer_max_permutations = 2000
In the "Upgrading Specific Components" section of Chapter 7, the
tasks in the following subsections must be performed:
- Upgrading interMedia Text From a Previous 8.1
Release
- Upgrading Oracle Replication
- Upgrading JServer
Oracle Spatial also needs to be upgraded. Please refer to
the document Oracle Spatial User's Guide and Reference,
Release 8.1.7 for instructions on how to upgrade Oracle Spatial.
The other subsections apply to components that are not used in
an Applications database instance by default. Unless you have
manually enabled such components in the Applications database
instance, there is no need to perform the tasks in their subsections.
When upgrading JServer, you may disregard steps 14 through 21
because the Oracle Servlet Engine (OSE) is not used in Applications
database instances. You may also disregard the steps for starting the
Java Accelerator in step 22; however, you must load the XML Parser
for PL/SQL and the XML Class Generator for Java.
To load an XML jar file, use the command:
loadjava -user sys/<sys password> -r -v <jar file>
| Attention:
Due to doc bug 1930973, the PDF version of the Migration manual
is missing an important step (running catxsu.sql) of the
Upgrading JServer subsection, and therefore only has 21 steps.
The HTML version does not have this problem. Make sure that your
version of the manual has 22 Upgrading JServer steps before
performing them.
|
Re-create database links (conditional)
If the port of the Net8 listener in the 8.1.7 Oracle home is
different than that used by the Net8 listener in the 8.1.6 Oracle
home, then you must re-create any self-referential database links
that exist in the Applications database instance. To check for the
existence of database links, use SQL*Plus on the database server
node to connect to the Applications database instance as APPS
and run the following query:
$ sqlplus apps/<apps password>
SQL> select db_link from dba_db_links;
If the EDW_APPS_TO_WH and APPS_TO_APPS database links exist, use
the following commands to drop and re-create them:
$ sqlplus apps/<apps password>
SQL> alter session set global_names=false;
SQL> drop database link EDW_APPS_TO_WH;
SQL> drop database link APPS_TO_APPS;
SQL> create database link EDW_APPS_TO_WH connect to apps
identified by <apps password> using
'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host name>)
(PORT=<port number>))(CONNECT_DATA=(SID=<ORACLE_SID>)))';
SQL> create database link APPS_TO_APPS connect to apps
identified by <apps password> using
'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host name>)
(PORT=<port number>))(CONNECT_DATA=(SID=<ORACLE_SID>)))';
where <host name> is the host name of the database server
node, <port number> is the port number of the new Net8 listener
for the database instance, and <ORACLE_SID> is the
ORACLE_SID of the database instance.
If you have custom self-referential database links in the database
instance, use the following commands to drop and re-create them:
$ sqlplus apps/<apps password>
SQL> drop database link <custom database link>;
SQL> create database link <custom database link> connect to
<user> identified by <password> using
'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host name>)
(PORT=<port number>))(CONNECT_DATA=(SID=<ORACLE_SID>)))';
where <custom database link>, <user>, <password>,
and <ORACLE_SID>
are all as they were in the original database link definition,
and <port number> is the port number of the new Net8 listener
for the database instance.