Interoperability Notes

Oracle Applications Release 11.0
with Enterprise Edition Release 8.1.7

June 2001

This document describes the process to upgrade an existing Oracle Applications Release 11.0 database instance to use Oracle8i Enterprise Edition Release 8.1.7.1. The most current version of these notes is document 148902.1 on OracleMetaLink.

This document contains three sections. Determine which of the first two sections applies to your requirement, and follow the instructions for that section. The third section is background information that is relevant if you intend to run your Release 11.0 installation with Oracle8i.

• Upgrade existing Oracle Applications Release 11.0 database as part of Oracle Applications Release 11i Upgrade
  Contains instructions for upgrading an existing Oracle Applications database from Oracle8 Enterprise Edition Release 8.0.x, or from an older Oracle8i Enterprise Edition Release 8.1 to Oracle8i Enterprise Edition Release 8.1.7. After following instructions in this section, you will have to upgrade to Oracle Applications 11i immediately. You will no longer be able to use this database with Oracle Applications Release 11.0.
• Upgrade existing Oracle Applications Release 11.0 to run with Oracle8i
  Contains instructions for migrating or upgrading an existing Oracle Applications database from Oracle8 Enterprise Edition Release 8.0.x, or from an older Oracle8i Enterprise Edition Release 8.1 to Oracle8i Enterprise Edition Release 8.1.7. You will be able to use the Oracle Applications Release 11.0 installation with Oracle8i Database Server.

• Using Oracle8i with Release 11.0
  Contains information about multiple Oracle Homes (Server Partitioning) architecture.

This section of the document is only appropriate if you are upgrading your database as a category 3 step from the manual Upgrading Oracle Applications, Release 11i. If you are performing this upgrade as a category 1 step, or if you intend to use your Release 11.0 Applications with Oracle8i, then you should proceed to the next section.

1. Apply prerequisite patch
   If you are upgrading to 11i.3 (11.5.3) or earlier, then the Rapid Install created an 8.1.6 Oracle Home. You will need to obtain and install 11i patch 1637258 in pre-install mode using the adpatch utility. This patch contains revised database preparation scripts for Oracle8i Release 8.1.7. If you have Oracle Applications Release 11i.4 or higher, you require no additional patch.

2. Install Oracle8i Enterprise Edition
   Run the Oracle Applications Rapid Install to create your Oracle8i Oracle Home. We recommend that you use Oracle Applications 11i.4, as it contains the 8.1.7 release of Oracle8i. If you are using 11i.3 or earlier, you will need to first use the Rapid Install, then:
   • Install Oracle8i Enterprise Edition Release 8.1.7 files
     If you have not already unloaded the current Oracle8i Enterprise Edition Release 8.1.7 files, follow the instructions in the Oracle8i Installation Guide. Install the files in a location other than the 8.1.6 Oracle home created by Rapid Install. Choose to install all components required by Oracle Applications 11i, as well as any aditional components currently used in your Applications Release 11.0 database. At a minimum this will include the following components:
     • Oracle8i Server
     • Oracle InterMedia Text
     • Oracle Spatial
     • Advanced Replication
     • Oracle Partitioning
     • Net8 Server
     • Net8 Client
     • Oracle Connection Manager
     • Oracle Utilities
     • Oracle Java Products
     • Oracle Configuration Assistants
     • Development Tools
     • Oracle Installation Products
     • Oracle Universal Installer
     • Documentation

     Attention: Windows NT/2000 customers should not install the following development tools. These tools do not support multiple Oracle Homes and are not used by Oracle Applications. Oracle Objects for OLE Oracle ODBC Drivers Oracle OLE Providers for OLEDB

     We also recommend choosing all the languages, (or at a minimum all the required languages) during the installation.

     Do not run any migration scripts at this time.

   • Install 8.1.7 PatchSet 1
     Install the Oracle8i Release 8.1.7 patchset 1 files into the 8.1.7 Oracle Home using Oracle Universal Installer.

     Do not run any SQL scripts at this time.

   • Install Cumulative Database Patch
     Obtain and install the cumulative database patch 1761792. This patch is available via the OracleMetaLink patch download interface, or from Oracle Support. Windows NT/2000 users should install patch 8.1.7.1.3.

     Follow the instructions in the readme file of the patch.

     Attention: If you have already installed any RDBMS patches on top of 8.1.7.1, please contact Oracle Support Services prior to applying this patch.

   • Check OracleMetaLink for additional patches
     Additional issues with Applications running on 8.1.7 may have been identified since this document was authored. Check the Certify section of OracleMetaLink for the latest issues.

3. Migrate or upgrade the Oracle Applications Database
   Refer to the Oracle8i Migration manual of the current release for a description of these methods and complete instructions on how to migrate or upgrade the database.

4. Database Preparatory Scripts
   We recommend that you use Oracle Applications 11i.4, as it contains the 8.1.7 release of Oracle8i and appropriate upgrade documentation for 8.1.7 database server. If you are using 11i.3 or earlier, you must modify the instructions documented in the section titled Run preparatory scripts - database server, Database and System Administration Upgrade Steps, Category 3 of Upgrading Oracle Applications manual. Use addb817.sql and adsy817.sql scripts instead of the addb816.sql and adsy816.sql scripts otherwise documented (addb817_nt.sql and adsy817_nt.sql instead of addb817_nt.sql and adsy817_nt.sql on Windows NT/2000). These files are included in the pre-requisite 11i patch 1637258 which you installed in the first step of this section.

   Unlike the previous 8.1.6 version of the addbxxx.sql and addbxxx_nt.sql scripts, the Java Virtual Machine (JVM) is not installed by these scripts in 8.1.7. If you are using 11i.3 or earlierInstead, you must also install JVM properly by running the $ORACLE_HOME/javavm/install/initjvm.sql using Server Manager after connect as sysdba.

   	        cd  $ORACLE_HOME/javavm/install
   	        svrmgrl
   	        SVRMGR> connect / as sysdba 
   	        SVRMGR> @initjvm.sql
   	  

5. Database objects for Oracle HTTP server
   We recommend that you use Oracle Applications 11i.4, as it contains the 8.1.7 release of Oracle8i and appropriate upgrade documentation for 8.1.7 database server. If you are using 11i.3 or earlier, do not follow instructions in the Install database object for Oracle HTTP server, Database and System Administration Upgrade Steps, Category 3 of the upgrade preparation manual. These database objects are included in Oracle 8i Release 8.1.7 and are installed in the SYS schema.

This section contains instructions for upgrading an existing Oracle Applications Release 11.0 database from Oracle8 Enterprise Edition Release 8.0.x, or from an older Oracle8i Enterprise Edition Release 8.1 to Oracle8i Enterprise Edition Release 8.1.7.

If you wish to upgrade the Oracle Applications Release 11.0 database to prepare for the upgrade of the Oracle Applications Release 11i and you have already completed instructions in the Category 1, 2 and 3 of the manual Upgrading Oracle Applications, Release 11i, do not proceed. Follow the instructions in Section 1.

1. Apply Oracle8.0.6 Patch Set (UNIX only)
   To interoperate with Oracle8i, Oracle Applications 11.0 requires Oracle8.0.6 client libraries at patch level 1 or higher. If you are not already running 8.0.6 patch set 1 (8.0.6.1), obtain and install the patch now. If you are running Windows NT/2000, it is neither necessary nor recommended that you upgrade your client libraries to 8.0.6.

2. Apply Web Application Server patch (UNIX only)
   If you are using Oracle Web Application Server 3.0.2, then you require Web Application Server patch 1368568. Refer to the installation instructions in the readme file included in the patch.

3. Apply Oracle Receivables prerequisite patch
   Oracle Receivables must be at patch set D or higher to interoperate with Oracle8i. Upgrade to the latest patch set now, if you are not already at patchset D or higher.

4. Shutdown Applications
   All of the prior steps in this section can be done prior to the database migration or upgrade. From this point forward your Applications system will be unavailable until the process is complete.

   Shut down the Oracle Applications forms server, Oracle Web Applications Server, Concurrent Manager and any other applications processes.

5. Backup Database
   It is appropriate at this time to make a backup copy of your database.

6. Modify init.ora parameters
   Log in to the machine where the Oracle Applications Release 11.0 database is running as the user who manages the Oracle Server files and database.

   Some of the database initialization parameters have changed or become obsolete in Oracle8i Enterprise Edition Release. Details are available in the Oracle8i Migration Guide. If any such parameter exists in the database initialization file (init.ora), you must remove them or comment them out from the initialization file of the Oracle Applications Release 11.0 database.

   The following events are required in the database initialization file to maintain the compatibility of PL/SQL constructs supported in Oracle 7 and earlier releases of Oracle8. Add them to the init.ora file if they do not already exist.

   • event = "10929 trace name context forever"
   • event = "10932 trace name context level 2"

7. Install Oracle8i Enterprise Edition
   Log in to the machine where the Oracle Applications Release 11.0 database is running as a user whom you wish to manage the Oracle8i Enterprise Edition files and database.

   Make sure that none of the environment settings, such as ORACLE_HOME, PATH, ORA_NLS, etc. refer to the existing Oracle8 Enterprise Edition Release 8.0.x, or earlier Oracle8i Enterprise Edition Release environment. You must install the latest Oracle8i Enterprise Edition Release into a separate ORACLE_HOME.

   Follow the instructions in the Oracle8i Installation Guide to perform the installation. We recommend the Custom installation type with at least the following components :

   • Oracle8i Server
   • Net8 Server
   • Net8 Client
   • Oracle interMedia Text
   • Oracle Utilities
   We recommend installing the current release of Oracle8i Enterprise Edition in a new location.
   Do not run any migration scripts at this time.

8. Apply 8.1.7 Patch Set 1
   Install the Oracle8i Release 8.1.7 patchset 1 files into the 8.1.7 Oracle Home using Oracle Universal Installer.

9. Install Cumulative Database Patch
   Obtain and install the cumulative database patch 1761792. This patch is available via the OracleMetaLink patch download interface, or from Oracle Support. Windows NT/2000 users should install patch 8.1.7.1.3.

   Follow the instructions in the readme file of the patch.

10. Check OracleMetaLink for additional patches
    Additional issues with Applications running on 8.1.7 may have been identified since this document was authored. Check the Certify section of OracleMetaLink for the latest issues.

11. Ensure Adequate Rollback and System Space
    Ensure that there is sufficient free space in the SYSTEM tablespace (greater than 500 MB) and for the Rollback segments (greater than 250 MB).

12. Upgrade the Oracle Applications Database
    Refer to Oracle8i Migration Release 3 (8.1.7) for complete instructions on how to upgrade the database. Ensure that you have the latest version of the manual, which can be found on the Oracle Technology Network.

    You will be upgrading or migrating directly to Enterprise Server Release 8.1.7.1. You may disregard the admonition in the 8.1.7.1 README that warns that you cannot upgrade directly to 8.1.7.1.

    Upgrade the database. If you are upgrading from a previous Oracle8i release, then you must also follow the instructions for upgrading Oracle interMedia Text.

13. Migrate Oracle ConText database objects to Oracle interMedia
    If the Oracle Applications Release 11.0 databases is still using Oracle8 Enterprise Edition release, it contains Oracle ConText objects. Oracle8i replaces Oracle ConText with Oracle interMedia Text. Patch 1239901 contains the addbctx.sql script which drops all Oracle ConText database objects and replaces them with Oracle interMedia Text objects. Obtain and unzip this patch.

    Attention: Self-Service Purchasing 4.0 and iStore from CRM3i also make use of ConText/interMedia. If you use either of these products you may require additional patches. Check OracleMetaLink or contact Oracle Support Services for additional information.

    Copy the addbctx.sql script from patch 1239901 into the $ORACLE_HOME/apps/admin directory. If the apps/admin directory does not exist in your ORACLE_HOME, please create it. Run addbctx.sql in SQL*Plus while connected as SYSTEM. This script requires the following parameters in the order specified:

    Parameter	Default Value	Available Values	Recommended Value
    Remove ConText	FALSE	TRUE or FALSE	TRUE
    Default Tablespace	None	User Defined	CTXSYS
    Temporary Tablespace	None	User Defined	TEMP
    interMedia Shared Library	None	<ORACLE8.1.7.1 HOME>/ctx/lib/libctxx8.so on UNIX platforms ,or <ORACLE8.1.7.1 HOME>\bin\oractxx8.dll on Windows NT/2000

    The fourth parameter requires the full path name of the Oracle interMedia shared library, which is different for UNIX platforms and Windows NT/2000.

    For example, from the SQL*Plus prompt on UNIX platforms, you might run:

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

14. Configure the Net8 listener
    The Net8 listener must be configured such that the database can be accessed from the Oracle Applications Release 11.0 file system and the Oracle8 technology stack. Refer to the Net8 Administrator's Guide. Start the listener once it has been configured.

    Attention: When the following steps refer to "each Release 11 server", it is implied that we are referring to each Release 11 server except the database server - i.e. the forms server, web server, administration server, and concurrent processing server.

15. Set up the Net8 client
    Configure the SQL*Net client on each Release 11 server such that the Oracle Applications Release 11.0 file system can connect to the Oracle8i Enterprise Edition Release Applications database. Refer to Net8 Administrator's Guide.

    The TWO_TASK environment variable on UNIX, or the LOCAL environment setting on Windows NT/2000, must be set to the connect string of the Applications database that you define. The ORACLE_SID environment setting must not be set. Use SQL*Plus to test the connection.

16. Apply Applications 8i interoperability patch 1239901
    Use AutoPatch to apply patch 1239901. First apply the c1239901.drv driver file to the Oracle Applications file system on each Release 11 server. Then update the Oracle Applications database by applying the d1239901.drv driver file on the administration server.

17. Copy new adrelink file to $APPL_TOP/admin. (UNIX only)
    If any of your Release 11 servers are running UNIX, you must manually copy the new adrelink file that comes with patch 1239901 from the $AD_TOP/bin directory to the $APPL_TOP/admin directory on each Release 11 server that is running UNIX. Back up the existing file in $APPL_TOP/admin before you copy the new file. This file contains fixes for relinking Oracle Applications with the Oracle8 Enterprise Edition Release 8.0.x technology stack.

18. Apply Applications interMedia Text interoperability patch 1244775
    Use AutoPatch to apply patch 1244775. First apply the c1244775.drv driver file to the Oracle Applications file system on each Release 11 server. Then update the Oracle Applications database by applying the d1244775.drv driver file on the administration server.

19. Relink all Oracle Applications executables. (optional) (UNIX only)
    If any of your Release 11 servers are running UNIX, and you are upgrading the Oracle8 Enterprise Edition technology stack on those servers to Release 8.0.6.1 from any earlier Oracle8 Enterprise Edition release, you must relink all Oracle Applications executables on those servers.

    Run AD Administration on each Release 11 server to which this situation applies and choose the "Relink Applications programs" option from the Maintain Applications Files menu. Make sure to select all products for relinking.

20. Compile invalid objects
    Most of the database objects will be marked as invalid due to the database upgrade. To compile the objects that belong to the APPS schema, run AD Administration and choose the "Compile APPS schema(s)" option from the Maintain Applications Database Objects menu.

    There may be other invalid objects in other schemas, such as SYS, SYSTEM, CTXSYS, etc. You may use the $AD_TOP/sql/adcompsc.pls script to compile objects in these schemas. Run the script in SQL*Plus, connecting as any schema. The script takes 3 parameters:

    • schema in which to compile objects
    • schema password
    • partial name of the object or objects to compile (optional; use % if you wish to compile all invalid objects in a given schema)

Multiple Oracle Homes (Server Partitioning)

Oracle Applications Release 11.0 supports Oracle8i Enterprise Edition Release through server partitioning. The Oracle Applications file system continues to use one ORACLE_HOME using the Oracle8 Server Release 8.0 technology stack. An Oracle8i Enterprise Edition Release database server is installed in a second ORACLE_HOME, which is not necessarily on the same machine as the Oracle Applications file system.

Oracle Applications Release 11.0 database objects and data are stored in the database, which is located in the second ORACLE_HOME. Net8 handles communication between the Oracle Applications file system and the Oracle8i Enterprise Edition Applications database.

The following diagram illustrates the layers in a server partitioning model with two ORACLE_HOMEs. The server partitioning model works whether the Oracle8 ORACLE_HOME and the Oracle8i ORACLE_HOME are on the same machine or on different machines. If they are on the same machine, they must be in separate directories.

APPL_TOP ORACLE HOME		Database ORACLE HOME
Applications 11.0 File System Oracle8 Release 8.0.x Home Developer/2000 Server 1.6.1 Web Applications Server 3.0 Net8 client	Ü  Net8  Þ	Oracle8i Database Server Applications 11.0 Database interMedia Text Net8 listener

Server partitioning provides all the functional and performance advantages of running Oracle Applications with Oracle8i Enterprise Edition Release without having to relink or reinstall Oracle Applications executables. Using SQL*Net and Net8 to connect the Oracle Applications file system and the Oracle8i Enterprise Edition Applications database results in little or no degradation of performance.