My Oracle Support Banner

How To Change a Standalone Type OracleAS 10gR2 Middle Tier from one Database Based Metadata Repository To Another? (Doc ID 368419.1)

Last updated on AUGUST 16, 2023

Applies to:

Oracle Fusion Middleware - Version to [Release AS10gR2]
Information in this document applies to any platform.


The goal of this document is to a provide a step-by-step path to change a middle tier from one database-based repository to another

The procedure described below is only valid for the following install types

* Oracle Application Server 10gR2 Forms and Reports Services Standalone
* Oracle Application Server 10gR2 Business Intelligence and Discoverer Standalone
* Oracle Application Server 10gR2 J2EE and Web Cache Standalone

Note: These are all standalone middle tier install types which optionally can, post install, be registered to a Database Based DCM Repository.

Oracle Application Server Administrator's Guide 10g Release 2 (10.1.2)
Chapter 7 Reconfiguring Application Server Instances
7.5 Configuring J2EE and Web Cache to Use Infrastructure Services

The procedure cannot be applied to OracleAS middle tier types which are, by default, associated with an OracleAS 10g Rel 2 Infrastructure at install time e.g

* Oracle Application Server 10gR2 BI & Forms
* Oracle Application Server 10gR2 Portal & Wireless
* Oracle Application Server 10gR2 J2EE and Web Cache

Overall the bulletin is intended to complement the advice given in

Oracle Application Server Administrator's Guide 10g Release 2 (10.1.2)
Chapter 9 Changing Infrastructure Services
9.5 Changing the Metadata Repository Used by a Middle-Tier Instance

Finally note:

1. The article does not give advice about how to move or  migrate specific applications stored in the product repository, like Discoverer applications, to the new Farm.

2. You cannot associate an OracleAS middle tier instance with a Database-Based Farm that is based on an  earlier product version i.e You cannot associate a 9.0.4 middle tier with 10.1.2 Infrastructure.

Oracle Application Server Upgrade and Compatibility Guide 10g Release 2 (10.1.2) for UNIX
2.4.1 Running a 10.1.2 Metadata Repository with 9.0.2, 9.0.3, and 9.0.4 Middle Tiers

To quote:

You cannot run a 10g Release 2 (10.1.2) OracleAS Metadata Repository with previous versions of the Oracle Application Server middle tier. This is because the 10g (9.0.4) middle tiers are not compatible with the new 10g Release 2 (10.1.2) component schemas.


The article is intended for OracleAS administrators, consultants or support engineers who already have reasonable experience of working with OracleAS 10g Rel 2. Before working through the steps in this bulletin, the reader should already be familiar with the concepts of an OracleAS Farm, DCM / Metadata Repository and also know what is required to take full cold filesystem backups of OracleAS instances.


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
 The Example Topology / Architecture
 Section A: Remove OracleAS middle tier from the current OracleAS Infrastructure Farm
 Section B: Associate OracleAS middle tier with its 'new' OracleAS Infrastructure Farm

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