Oracle EBS Clone 操作步骤.doc

该文档为ITPUB朋友Michaelbeyond提供，谨此致谢！适用操作系统：AIX4.3 IBM RS/6000服务器2003-11-12Source环境要开启来，Targer环境要关闭预先准备工作Reference from Cloning Oracle APPS R11i with Rapid Clone.March 2003Pre-Request Task:Perl 5.005, JRE 1.3.1JDK 1.3.1Zip 2.3 put in /usr/bin done at 16/MAY/2003/u01/prod/prodora/iAS/Apache/perl前期准备工作可参考Metalink文档230672.1 216664.1 165195.11、准备好target环境，如果没有则需要安装一个全新的环境，和source环境要一摸一样本次clone的source环境为prod，位于/u01/prod；target环境为ptst，位于/u02/ptst2、打上Rapid Clone Patch 2870461 (This patch may Replace by 3130740)克隆前的source方面的准备工作准备appsutil文件1、Login source system as applmgr at APPL_TOP2、用perl执行如下脚本创建 appsutil.zip file perl $AD_TOP/bin/admkappsutil.pl以下星号包括起来的是输出信息：*(prodmgrchmod 744 admkappsutil.plprodmgradmkappsutil.plStarting the generation of appsutil.zipLog file located at /u01/prod/prodappl/admin/log/MakeAppsUtil_11101216.logoutput located at /u01/prod/prodappl/admin/out/appsutil.zipprodmgrpwd/u01/prod/prodappl/ad/11.5.0/bin)*可以看到日志文件和输出的appsutil.zip文件存放的位子将上述appsutil.zip拷贝到ORACLE_HOME目录下cp /u01/prod/prodappl/admin/out/appsutil.zip $ORACLE_HOME3、将ORACLE_HOME原有的appsutil目录备份起来cp appsutil appsutil_heh4、在ORACLE_HOME目录下解压appsutil.zip文件，覆盖原有的appsutil。因为有可能有新增加的内容，所以上述步骤使用的是cp而不是mv解压命令为：unzip -o appsutil.zipImplement AutoConfig步骤1、以oramgr帐号登陆到数据库层在$ORACLE_HOME/appsutil目录下创建clone目录进入到$ORACLE_HOME/appsutil/bin目录下运行如下命令，生成用于配置source的xml文件：adbldxml.sh tier=db appsuser= appspasswd= 执行上述命令后应该出现如下用星号括起来的信息：*Using JVM from /u01/prod/jre/1.1.8/bin/jre to execute java programs .Context File /u01/prod/proddb/8.1.7/appsutil/PROD.xmlalready exists.Overwriting Context File may cause loss of existing settings, hencebacking it up as :/u01/prod/proddb/8.1.7/appsutil/PROD.xml.bakQuerying database for retrieving Context information. This process takes a few minutes to complete.Done Querying database.Context file created at location :/u01/prod/proddb/8.1.7/appsutil/PROD.xmlFor details check log file :/u01/prod/proddb/8.1.7/appsutil/log/PROD/11101246.log*修改生成的PROD.xml(位于/u01/prod/proddb/8.1.7/appsutil/PROD.xml)主要是找到括起的内容并修改为/usr/j2se如果其他有关/u01/prod的路径不正确，同样进行修改2、以applmgr帐号登陆到应用层 在$COMN_TOP目录下创建clone目录进入到$ORACLE_HOME/appsutil/bin目录下运行如下命令，生成用于配置source的xml文件：adbldxml.sh tier=apps appsuser= appspasswd=准备source系统1) 以oramgr帐号登陆到ORACLE_HOME数据库层如果文件$ORACLE_HOME/appsutil/scripts/adpreclone.pl不存在，可以用以下命令创建： adconfig.sh contextfile=.xml appspass=注：这个命令请慎用，原来的配置将不用用。使用编辑器打开adpreclone.pl文件，找到# Tier = Database的字段，修改dbTier层的设置内容，将其下对应的内容修改成如下所示：# Tier = Database#else $DB_ENVFILE = /u01/prod/proddb/8.1.7/PROD.env; $ADCLONE = /u01/prod/proddb/8.1.7/appsutil/adclone.pl; $CTX_FILE = /u01/prod/proddb/8.1.7/appsutil/PROD.xml; $CTX_ARG = dbctx=$CTX_FILE; $STAGE_DIR = /u01/prod/proddb/8.1.7/appsutil/clone; $JAVA_TOP = /u01/prod/jre/1.1.8; 2）以applmgr帐号登陆到ORACLE_HOME应用系统层如果文件$COMN_TOP/admin/scripts/adpreclone.pl不存在，可以用以下命令创建：adconfig.sh contextfile=.xml appspass=注：这个命令请慎用，原来的配置将不用用。使用编辑器打开adpreclone.pl文件，找到if ($TIER = /APPL_TOP/) 的字段，修改appsTier层的设置内容，将其下对应的内容修改成如下所示： $APP_ENVFILE = /u01/prod/prodappl/PROD.env; $DB_ENVFILE = /u01/prod/prodora/8.0.6/PROD.env; $ADCLONE = /u01/prod/prodappl/ad/11.5.0/bin/adclone.pl; $CTX_FILE = /u01/prod/prodappl/admin/PROD.xml; $CTX_ARG = appctx=$CTX_FILE; $STAGE_DIR = /u01/prod/prodcomn/clone; $JAVA_TOP = /u01/prod/prodcomn/util/jre/1.1.8;注：这里的adpreclone.pl位置与原文不同，我的系统是AIX4.3。其它的位置也请对应修改source下的DB Tier层的pre-clone1、以oramgr帐号登陆到ORACLE_HOME2、进入$ORACLE_HOME/appsutil/scripts/目录下执行adpreclone.pl脚本进入$ORACLE_HOME/appsutil/scripts/目录的命令为：cd $ORACLE_HOME/appsutil/ scripts/执行adpreclone.pl的命令为：perl adpreclone.pl dbTier此处的dbTier参数必须要写，告诉脚本是在做DB Tier层的pre-clone以下星号包括起来的是输出信息：*Using Archive: /u01/prod/proddb/8.1.7/appsutil/java/adconfig.zip$Header: adconfig.zip 115.260 2003/03/14 18:35:11 pkm ship $Beginning database tier Stage - Mon Nov 10 00:53:29 2003APPS Password : appsLog file located at /u01/prod/proddb/8.1.7/appsutil/log/PROD/StageDBTier_11101253.logPlease check /u01/prod/proddb/8.1.7/appsutil/out/PROD/dblayout.txt when copying the dbf files in a .Completed Stage.Mon Nov 10 00:55:41 2003*source下的AP Tier层的pre-clone1、以applmgr帐号登陆到APPL_TOP2、进入$COMN_TOP/admin/scripts/目录下执行adpreclone.pl脚本进入$COMN_TOP/admin/scripts/目录的命令为：cd $COMN_TOP/admin/scripts/执行adpreclone.pl的命令为：perl adpreclone.pl appsTier此处的appsTier参数必须要写，告诉脚本是在做AP Tier层的pre-clone以下星号包括起来的是输出信息：*Running Rapid Clone.perl /u01/prod/prodappl/ad/11.5.0/bin/adclone.pl java=/u01/prod/prodcomn/util/jre/1.1.8 mode=stageUsing Archive: /u01/prod/prodappl/ad/11.5.0/java/adconfig.zip$Header: adconfig.zip 115.260 2003/03/14 18:35:11 pkm ship $Beginning application tier Stage - Mon Nov 10 01:49:54 2003Log file located at /u01/prod/prodappl/admin/PROD/log/StageAppsTier_11100149.logCompleted Stage.Mon Nov 10 02:04:45 2003*拷贝AP Tier层的文件1、 关闭prod环境(source)的AP层服务2、拷贝prod环境(source)下的相应目录到ptst环境(target)下的相应目录APPL_TOP(prodappl)OA_HTML(prodcomn/html)OA_JAVA(prodcomn/java)COMN_TOP/util(prodcomn/util)COMN_TOP/clone(prodcomn/clon)806 ORACLE_HOME (ora)iAS ORACLE_HOME (ora)在做上述覆盖的过程前，先将target环境下对应的目录备份起来拷贝DB Tier层的文件1、 关闭prod环境(source)的DB层服务2、拷贝prod环境(source)中所有的dbf文件到ptst环境(target)下在做上述覆盖的过程前，先将target环境下对应的dbf文件备份起来3、拷贝prod环境(source)的ORACLE_HOME到ptst环境(target)的ORACLE_HOME下在做上述覆盖的过程前，先将target环境下的文件ORACLE_HOME备份起来上述拷贝动作完成后，启动source下的DB和AP服务【到此为止，所有的source上的动作已经完成，以下的动作都在targer上面】在target上进行克隆配置ptst环境(target)上DB Tier1、以oramgr帐号登陆到ORACLE_HOME2、进入$ORACLE_HOME/appsutil/clone/bin目录下执行adcfgclone.pl文件进入$ORACLE_HOME/appsutil/clone/bin目录的命令为：cd $ORACLE_HOME/appsutil/clone/bin执行adcfgclone.pl的命令为：perl adcfgclone.pl dbTier此处的dbTier参数必须要写，告诉脚本是在做DB Tier层的clone按照以下星号括起来的提示进行clone的配置：*oraptst perl adcfgclone.pl dbTierFirst Creating a new context file for the cloned system.The program is going to ask you for information about the new system:Enter the values for the new Database Context:Target system database SID PRODPTSTTarget system RDBMS ORACLE_HOME directory /u01/prod/proddb/8.1.7/u02/ptst/ptstdb/8.1.7Target system DATA_TOP (system dbfs) /u01/prod/proddata/u02/ptst/ptstdataTarget system DATA_TOP (log dbfs) /u01/prod/proddata/u02/ptst/ptstdataTarget system DATA_TOP (data dbfs) /u01/prod/proddata/u02/ptst/ptstdataTarget system DATA_TOP (index dbfs) /u01/prod/proddata/u02/ptst/ptstdata/u02/ptst/ptstdb/8.1.7/jre/1.1.8 directory not foundTarget system JRE_TOP /u01/prod/jre/1.1.8/u02/ptst/jre/1.1.8he new context file has to contain port numbers related to target system.Clone Context uses the same port pool mechanism as the Rapid InstallOnce you choose a port pool, Clone Context will validate the port availability.Enter the port pool number:0-992Checking the port pool 2done: Port Pool 2 is freeDatabase port is 1523Backing up /u02/ptst/ptstdb/8.1.7/appsutil/PTST.xml to /u02/ptst/ptstdb/8.1.7/appsutil/PTST.xml.bakCreating the new Database Context file from :/u01/prod/proddb/8.1.7/appsutil/template/adxdbctx.tmpThe following Database context file is created :/u02/ptst/ptstdb/8.1.7/appsutil/PTST.xmlPlease enter the APPS password:appsRunning Rapid Clone.perl adclone.pl java=/u02/ptst/jre/1.1.8 mode=apply stage=/u02/ptst/ptstdb/8.1.7/appsutil/clone comlUsing Archive: /u02/ptst/ptstdb/8.1.7/appsutil/clone/jlib/adconfig.zip$Header: adconfig.zip 115.260 2003/03/14 18:35:11 pkm ship $Beginning database tier Apply - Mon Nov 10 04:27:59 2003Log file located at /u02/ptst/ptstdb/8.1.7/appsutil/log/PTST/ApplyDBTier_11100427.log_ERROR_Beginning PTST_DB_HOME registration to central inventory.Log file located at /u02/ptst/oraInventory/logs/OracleHomeCloner_11120406.logException in thread main java.lang.NoClassDefFoundError: oracle/sysman/oii/oiic/OiicStandardInventorySession at oracle.apps.ad.clone.util.OracleHomeCloner.registerOracleHome(OracleHomeCloner.java:185) at oracle.apps.ad.clone.util.OracleHomeCloner.main(OracleHomeCloner.java:481) ERROR: Registration Failed. Please check log file.You can rerun the registration with the following command:/usr/j2se/bin/java -Xmx600M -classpath /usr/j2se/lib/classes.zip:/u02/ptst/ptstdb/8.1.7/appsutil/clone/jlib/adconfig.zip:/u02/ptst/ptstdb/8.1.7/appsutil/clone/jlib/appsoui/OraInstaller.jar:/u02/ptst/ptstdb/8.1.7/appsutil/clone/jlib/appsoui/ewt.jar:/u02/ptst/ptstdb/8.1.7/appsutil/clone/jlib/appsoui/xmlparserv2.jar oracle.apps.ad.clone.util.OracleHomeCloner -registerOUI -ohPath /u02/ptst/ptstdb/8.1.7 -ohName PTST_DB_HOME -oraInstLoc /var/opt/oracle/oraInst.loc_*配置ptst环境(target)上AP Tier1、以applmgr帐号登陆到APPL_HOME2、进入$COMN_TOP/clone/bin/目录下执行adcfgclone.pl文件进入$COMN_TOP/clone/bin/目录的命令为：cd $COMN_TOP/clone/bin/执行adcfgclone.pl的命令为：perl adcfgclone.pl appsTier此处的appsTier参数必须要写，告诉脚本是在做AP Tier层的clone按照以下星号括起来的提示进行clone的配置：*ptstmgrperl adcfgclone.pl appsTierFirst Creating a new context file for the cloned system.The program is going to ask you for information about the new system:Enter the values for the new APPL_TOP Context:Target system database SID PRODPTSTTarget system database server node hcc008hcc008Does the target system have more than one application tier server node (y/n) n ?nIs the target system APPL_TOP divided into multiple mount points (y/n) n ?nTarget system APPL_TOP mount point /u01/prod/prodappl/u02/ptst/ptstapplTarget system COMMON_TOP directory /u01/prod/prodcomn/u02/ptst/ptstcomnTarget system 8.0.6 ORACLE_HOME directory /u01/prod/prodora/8.0.6/u02/ptst/ptstora/8.0.6Target system iAS ORACLE_HOME directory /u01/prod/prodora/iAS/u02/ptst/ptstora/iASLocation of JDK 1.3.1 on the target system /usr/j2se/usr/j2seThe new context file has to contain port numbers related to target system.Clone Context uses the same port pool mechanism as the Rapid InstallOnce you choose a port pool, Clone Context will validate the port availability.Enter the port pool number:0-992Checking the port pool 2done: Port Pool 2 is freeWeb Listener port is 8002Complete port information available at /u02/ptst/ptstappl/admin/out/PTST/portpool.lstBacking up /u02/ptst/ptstappl/admin/PTST.xml to /u02/ptst/ptstappl/admin/PTST.xml.bakCreating the new APPL_TOP Context file from :/u01/prod/prodappl/ad/11.5.0/admin/template/adxmlctx.tmpThe following APPL_TOP context file is created :/u02/ptst/ptstappl/admin/PTST.xmlPlease enter the APPS password:appsRunning Rapid Clone.perl adclone.pl java=/u02/ptst/ptstcomn/util/jre/1.1.8 mode=apply stage=/u02/ptst/ptstcomn/clone colUsing Archive: /u02/ptst/ptstcomn/clone/jlib/adconfig.zip$Header: adconfig.zip 115.260 2003/03/14 18:35:11 pkm ship $Beginning application tier Apply - Mon Nov 10 04:53:44 2003Log file located at /u02/ptst/ptstappl/admin/PTST/log/ApplyAppsTier_11100453.log*结束任务修改Application的Profile Option(eg. system profile option)%SITE%, %AGENT%, %Web%, %ICX%, %TCF%, %Two Task%需要更新的表：icx_parameters，ad_appl_tops，fnd_product_groups，fnd_profile_option_values，WF_NOTIFICATION_ATTRIBUTES，WF_ITEM_ATTRIBUTE_VALUEStruncate table fnd_concurrent_requests可能存在无效对象，需要运行adadmin编译。一些要注意的问题：运行report出现error 修改PROD环境下的initPROD.ora参数文件，在其中找到utl_file_dir字段内容，修改其原有的路径建议为每个应用环境创建独立的tmp供PLSQL使用PROD环境： 在/usr下创建tmpprod目录/usr/tmpprod，其权限为777，其归属为prodmgr：dba 修改initPROD.ora中的utl_file_dir的值为/usr/tmpprod，/u01/prod/prodcomn/temp即：utl_file_dir=/usr/tmpprod，/u01/prod/prodcomn/temp修改PROD.env环境配置文件，在APPL的目录下找到APPLTMP修改成如下的形式：APPLTMP=/u01/prod/prodcomn/tempexport APPLTMP找到APPLPTMP修改成如下的形式：APPLPTMP=/usr/tmpprodexport APPLPTMP重新启动PROD环境即可TEST环境和PTST环境依此类推注意语言的问题需要修改1和3下的.env文件，在其中找到NLS字段，根据需要修改成UTF8常见错误： 1) 如果在运行svrmgrl有如下错误提示： exec(): 0509-036 Cannot load program oracle becau