Interoperability Notes Oracle EBS 12 with Oracle Database 10gR2 (10.2.0) 812362.1

This note is the master document describing the use of Oracle E-Business Suite Release 12 (12.0 and 12.1) with Oracle Database 10g Release 2 (10.2.0.x),
where x denotes the patch set level (currently 5). It may refer to related interoperability notes, which you should review if they apply to your specific release of the Oracle Database.

The most current version of this document is document 812362.1 on OracleMetaLink. There is a change log at the end of this document.

Attention: Interoperability notes of previous patch sets are available through the following links:
10.2.0.3 Interoperability Notes
10.2.0.4 Interoperability Notes

Attention: Check My Oracle Support to make sure that your platform and environment configuration are certified to work with Oracle Database 10g before performing any instruction in this document.

Attention: If you are going to use 10g Real Application Clusters (RAC) or Automatic Storage Management (ASM), see Using Oracle 10g Release 2 Real Application Clusters and Automatic Storage
Management with Oracle E-Business Suite Release 12 on My Oracle Support.

Attention: These notes apply to UNIX, Linux, and Windows platforms. However, you may need to modify some instructions slightly depending on your platform. For example, these notes typically
use UNIX/Linux syntax when specifying a directory, so Windows users will need to substitute the appropriate syntax when accessing that directory.

Attention: You can obtain the 10.2.0.5 patch set from patch 8202632 on My Oracle Support.

Upgrading an Existing Oracle Database 10g Release 2 (10.2.0) patch set

Follow the instructions in this section if you have an Oracle E-Business Suite Release 12.x system using Oracle 10g Release 2 (10.2.0) and you wish to apply the latest certified Oracle 10g Release 2 (10.2.0) patch set to it.

    Apply 10.2.0.5 interoperability patch 13725068 (conditional)

    If you are on E-Business Suite Release 12.0.4 or a later version, apply 10.2.0.5 interoperability patch for Release 12.0 (13725068)

    Perform 10.2.0.5 Patch Set preinstallation tasks (conditional)

    On the database server node, as the owner of the Oracle 10g file system and database instance, unzip and extract the patch set file appropriate for your platform.

Read the patch set notes (usually README.html) and make sure that you thoroughly understand the patch set installation process before you begin.

Check My Oracle Support or contact Oracle Support Services to determine any known issues with the patch set and its interoperability with Oracle Applications.

    Perform the tasks in the "Preinstallation Tasks" section of the patch set notes (if they apply to your system).

    Shut down Applications server processes

    Shut down all Applications and database server processes. The Applications will be unavailable to users until all tasks in this section are completed.

    Perform 10.2.0.5 Patch Set installation tasks

    On the database server node, as the owner of the Oracle RDBMS file system and database instance, perform the tasks in the "Installing the Oracle Database 10g Patch Set Interactively"

 section of the patch set notes. Make sure that you use the runInstaller (UNIX/Linux) or the setup.exe executable (Windows) provided in the patch set to run OUI.

    Do not perform the "Postinstallation Tasks" section yet.

    Perform 10.2.0.5 Patch Set postinstallation tasks

    Review the "Postinstallation Tasks" section of the patch set notes. Perform the steps that are relevant for your database.

    Note: Skip the sections "Upgrading Earlier Oracle Database to Oracle Database 10g Release 2 (10.2.0.5)" and "Enabling Oracle Database Vault" of the patch set notes.

    Apply additional 10.2.0.5 RDBMS patches

    Apply the following patches:

    For all UNIX/Linux platforms, apply RDBMS patches:
        4247037
        9726739
        9870614

    For all Windows platforms:
        Apply patch 1 or the latest Windows patch: 10058290 (32-bit), 10099855 (64-bit)
        4247037

    Attention: While not mandatory for the interoperability of Oracle E-Business Suite with the Oracle Database, customers may choose to apply Database Patch Set Updates (PSU) on their
Oracle E-Business Suite Database. If so, please see Document 1147107.1 ('Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite') on
My Oracle Support for more information.

    Gather statistics for SYS schema

    Copy $APPL_TOP/admin/adstats.sql from the administration server node to the database server node. Note that adstats.sql has to be run in restricted mode.
 Use SQL*Plus to connect to the database as SYSDBA and use the following commands to restart the database in restricted mode, run adstats.sql, and restart the database in normal mode:

        $ sqlplus "/ as sysdba"
        SQL> shutdown normal;
        SQL> startup restrict;
        SQL> @adstats.sql
        SQL> shutdown normal;
        SQL> startup;
        SQL> exit;

    Note: Make sure that you have at least 1.5 GB of free default temporary tablespace.

    Restart Applications server processes

    Restart all the Applications server processes that you shut down before installing the patch set. Users may return to the system.