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 OCTOBER 09, 2018
Applies to:Oracle Fusion Middleware - Version 10.1.2.0.2 to 10.1.2.3.0 [Release AS10gR2]
Oracle Fusion Middleware - Version 10.1.4.0.1 to 10.1.4.3.0 [Release AS10gR2 to AS10gR3]
Information in this document applies to any platform.
- 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.
- 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
<Note 553517.1> Changing Word-Size Between 32-bit and 64-bit using DBUA
<Note 412271.1> ORA-600  and ORA-600 [KOKEIIX1] Reported While Upgrading Or Patching Databases To 10.2.0.3
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
[ http://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
[ http://docs.oracle.com/cd/E23943_01/upgrade.1111/e10125/db_upgrade.htm ]
- The intended audience is an Application Server Administrator, Oracle DBA, Oracle Support and any other individuals that are responsible for the upgrade task requiring reference to these steps and known issues.
- This will require some previous experience level in Oracle Database and Application Server Administration or Configuration.
- This article will not cover comprehensive details of a RDBMS upgrade. It gives a general overview of what steps are required, along with some examples. For more information on some aspects of Oracle Database 10g Upgrades and Administration, see the Oracle Database Server Release 2 (10.2) Documentation Library.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document