EBS: How to clone?

From:  http://www.itpub.net/thread-1409699-1-1.html

 

 

参考资料：

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

2. Metalink notes
<406982.1>: Cloning OracleApplications Release 12 with Rapid Clone
<603104.1>: TroubleshootingRapidClone 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 andversions
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 inOracle 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:

    * <OracleASTools ORACLE_HOME>
    * <OracleASWeb IAS_ORACLE_HOME>

b. Copy the database node file system


3. Configure the target system
------------------------------------
a.  Configure the target systemdatabase 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
                  RedwoodShores, California, USA

                  OracleApplications Rapid Clone

                        Version12.0.0

                 adcfgcloneVersion 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.jaroracle.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 DatabaseContext 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 asthe 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
                  RedwoodShores, California, USA

                  OracleApplications Rapid Clone

                        Version12.0.0

                 adcfgcloneVersion 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.jaroracle.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_TOPContext 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 javaexception

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 andpo.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 andpo.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 whereprofile_option_name='SITENAME');

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


Section 4: Advanced cloning options