Oracle Applications Release 11.0.3 Interoperability Patch for Oracle8i Server Release 8.1.6

March 2000

---

• Prerequisites

 

Explains prerequisite patches that should be applied before proceeding with the interoperability patch.
 

• Server Partitioning

Explains how to run Oracle Applications Release 11.0.3 with Oracle8i Server Release 8.1.6.
 

• Upgrading to Oracle8i Server Release 8.1.6

Contains instructions for upgrading an existing installation of Oracle Applications Release 11.0.3 from Oracle8 Server Release 8.0.4 (or higher) to Oracle8i Server Release 8.1.6. Note that Oracle Applications Release 11.0.3 was initially released with the Oracle8 Server, which included the Oracle ConText option. In Oracle8i, Oracle ConText is replaced by Oracle interMedia. The upgrade instructions in Section 3 include required steps for migration from Oracle ConText to Oracle interMedia.
 

Attention: These notes apply for all platforms, but you may need to modify some instructions slightly depending upon your platform. For example, these notes use the UNIX forward slash (/) character as the pathname separator, but you would type the backslash character (\) on Windows NT to separate the elements in a pathname.

Section 1: Prerequisites

---

If you are currently using Oracle Applications Release 11.0.1 or 11.0.2, you must install the Oracle Applications Release 11.0.3 Maintenance Pack first. The Oracle Applications Release 11.0.3 Maintenance Pack CD is not included in this interoperability release.

These notes currently provide instructions for using Oracle8 Server Releases 8.0.4, 8.0.5, and 8.0.6 technology stack with the Oracle Applications file system. The minimum Oracle8 Server Release 8.0.4 technology stack requirements for Oracle Applications Release 11.0.3 are documented in the Release 11 Oracle Applications release notes.

If you wish to use Oracle8 Server Release 8.0.5 technology stack, Oracle Applications Release 11.0.3 requires 8.0.5 Patch Set 2 (or higher). This patch set is not included on this CD. Please check Oracle MetaLink or contact Oracle Support Services for the 8.0.5 Patch Set 2.

If you wish to use Oracle8 Server Release 8.0.6 technology stack, Oracle Applications Release 11.0.3 requires 8.0.6 Patch Set 1 (or higher). This patch set is not included on this CD. Please check Oracle MetaLink or contact Oracle Support Services for the 8.0.6 Patch Set 1.

Oracle Applications Release 11.0.3 also requires the JDK 1.1 JDBC OCI Driver, which you can install from the Oracle8 Server Release CD. Choose the custom installation to ensure that this driver is installed along with the rest of the products. Choosing the default installation may not install this driver. You must also install the JDK 1.0 JDBC OCI Driver, which is located on the Oracle Web Application Server CD.

Oracle Web Application Server may require additional patches for your installation depending on the version of Oracle Web Application Server currently installed. The Oracle Applications Interoperability CD contains the required Oracle Web Application Server patches.
 

Section 2: Server Partitioning

---

The following diagram illustrates the layers in a server partitioning model with two ORACLE_HOMEs. The server partitioning model works whether the Oracle8 Server Release 8.0.4 (or higher) technology stack and the Oracle8i Server ORACLE_HOME are on the same machine or on different machines. The Oracle8 Server Release 8.0.4 (or higher) technology stack and the Oracle8i Server ORACLE_HOME directories must be separate physical directories.
 

Oracle 8.0 ORACLE_HOME + APPL_TOP Oracle8 Server Rel 8.0.x Developer/2000 Rel 1.6.1 Oracle Web Application Server 3.0.2 Net8 Client Oracle Applications Rel 11.0.3 Server Files

--------->   ---Net8-->   --Connect->   --------->   --------->

Oracle8i ORACLE_HOME Oracle8i Server  Net8 Listener Oracle Applications Rel 11.0.3 Database

Server partitioning provides all the functional and performance advantages of running Oracle Applications with Oracle8i Server without having to relink Oracle Applications executables. Using Net8 to connect the Oracle8 Server 8.0.4 (or higher) technology stack and the Oracle8i Server ORACLE_HOME results in little or no degradation of performance.
 

Section 3: Upgrading to Oracle8i Server Release 8.1.6

---

Setting Up the Database Server using Oracle8i Server

Make sure that none of the environment variables, such as ORACLE_HOME, PATH, ORA_NLS, LD_LIBRARY_PATH, and so on, refers to the Oracle 8.0 Server technology stack environment. They must refer to the new Oracle8i environment.

Step 1: Install Oracle8i Server.

Step 2: Modify init.ora parameters.

• SEQUENCE_CACHE_ENTRIES
• SEQUENCE_CACHE_HASH_BUCKETS
• USE_ISM
• DISTRIBUTED_LOCK_TIMEOUT

event = "10932 trace name context level 2"

Step 3: Upgrade the Oracle Applications database.

Step 4: Copy database preparatory scripts into the ORACLE_HOME.

Step 5: Run database preparatory scripts.

The adsy816.sql script creates system objects for Oracle Applications. Run this script in the Server Manager while connecting as SYSTEM.

NOTE: WHAT ABOUT CONNECTING TO INTERNAL ON NT?

Step 6: Install Oracle interMedia Objects.

If you are currently using off-cycle products, such as Self Service Purchasing 4.0 or I-Store, you require additional patches. Please check Oracle MetaLink or contact Oracle Support Services for more information. If you have customized usage of Oracle ConText, please read the Oracle Context to Oracle interMedia Migration Guide for details.

The addbctx.sql script creates Oracle interMedia objects for Oracle Applications. It should be run in SQL*Plus while connected as SYSTEM. This script requires the following arguments in the order specified.
 

Description	Default	Available	Recommended
Remove Context	FALSE	TRUE or FALSE	TRUE
Default Tablespace	None	User Defined	CTXSYS
Temporary Tablespace	None	User Defined	TEMP
Oracle interMedia Library	None	[ORACLE_HOME]/ctx/lib/libctxx8.so

The fourth parameter requires the full path name of the Oracle interMedia shared library. The Oracle interMedia Shared Object library libctxx8.so is available in ctx/lib of the Oracle8i Enterprise Edition Server Home directory.

For example, from the SQL*Plus prompt:

     SQL> @addbctx.sql TRUE CTXSYS TEMP /d1/oracle/816/ctx/lib/libctxx8.so



Step 7: Set up the Net8 listener for this database.

The Net8 listener must be configured for this database so that it can be

accessed from the Oracle8 Server technology stack that you use for Oracle

Applications Release 11.



Oracle Server Technology Stack Requirements

Chapter 2 on the Release 11 Oracle Applications Installation manual contains

step-by-step instructions for setting up the server technology stack.

We recommend that you use a login account (such as oracle) rather than

the Applications login account (typically applmgr) to manage the Oracle8

Server files and database.

Make sure that all the environment variables, such as ORACLE_HOME, PATH,

ORA_NLS, LD_LIBRARY_PATH, and so on, refer to the Oracle 8.0 Server technology

stack environment. They must not refer to the new Oracle8i environment.

The environment variable TWO_TASK should contain the connect string of

the Oracle8i Applications database.



Step 8: Verify Oracle Server technology stack.

You must be running Oracle Applications Release 11.0.3 with either Oracle8

Server Release 8.0.4 Patch Set 2 (or higher) OR with Oracle8 Server Release

8.0.5 Patch Set 2 (or higher) OR with the Oracle8 Server Release 8.0.6

Patch Set 1 (or higher). Refer to the Set Up the Technology Stack section

of Chapter 2, Release 11 Oracle Applications Installation, for complete

instructions.



Step 9: Set up the Net8 client for the Oracle Applications database.

The Net8 tnsnames.ora file must be configured so that you can access the

Oracle Applications Release 11.0.3 database on the Oracle8i Server.

This file must be configured to work from the Oracle8 Server technology

stack.



Oracle Applications Server Requirements.

This section lists the Oracle Applications Server requirements. We recommend

that you use the Applications login account (such as applmgr) rather than

the Oracle login account (typically oracle) to manage the Oracle Applications

Server files.

Make sure that all the environment variables, such as ORACLE_HOME, PATH,

ORA_NLS, LD_LIBRARY_PATH, and so on, refer to the Oracle 8.0 Server technology

stack environment. They must not refer to the new Oracle8i environment.

The environment variable TWO_TASK should contain the connect string of

the Oracle8i Applications database.



Step 10: Compile invalid objects.

Since the database was upgraded, most of the objects are currently in an

invalid state. To Validate all these objects, run AD Administration (adadmin)

on the administration server and choose Compile Apps Schema(s) from the

Maintain Applications Database Objects menu. When all objects are compiled,

choose Return to the Main Menu, then choose Exit. This step compiles all

the objects in the APPS schema only.

There may be other invalid objects in other schemas, such as SYS, SYSTEM,

CTXSYS , and so on. You may use the AD_TOP/sql/adcompsc.pls script to compile

other schema. Execute this script using SQL*Plus.



Step 11: Unload Oracle Applications patches.

Oracle Applications patches 964742, 1239901 and 1244775 are located on

the CD and are available from Oracle MetaLink.

Create an empty patch directory on your all machines that are Oracle

Applications servers and copy the patch directories into this directory

from the media. If you are downloading this patch from Oracle MetaLink,

you must unzip the downloaded file into an empty patch directory on your

server.



Step 12: Apply Oracle Receivables pre-requisite patch 964742.

Apply the patch to the Oracle Applications filesystem using the c964742.drv

driver file first on all servers. Then apply the update the Oracle Applications

database using the d964742.drv driver file on the administration server.

Then generate all modified files using the g964742.drv driver file.



Step 13: Apply Oracle8i Interoperability patch 1239901.

Apply the patch to the Oracle Applications file system using the c1239901.drv

driver file first on all Release 11 servers. Then apply the update the

Oracle Applications database using the d1239901.drv driver file on the

administration server.

You must manually copy the adrelink file from the AD_TOP/bin directory

to the APPL_TOP/admin directory. This file contains fixes to relink Oracle

Applications for Oracle8 Server Release 8.0.x.

You can back up the existing file to any location before you copy these

files from the AD_TOP/bin directory.



Step 14: Apply Oracle interMedia Interoperability patch 1244775.

You must apply patch 1244775 using adpatch. Apply the patch to the Oracle

Applications filesystem using the c1244775.drv driver file first on all

Release 11servers. Then apply the update the Oracle Applications database

using the d1244775.drv driver file on the administration server.



Step 15: Relink all Oracle Applications executables (optional)

If you are also upgrading the Oracle8 Server technology stack to Oracle8

Server Release 8.0.6.1 from an earlier Oracle8 Server Release 8.0.x, you

must relink all Oracle Applications executables on all servers. Use AD

Administration (adadmin) and choose Relink Applications programs from the

Maintain Applications Files menu. When all the executables are linked,

choose Return to the Main Menu, then choose Exit.



Step 16: Compile invalid objects.

After applying the patches in the previous steps, many objects are in an

invalid state. To Validate all these objects, run AD Administration (adadmin)

on the administration server again and choose Compile Apps Schema(s) from

the Maintain Applications Database Objects menu. When all objects are compiled,

choose Return to the Main Menu, then choose Exit. This step compiles all

the objects in the APPS schema only.