Difference between revisions of "Clone E-Business Suite (EBS) database"

Revision as of 15:33, 21 April 2017

This will be a living document for a while as I change it with each successful clone I do!
Not all of these steps will be necessary in all cases. Some are specific to this particular installation.

Topology

src_ebs_host
    |
    !-> SRC_AD_DB
    !-> SRC_EBS_DB

src_apps_host
    |
    !-> SRC_APPS


tgt_ebs_host
    |
    !-> TGT_AD_DB
    !-> TGT_EBS_DB

tgt_apps_host
    |
    !-> TGT_APPS

Preparation

Assuming there is already a target (clone) that will be destroyed in the process.

Backup db tier database(s)

Check disk space for clone is sufficient

Export dba_directories

Export dba_db_links

Verify the db links still work on the target (may need pointing somewhere else afterwards)

Save user passwords

Modify file location spfile parameters

Save SQL baselines

Save SQL profiles

Save context file on apps tier

Create a pfile from spfile

Add source database to target tnsnames.ora

Preclone the source db tier

Preclone the source apps tier

Perform clone

Stop all apps tier process on target

Shutdown target database

Remove the target database files

Start copy of apps tier files in background

Duplicate the source database(s)

Restart target listener(s)

Post clone

Check datafile status

Restart database cleanly

Put back context file on apps tier

Register target database(s) with RMAN catalog

Stop target listener

link gcc

Check unzip version

Postclone the target db tier

Start target listener

Check spfile parameters

Clean up some directories on apps tier

Postclone the target apps tier

Change sysadmin password

Run Autoconfig on target database(s)

Check database is up

Restore dba_directories to target database(s)

Restore db links to target database(s)

Check utl_file_dir and APPLPTMP

Run Autoconfig on apps tier

Start apps tier services

Check Concurrent Manager status

Check Applications Dashboard

Execute Diagnostics tests

Run Concurrent Report "Activity Based Management (Obsolete)"

Change Site Name profile option value

Change Title header on portal login screen

Clear apps tier cache

Restart web server

Update other profile option values

Test concurrent program with known values to check consistency

Relink any .prog files to fndcpesr

Restore user passwords on target database(s)

Test db links

Set AWR parameters

Recreate nologging indexes

Fake stats on some tables