Interoperability Notes

Oracle Applications Release 10.7
with Enterprise Edition Release 8.1.7

June 2001

This document describes the process to upgrade an existing Oracle Applications Release 10.7 database instance to use Oracle8i Enterprise Edition Release 8.1.7.1. The most current version of these notes is document 148901.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 10.7 installation with Oracle8i.

• Upgrade existing Oracle Applications Release 10.7 database as part of Oracle Applications Release 11i Upgrade
  Contains instructions for migrating an existing Oracle Applications database from Oracle7 Server Release 7.3.4, from Oracle8 Enterprise Edition Release 8.0.x, or from 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 10.7.
• Upgrade existing Oracle Applications Release 10.7 to run with Oracle8i
  Contains instructions for migrating or upgrading an existing Oracle Applications database from Oracle7 Server Release 7.3.4, from Oracle8 Enterprise Edition Release 8.0.x, or from 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 10.7 installation with Oracle8i Database Server.

• Using Oracle8i with Release 10.7
  Contains information about multiple Oracle Homes (Server Partitioning) and about PL/SQL syntax changes between Oracle7 and Oracle8i.

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 10.7 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 Database Server
   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 10.7 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
   If your Oracle Applications database is currently using Oracle7 Server Release 7.3.4, you must migrate the database to Oracle8i Enterprise Edition Release.

   If your Oracle Applications database is currently using Oracle8 Enterprise Edition Release 8.0.x or earlier Oracle8i Enterprise Edition Release, you must upgrade the database to Oracle8i Enterprise Edition Release.

   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 already included in Oracle 8i Release 8.1.7 and are installed in the SYS schema.

This section contains instructions for migrating or upgrading an existing Oracle Applications Release 10.7 database from Oracle7 Server Release 7.3.4, from Oracle8 Enterprise Edition Release 8.0.x, or from older Oracle8i Enterprise Edition Release 8.1 to the current Oracle8i Enterprise Edition Release.

If you wish to upgrade the Oracle Applications Release 10.7 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. Update Oracle7 Technology Stack
   If you are using Oracle7 Server Release 7.3.2.3 or Release 7.3.3, you must upgrade the technology stack to Release 7.3.4 and apply the corresponding interoperability patches before beginning the upgrade to Oracle8i Enterprise Edition.

   The interoperability patches are available on the Oracle Applications R10.7/Oracle7 Server 7.3.4 and Oracle InterOffice 4.1 Server 7.3.3 & 8.0.3 Interoperability Patches CD. We also recommend upgrading the Developer/2000 Release 1.3.2 to Oracle Developer 1.6.1 for Oracle Reports. Follow the instructions in the appropriate interoperability patch release notes.

   If you are using Oracle Web Application Server 3.0.2, you also require the Web Server patch 1368568. Follow the instructions in the readme file included in the patch.

2. Apply Release 10.7 Server Update
   If you are using the character mode interface to Oracle Applications Release 10.7 on UNIX, you must apply either the Release 10SC Production 16.1 server updates or the Release 10.7 NCA database server updates, if you haven't already done so. Oracle Applications Release 10.7 will not work properly with Oracle8i Enterprise Edition if these updates are not applied.

   The updates are located on the Oracle Applications 10SC Production 16.1 Server Update CD or the Oracle Applications Release 10.7 NCA Server Update for UNIX Servers CD. Follow all the instructions in the "Server Updates" chapter of either the Oracle Applications for MS Windows Clients Installation Manual, UNIX Server Edition, Release 10 SmartClient Production 16.1 or the Oracle Applications Release 10.7 NCA Installation Manual, UNIX Server Edition then perform the server-side tasks at the beginning of the "Post-Install Tasks" chapter of that manual.

   Windows NT/2000 installations should use the corresponding NT Server manuals.

3. Apply Release 10.7 Patch Sets
   We strongly recommend that you apply all of the patch sets included in the Release 10.7 Patch Sets Version 4 to your environment before upgrading to Oracle8i Enterprise Edition Release. At a minimum, you must be at the following patch set levels for Oracle Applications Release 10.7 to work properly with Oracle8i Enterprise Edition:
   • AP Patch Set Q (or higher)
   • AR Patch Set W (or higher)
   • AS Patch Set H (or higher)
   • AX Patch Set F (or higher)
   • OE Patch Set J (or higher)
   • PO Patch Set M (or higher)

   Refer to the Oracle Applications Release 10.7 Patch Sets, Version 4 Release Notes for complete instructions on applying these patch sets.

   Warning: Certain features of Oracle Self-Service Purchasing Version 4.0 (or higher), when used with Oracle Applications Release 10.7, may not work properly with Oracle8i Enterprise Edition. If you use, or plan to use this product, contact Oracle Support Services before upgrading to Oracle8i Enterprise Edition.

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.

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 10.7 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 10.7 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 10.7 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 Oracle7 Server Release 7.3.4, 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.

   Attention: On Windows NT/2000 machines, the Oracle7 Server installation architecture requires special handling to support multiple ORACLE_HOME directories. If you wish to put both ORACLE_HOMEs on the same Windows NT/2000 machine, you must install Release 7.3.4 first, and then install Release into a separate directory. If you install Release first and then try to install Release 7.3.4 into a separate directory, it will corrupt the Release installation. You should already have 7.3.4 installed, so this is not a problem.

   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 Utilities

   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/Certify 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. Migrate or Upgrade the Oracle Applications Database
    If your Oracle Applications database is currently using Oracle7 Server Release 7.3.4, you must migrate the database to Oracle8i Enterprise Edition Release.

    If your Oracle Applications database is currently using Oracle8 Enterprise Edition Release 8.0.x or earlier Oracle8i Enterprise Edition Release, you must upgrade the database to Oracle8i Enterprise Edition Release.

    Refer to Oracle8i Migration Release 3 (8.1.7) for a description of these methods and complete instructions on how to migrate or 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.

    Migrate or upgrade the database only, unless you have installed additional components for your own customizations. Additional components such as interMedia or JServer are not used by Oracle Applications Release 10.7.

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

14. Set up the SQL*Net client
    Log in to the machine where Oracle Applications Release 10.7 is installed as the user who manages the Oracle7 Server technology stack. (If you are using Release 10.7 NCA, log in to the Applications database server, not the forms server.) Make sure that all of the environment settings, such as ORACLE_HOME, PATH, ORA_NLS, etc. refer to the Oracle7 Server Release 7.3.4 technology stack environment. They must not refer to the new Oracle8i Enterprise Edition Release environment.

    Configure the SQL*Net client on the machine where Oracle Applications Release 10.7 is installed such that the Oracle Applications Release 10.7 file system can connect to the Oracle8i Enterprise Edition Release Applications database. Refer to Understanding SQL*Net, Release 2.3.

    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.

15. Apply Applications interoperability patch 499648
    If you are already using Oracle Applications Release 10.7 in a server partitioning environment with Oracle8 Enterprise Edition Release 8.0.x or earlier Oracle8i Enterprise Edition Releases, you should have already applied this patch to your environment and can skip this step.

    Use AutoPatch to apply only the file system portion of patch 499648. Apply the patch.drv driver file to update the Oracle Applications file system. Do not apply the db494405.drv driver file, and do not follow the special instructions in the readme.txt file of this patch.

16. Apply Oracle Receivables interoperability patch 480129
    If you are already using Oracle Applications Release 10.7 in a server partitioning environment with Oracle8 Enterprise Edition Release 8.0.x or earlier Oracle8i Enterprise Edition Releases, you should already have applied this patch to your environment and can skip this step.

    Use AutoPatch to apply patch 480129. Apply the patch.drv driver file to update the Oracle Applications file system.

17. Apply Oracle Applications DBA interoperability patch 487890
    If you are already using Oracle Applications Release 10.7 in a server partitioning environment with Oracle8 Enterprise Edition Release 8.0.x or earlier Oracle8i Enterprise Edition Releases, you should already have applied this patch to your environment and can skip this step.

    Use AutoPatch to apply patch 487890. Apply the patch.drv driver file to update the Oracle Applications file system. Do not follow the special instructions in the readme.txt file of this patch.

    This patch creates a new script called ADXGNPNS.sql, which you run in order to pin sequences. ADXGNPNS.sql is similar in function to ADXGNPIN.sql. If you run ADXGNPIN.sql, then you should also run ADXGNPNS.sql. See the comments in the script for more information.

18. Apply Oracle Payroll interoperability patch 583816
    If you are already using Oracle Applications Release 10.7 in a server partitioning environment with earlier Oracle8i Enterprise Edition Releases, you should already have applied this patch to your environment and can skip this step.

    Use AutoPatch to apply patch 583816. First apply the patch.drv driver file to update the Oracle Applications file system. Then, update the Oracle Applications database by applying the d583816.drv driver file.

19. Apply Oracle Master Scheduling interoperability patch 622114
    If you are already using Oracle Applications Release 10.7 in a server partitioning environment with earlier Oracle8i Enterprise Edition Releases, you should already have applied this patch to your environment and can skip this step.

    Use AutoPatch to apply patch 622114. First apply the patch.drv driver file to update the Oracle Applications file system. Then, update the Oracle Applications database by applying the d622114.drv driver file.

20. Apply Oracle Assets interoperability patch 1054707
    If you are already using Oracle Applications Release 10.7 in a server partitioning environment with earlier Oracle8i Enterprise Edition Releases, you should already have applied this patch to your environment and can skip this step.

    Use AutoPatch to apply patch 1054707. First apply the patch.drv driver file to update the Oracle Applications file system. Then, update the Oracle Applications database by applying the d1054707.drv driver file.

21. Compile invalid objects
    Most of the database objects will be marked as invalid due to the database migration or 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 10.7 supports Oracle8i Enterprise Edition Release through server partitioning. The Oracle Applications file system continues to use one ORACLE_HOME using the Oracle7 Server Release 7.3.4 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 10.7 database objects and data are stored in the database, which is located in the second ORACLE_HOME. SQL*Net and 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 Oracle7 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
Oracle APPS 10.7 File System Oracle7 Release 7.3.4 Tech Stack SQL*Net V2 client	Ü SQL*Net Þ Ü  Net8  Þ	Oracle8i Database Server Oracle APPS 10.7 Database 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.

If you are currently using Oracle Applications Release 10.7 with an Oracle7 Server Release 7.3.4 database on separate machines, and are, therefore, already using SQL*Net and Net8, then upgrading to an Oracle8i Enterprise Edition Release database (as described in these notes) should improve performance.

Changes in PL/SQL syntax from Oracle7 to Oracle8i