《Oracle Applications DBA 基础》- 6 cloning

《 Oracle Applications DBA 基础》- 6 cloning
===============

参考资料：

1. Oracle Applications Concepts
http://download.oracle.com/docs/ ... acrobat/120oacg.pdf

2. Metalink notes
<406982.1>: Cloning Oracle Applications Release 12 with Rapid Clone
<603104.1>: Troubleshooting RapidClone issues with Oracle Applications R12

3.《Oracle EBS R12: Install, Patch and Maintain Applications 》之
cloning and Advanced cloning options

Oracle Applications 采用Rapid Clone 的方法来clone system，其功能在于前面所说
的 AUTOCONFIG 功能， 所以 Rapid Clone 的方法 就变得很简单， 基本就是 file copy
然后运行 AUTOCONFIG。

具体例子如下：


Section 1: 准备工作：
----------------------------
1. Verify OS requirements on target system
2. Verify source and target system software components and versions
3. Apply the latest AD patch (R12.AD.A.DELTA.4) or higher
4. Apply the latest AutoConfig template patch
5. Apply the latest Rapid Clone patches

R12.0: for 12.0.2 or higher, 6145693 superceded by 7164226
R12.1 : no rapidclone patch

6. Run AutoConfig on the application tiers
( 387859.1 Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12)
7. Synchronize appsutil on the database tier nodes
8. Run AutoConfig on the database tier

9. Maintain snapshot information
  Maintain Applications Files => Maintain snapshot information => Update current view snapshot
=> Update Complete APPL_TOP

Section 2: Cloning 任务
-------------------------
1. Prepare the source system
----------------------------
cd $ ORACLE _HOME/appsutil/scripts/PROD_mis/
perl adpreclone.pl dbTier

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


2. Copy the source system to the target system
-----------------------------------------------
cp -RH

a. Copy the application tier file system
# <APPL_TOP>
# <COMMON_TOP>
# Applications Technology Stack:

    * <OracleAS Tools ORACLE_HOME>
    * <OracleAS Web IAS_ORACLE_HOME>

b. Copy the database node file system


3. Configure the target system
------------------------------------
a.  Configure the target system database server

cd $ORACLE_HOME/appsutil/clone/bin
[oravis@mis1 bin]$ perl adcfgclone.pl dbTier

[oravis@mis1 bin]$ perl adcfgclone.pl dbTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.20.12000000.11

Enter the APPS password :

Running:
/u03/db/tech_st/10.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /u03/db/tech_st/10.2.0/appsutil/clone/jlib/java:/u03/db/tech_st/10.2.0/appsutil/clone/jlib/xmlparserv2.jar:/u03/db/tech_st/10.2.0/appsutil/clone/jlib/ojdbc14.jar oracle .apps.ad.context.CloneContext -e /u03/db/tech_st/10.2.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_4838.lst -stage /u03/db/tech_st/10.2.0/appsutil/clone  2> /tmp/adcfgclone_4838.err; echo $? > /tmp/adcfgclone_4838.res

Log file located at /u03/db/tech_st/10.2.0/appsutil/clone/bin/CloneContext_09091603.log

Provide the values required for creation of the new Database Context file.

Target System Hostname (virtual or normal) [mis1] :

Target Instance is RAC (y/n) [n] :

Target System Database SID : PROD

Target System Base Directory : /u03

Target System utl_file_dir Directory List : /usr/tmp

Number of DATA_TOP's on the Target System [1] :

Target System DATA_TOP Directory 1 [/u04/db/apps_st/data] :

Target System RDBMS ORACLE_HOME Directory [/u03/db/tech_st/10.2.0] :

Do you want to preserve the Display [null] (y/n) ? :

Target System Display [mis1:0.0] :

Do you want the the target system to have the same port values as the source system (y/n) [y] ? :

###############

b. Configure the target system application tier server nodes

$ cd $COMMON_TOP/clone/bin

[applvis@mis1 bin]$ pwd
/u01/apps/apps_st/comn/clone/bin
[applvis@mis1 bin]$ perl adcfgclone.pl appsTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.20.12000000.11

Enter the APPS password :

Running:
/u01/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/apps/apps_st/comn/clone/jlib/java:/u01/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u01/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /u01/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_5161.lst -stage /u01/apps/apps_st/comn/clone  2> /tmp/adcfgclone_5161.err; echo $? > /tmp/adcfgclone_5161.res

Log file located at /u01/apps/apps_st/comn/clone/bin/CloneContext_09092107.log

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [mis1] :

Target System Database SID : PROD

Target System Database Server Node [mis1] :

Target System Base Directory : /u01

Target System Tools ORACLE_HOME Directory [/u01/apps/tech_st/10.1.2] :

Target System Web ORACLE_HOME Directory [/u01/apps/tech_st/10.1.3] :

Target System APPL_TOP Directory [/u01/apps/apps_st/appl] :

Target System COMMON_TOP Directory [/u01/apps/apps_st/comn] :

Target System Instance Home Directory [/u01/inst] : /u02/inst

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] :

Do you want to preserve the Display [mis:0.0] (y/n) ? :n

...

Note:
Rapid Clone fails with RC-50004 error Rasing NoSuchMethodError java exception

check logfile found DB listener not started up.


Section 3: Finishing 任务
---------------------------

因为有些东西，rapidclone 没有改， 所以 rapidclone 后，还要有些更改要自己做。

1. Update profile options
Rapid Clone updates only site level profile options.

2. Update printer settings   

3. Update Workflow and other configuration settings

相关的表及column 列示如下：
wf_notification_attributes         => text_value
wf_item_attribute_values         => text_value
wf_systems                        => GUID, NAME，
wf_agents                         => address
fnd_form_functions                => web_host_name,web_agent_name
fnd_concurrent_reqeusts                => logfile_name,
fnd_concurrent_queues                => target_node
fnd_concurrent_queues_vl         => user_concurrent_queue_name
icx_parameters                         => session_cookie_domain, session_cookie_name
$APPLCSF
$COMMON_TOP/_pages/*
select fnd_web_config.database_id from dual;
select fnd_session_management.getsessioncookiename from dual;

select pov.profile_option_id, po.profile_option_name, ptl.user_profile_option_name, pov.profile_option_value
from fnd_profile_options po, fnd_profile_option_values pov, fnd_profile_options_tl ptl
where ptl.profile_option_name=po.profile_option_name and po.profile_option_id
= pov.profile_option_id and po.profile_option_name in ('APPS_SSO_LISTENER_TOKEN','APPS_DATABASE_ID');


select pov.profile_option_id, po.profile_option_name, ptl.user_profile_option_name, pov.profile_option_value
from fnd_profile_options po, fnd_profile_option_values pov, fnd_profile_options_tl ptl
where ptl.profile_option_name=po.profile_option_name and po.profile_option_id
= pov.profile_option_id and po.profile_option_name in ('ECX_UTL_XSLT_DIR','ECX_UTL_LOG_DIR');

select profile_option_value ,profile_option_id
from fnd_profile_option_values
where profile_option_id =
(select profile_option_id from fnd_profile_options where profile_option_name='SITENAME');

相关的metalink 11i doco 有：
<146705.1> SQL Display Apps Profile Options (Rel 11i) from SQL*Plus
<190158.1> How to Find Profiles with Certain Values or Names


Section 4: Advanced cloning options
----------------------------------

#### END ####