This is a brief step by step guide on Oracle Applications R12.1.1 Rapid cloning for the first time after upgrade.
The document you should follow is Cloning Oracle Applications Release 12
with Rapid Clone [ID 406982.1].
with Rapid Clone [ID 406982.1].
A. For R12.1.1 download and apply patch 9239089 [R12.AD.B.DELTA.3]. It is a must.
[Don't forget the following steps as a prerequisites of applying patch 9239089.
Instructions for running AD Grants
Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.
Usage:
1. Create $ORACLE_HOME/appsutil/admin on the database server.
2. Copy adgrants.sql (UNIX) from this patch directory to
$ORACLE_HOME/appsutil/admin.
3. Set the environment to point to ORACLE_HOME on the database server.
4. Use SQL*Plus to run the script:
UNIX:
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql <APPS schema name>
]
B. Apply patch 8919489 by following 3.1 section [Apply the TXK AutoConfig Template patch] of doc 387859.1. The above patch will take some time to complete. This patch basically compiles all the database objects so takes some time. To run this patch fast you can set db initialization parameter _disable_fast_validate=TRUE.
- Apply following two patches in R12.1 environment.
9171651:R12.OAM.B 12.1 RAPIDCLONE CONSOLIDATED FIXES JUL/2010
9833058:R12.OAM.B HOT CLONE FAILS WITH ORA-00201 DURING RECOVERY MANAGER
D. Run AutoConfig on the application tiers.
E. Synchronize appsutil on the database tier nodes.
F. Run AutoConfig on the database tier.
G. Maintain snapshot information.
H. Prepare source database and application tier for cloning as you have previously done for 12.0 system.
$ cd [RDBMS ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]
$ perl adpreclone.pl dbTier
$ cd [INST_TOP]/admin/scripts
$ perl adpreclone.pl appsTier
I. Copy the source db and apps directory to target system using cp -RH command. Don't forget to use -RH options during copying. During copying shutdown the apps tier and db tier of the source system.
J. The final step is configuring the target system. The step is similar to R12.0 cloning.
Database tier configuration using adcfgclone.
$ cd [RDBMS ORACLE_HOME]/appsutil/clone/bin
$ perl adcfgclone.pl dbTier Apps Tier Configuration$ cd [COMMON_TOP]/clone/bin
$ perl adcfgclone.pl appsTier
If you follow the above steps and apply all the patches you should not meet any issues. Still see the following link for some R12.1.x cloning issues.
1 comment :
I look forward in reading more of your work.
www.n8fan.net
Post a Comment