Staging/Cloning 10g AS Prod to Test

This is second post w.r.t. cloning Oracle 10g Application Server. For first post on overview of 10g Application Server Middle Tier cloning visit

This post covers basic understanding of staging (cloning) 10g Application Server both infrastructure and middle tier.

Assumptions with this cloning
1. You have 10g Application Server Middle Tier (Portal or BI type) and Infrastructure tier (OID, SSO, MR)
2. You have source instance (PROD) which you wish to clone to target instance (DEV/Test)

Broad Level Steps

A. Export Data from source Instance
1. Install Target Instance (Dev/Test) Infrastructure tier (Try to keep same OID realm as source instance prod)
2. Export User data from source OID Instance (using ldifwrite)
3. Export Group data from source OID Instance (using ldifwrite)
4. Export DAS data from source OID Instance (using ldifwrite )
5. Copy password file from source OID using ldap search command (Do this step if you want to retain similar password policy on target instance as source)
6. Export portal, portal_app, portal_public, discoverer5 and various other custom schemas from source instance
7. Export SSO data using ssomig utility from source instance
8. Export EUL (End User Layer) discoverer data from source using eulapi

B. Install Target Instance
1. Install Infrastructure tier (Keep OID realm similar to source instance)
2. Install Middle Tier

C. Clean/Clear/Delete Target Instance Data
1. Delete Users/Groups from target Instance using (OID script)
2. Drop portal, portal_public, discoverer5 and various other schemas

D. Load data from source to target Instance
1. Load User/Groups from source to target using (OID script)
2. Import SSO data using ssomig utility with option -import
3. Create portal & portal_public user using script wdbisys.sql & cruser.sql resp.
4. Create discoverer5, portal_app and various other custom schema
5. Import portal and other schema data using database IMP
6. Create any custom OC4J and deploy application from source to target instance
7. Import EUL data using eulapi

For step by step procedure on creating replica / clone of 10g Application Server Production Instance to Test Instance

Click Here

Issue in Documentation
: Oracle Document mentioned above doesn’t cover discoverer5 schema import/export so if you hit any issues with discoverer import discoverer5 schema

Cloning E-Business Instance integrated with 10g AS Portal,Discoverer, OID and SSO coming soon …

Share This Post with Your Friends over Social Media!

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

Narasimharao says February 6, 2013

I need to Clone OID 10g server to Anther server.

is there any Clear steps need to fallow please help

Narasimharao says February 6, 2013

we have those services

-bash-3.2$ ./opmnctl status

Processes in Instance:
ias-component | process-type | pid | status
DSA | DSA | N/A | Down
LogLoader | logloaderd | N/A | Down
dcm-daemon | dcm-daemon | N/A | Down
OC4J | OC4J_SECURITY | 19303 | Alive
HTTP_Server | HTTP_Server | 19206 | Alive
OID | OID | 19220 | Alive

Brit Will says June 20, 2013

Narasimharao- Did you ever find cloning solution?



Add Your Reply