Upgrading the Oracle Application Server 10g (10.1.2|10.1.4) Seeded Database from 10.1 to 10.2 (Doc ID 376689.1)

Last updated on SEPTEMBER 13, 2023

Applies to:

Goal

Purpose

• The purpose of this article is to document the general steps and known issues in order to upgrade the seeded Oracle Database Server 10.1 which contains the Oracle Application Server 10g Release 2 (10.1.2) or Oracle Identity Management 10g (10.1.4) Metadata Repository.
• The seeded Oracle Database Server 10g installed with version 10.1.2.0.2 is initially 10.1.0.4.2, and may have been upgraded to 10.1.0.5. The seeded Oracle Database Server with version 10.1.4.0.1 is installed as 10.1.0.5. At this time, there is no strict requirement to be on a specific patching level in order to perform the upgrade.
• To be considered a "seeded" Oracle Database Server 10g (10.1), it would mean it was installed as part of the Oracle Application Server 10g or Oracle Identity Management 10g Infrastructure media, either in a full co-located Infrastructure installation type or distributed Infrastructure (separate MR and IM homes) to be considered for this upgrade. These steps have been tested with a full Business Intelligence and Forms (including Portal & Wireless) middle-tier, confirming working functionality after the upgrade.
• The upgrade process itself is designed to follow normal Oracle Database Server 10g Release 2 (10.2) upgrade instructions, although there are some considerations for the Metadata Repository installed schemas and objects. At this time, there is no strict requirement to be on a specific patching level in order to perform the upgrade.

Important Notes:

• If Oracle Application Server 10g (10.1.2) or Oracle Identity Management 10g (10.1.4) full Infrastructure is installed on a 64-bit platform, an Oracle Database 10g (10.1) is installed as a 32-bit application. (These cases include 64-bit versions of Windows, Linux and Solaris). For this reason, there may be difficulty upgrading to Oracle Database 10g (10.2). The choice is to install a 32-bit DB 10.2 or 64-bit DB 10.2, both presenting complications, with the latter being optimal all things considered. The following should be reviewed:
  
  <Note 62290.1> Changing between 32-bit and 64-bit Word Sizes
  
  It is also an option to move to a new hardware machine during this process, but involves more steps, referring to the following:
  
  Oracle Application Server Administrator's Guide 10g Release 2 (10.1.2)
  Chapter 11 Staging a Test Environment from a Production Environment
  [ https://download.oracle.com/docs/cd/B14099_19/core.1012/b13995/prodtest.htm ]
• If interested in upgrading to Oracle Database Server 11g, the same basic steps are to be followed as outlined in this article, except there may be separate issues encountered. The upgrade to Oracle Database Server 11g has been tested by Oracle resulting in the following requirements to complement the Certification Guide:
  
  <Note 740417.1> Oracle Database 11g Release 1 (11.1) Certification for Oracle Application Server 10g (10.1.2, 10.1.3, 10.1.4)
  <Note 887365.1> Oracle Database 11g Release 2 (11.2) Certification for Oracle Application Server 10g (10.1.2, 10.1.3, 10.1.4)
• If performing this upgrade with a plan to upgrade to Oracle Fusion Middleware 11g, see the following documentation:
  
  Oracle Fusion Middleware Upgrade Planning Guide 11g Release 1 (11.1.1)
  6 Upgrading and Preparing Your Databases
  [ https://docs.oracle.com/cd/E23943_01/upgrade.1111/e10125/db_upgrade.htm ]

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.