Saturday, 18 March 2017

clone at glance

Cloning Oracle Applications Release 12 with Rapid Clone [ID 406982.1]


Check all pre- requisits........

1. Apply Latest AD mini pack  (  run autoconfig in db tier as well as appsTier after every patching)
(
Create $ORACLE_HOME/appsutil/admin on the database tier.
 
  2. Copy adgrants.sql (UNIX) from this patch directory to $ORACLE_HOME/appsutil/admin. 
  3. Set the environment variable

  4. Use SQL*Plus to run the script:
 
     UNIX:
     $ sqlplus /nolog
     SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql <APPS schema name>)

then apply patch :-  adadmin -> change to maintenance mode



unzip patch as applmgr user and enter into the folder



give the command:-   adpatch apply=y


(Location of autocfg.sh in dbTier is   $ORACLE_HOME/appsutil/scripts/<Context_name>/
in appsTier $ADMIN_SCRIPTS_HOME)

2. Apply Latest Autoconfig Template patch( May take much time)
3. Apply all the latest patches for Rapid clone tool

4. then run as oracle user

$ cd [RDBMS ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]
$ perl adpreclone.pl dbTier

5.run as applmgr user

$ cd [INST_TOP]/admin/scripts
$ perl adpreclone.pl appsTier

6.Stop Database as well as application

7.copy apps,db,inst from source to target system (copy "db" as oracle user and other as applmgr user)  before copying create users oracle and applmgr in target system. configure the pre- requests in target system.

8. after copying  run as oracle user in target system in dbTier

$ cd [RDBMS ORACLE_HOME]/appsutil/clone/bin
$ perl adcfgclone.pl dbTier
9. run as applmgr user in target system  in appsTier

$ cd [COMMON_TOP]/clone/bin
$ perl adcfgclone.pl appsTier



(While running above commands, it will ask some paths and config  ... provide according to your target system settings)
After this check the lisner.ora and tnsnames.ora   and set manually if any modification needed.

(cd $TNS_ADMIN   here you can find these files.

cd $ORACLE_HOME/network/admin/<context_name>/   (here also you can find these files..))


Bounce entire system (both dbTier and appsTier).

Change profile, Concurrent manager setting , printer setting etc. in application front end if any custom setting is there.

No comments:

Post a Comment