克隆步骤
- 格式：docx
- 大小：23.64 KB
- 文档页数：5
1.查找最新克隆文档Cloning Oracle Applications Release 12 with Rapid Clone [ID406982.1]2.根据第4步打补丁9171651,9833058,12404574a)关闭应用adstpall.sh apps/appsb)adadmin开启维护模式c)上传补丁文件到/tmpd)解压缩补丁文件e)更改补丁文件夹权限为777f)adpatch按顺序打补丁，注意每个补丁的事前和事后工作g)adadmin关闭维护模式h)删除/tmp下补丁文件和目录3.Applprod在$ADMIN_SCRIPTS_HOME下运行adautocfg.sh4.Applprod运行perl $AD_TOP/bin/admkappsutil.pl5.Oraprod将生成的appsutil.zip拷贝到$ORACLE_HOME下unzip -o appsutil.zipcd $ORACLE_HOME/appsutil/scripts/*adautocfg.sh==============================================================6.Applprod用户执行adadminMaintain Applications Files menu->Maintain snapshot information->Update current view snapshot->Update Complete APPL_TOP7.Oraprod用户执行cd $ORACLE_HOME/appsutil/scripts/*perl adpreclone.pl dbTier8.Applprod用户执行cd $ADMIN_SCRIPTS_HOMEperl adpreclone.pl appsTier9.Applprod用户执行cd $ADMIN_SCRIPTS_HOMEadstpall.sh apps/apps10.Oraprod使用sqlplus正常关闭监听和数据库11.Appltest用户执行cd $ADMIN_SCRIPTS_HOMEadstpall.sh apps/apps12.Oratest使用sqlplus正常关闭监听和数据库13.Applprod拷贝$COMMON_TOP,$APPL_TOP,$IAS_ORACLE_HOME,$ORACLE_HOME到目标服务器14.root拷贝.dbf和$ORACLE_HOME到目标服务器cd /opt/app/prodfin/db/tech_stscp -pr 11.1.0 root@vm-vmw733-t:/opt/app/testfin/db/tech_stcd /oracle/oradata_prodscp -pr *.dbf root@vm-vmw733-t:/oracle/oradata_test15.Oraprod启动数据库和监听16.Applprod启动应用17.测试服务器root用户chown -R oratest:dba /oracle/oradata_testchown -R oratest:dba /opt/app/testfin/db/tech_st/11.1.018.Oratest用户vi /opt/app/testfin/db/tech_st/11.1.0/.profile修改PROD和服务器主机名Oratest重新登录19.Appltest用户vi /opt/app/testfin/apps/apps_st/appl/.profile修改PROD和服务器主机名Appltest重新登录20.根据文档RapidClone fails at 70% after TXK.U (50% on R12) due to "s_db_listener"referencing source SID [ID 1153204.1]修改文件vi $ORACLE_HOME/appsutil/clone/context/db/CTXORIG.xml将s_db_listener从PROD替换成TEST否则会出错，参见$ORACLE_HOME/appsutil/log/<context>/ApplyDBTier_<timestamp>.log<TNSLSNR for Linux: Version 11.1.0.7.0 - ProductionSystem parameter file is/opt/app/testfin/db/tech_st/11.1.0/network/admin/TEST_vm-vmw733-t/listener.oraLog messages written to/opt/app/testfin/db/tech_st/11.1.0/log/diag/tnslsnr/vm-vmw733-t/test/alert/log.xml TNS-01151: Missing listener name, TEST, in LISTENER.ORAListener failed to start. See the error message(s) above...addlnctl.sh: exiting with status 1addlnctl.sh: check the logfile/opt/app/testfin/db/tech_st/11.1.0/appsutil/log/TEST_vm-vmw733-t/addlnctl.txt for more information ...><RC-00118: Error occurred during creation of databaseRaised by oracle.apps.ad.clone.ApplyDatabaseStackTrace:ng.Exception: Control file creation failedat oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:635)at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:473)at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:366)at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:110)at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)at ng.reflect.Constructor.newInstance(Unknown Source)at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)at ng.Thread.run(Unknown Source)>21.Oratest用户cd $ORACLE_HOME/appsutil/clone/binperl adcfgclone.pl dbTier22.Oratest用户关闭监听器和数据库将安装系统时变更后的initTEST.ora文件覆盖到initTEST.ora防止clone后生成的initTEST.ora，相关参数未被修改情况23.Oratest用户启动数据库和监听器24.Appltest用户cd $COMMON_TOP/clone/binperl adcfgclone.pl appsTier如果只是数据库克隆，需要执行应用的AUTOCONFIG更新数据库配置文件相关值从正式变为测试：cd $ADMIN_SCRIPTS_HOMEadautocfg.shadstrtal.sh apps/apps如果起来后发现并发管理器的输出提交处理程序没有起来，并且查询日志提示指向vm-vmw219，需要停止应用再次配置adautocfg再启动25.Sysadmin登录测试环境修改配置文件Java 色彩设计，设置为橄榄色地点名称，设置为测试环境ICX：会话超时，设置为180工作流相关表可以根据文档How to Change the System Name in Workflow? [ID 387337.1]，提供的脚本更新sh $INST_TOP/admin/install/txkWfClone.shUPDATE FND_CONCURRENT_REQUESTS TSET T.LOGFILE_NODE_NAME = 'VM-VMW733-T',T.LOGFILE_NAME = '/opt/app/testfin/inst/apps/TEST_vm-vmw733-t/' ||SUBSTR(T.LOGFILE_NAME,INSTR(T.LOGFILE_NAME, 'logs', 1, 1)),T.OUTFILE_NODE_NAME = 'VM-VMW733-T',T.OUTFILE_NAME = '/opt/app/testfin/inst/apps/TEST_vm-vmw733-t/' ||SUBSTR(T.OUTFILE_NAME,INSTR(T.OUTFILE_NAME, 'logs', 1, 1))WHERE T.LOGFILE_NAME IS NOT NULLOR T.OUTFILE_NAME IS NOT NULLperl ./adcfgclone.pl dbTier参数Target System Hostname (virtual or normal) [vm-vmw733-t] :Target Instance is RAC (y/n) [n] :Target System Database SID : TESTTarget System Base Directory : /opt/app/testfinTarget System utl_file_dir Directory List : /usr/tmpNumber of DATA_TOP's on the Target System [1] :Target System DATA_TOP Directory 1 [/oracle/oradata_prod] : /oracle/oradata_testTarget System RDBMS ORACLE_HOME Directory [/opt/app/testfin/db/tech_st/11.1.0] :Do you want to preserve the Display [null] (y/n) : nTarget System Display [vm-vmw733-t:0.0] :Do you want the the target system to have the same port values as the source system (y/n) [y] ? :。
