ORACLE E B S DATABASE CLONE steps

ORACLE E B S DATABASE CLONE steps

source system: prod target system： test 1、 Log on the source system as the ORACLE user. And run the following commands; Connect 10.0.31.227 User:root Passwd:root #su – oraprod $cd  /db/prod/db/tech_st/10.2.0/appsutil/scripts/PROD_erpdb $perl adpreclone.pl dbTier #该步骤的日志文件是 /db/prod/db/tech_st/10.2.0/appsutil/log/PROD_erpdb/StageDBTier_12190904.log 2、 copy the source system to the target system connect 10.0.31.221   shutdown the application normally   #su – applprod   $cd $ADMIN_SCRIPTS_HOME/   $adstpall.sh apps/apps   $exit #su – appltest   $cd $ADMIN_SCRIPTS_HOME/   $adstpall.sh apps/apps   $exit connect 10.0.31.227 SHUTDOWN the databaseserver normally #su – oraprod $cd $ORACLE_HOME/appsutil/scripts/PROD_erpdb/ $ addlnctl.sh stop PROD $addbctl.sh stop $exit #su – oradev $cd $ORACLE_HOME/appsutil/scripts/PROD_erpdb/ $ addlnctl.sh stop PROD $addbctl.sh stop $exit # cp –rp /db/prod/db/tech_st/10.2.0/appsutil/clone / /db/test/db/tech_st/10.2.0/appsutil/ #chown –R oratest:dba /db/test/db/tech_st/10.2.0/appsutil/clone # cp –rp /db/prod/db/apps_st/data/*  /db/test/db/apps_st/data/ # chown –R oratest:dba /db/test/db/apps_st/data/* start the source Application database system and application tier processes. 3、 configure the target system connect 10.0.31.227 log on the target system as the ORACLE user and run the following commands. #su – oratest $cd /db/test/db/tech_st/10.2.0/appsutil/clone/bin $perl adcfgclone.pl dbTier 运行以上脚本时需要回答以下问题： #查看 /etc/hosts文件，如果有虚拟主机就用虚拟主机，否则用实主机 Target hostname (virtual or normal) [erpsv2]:erpdb   Target instance is a Real Application Cluster (RAC) instance (y/n) [n]:n Target System database name:DEV #ORACLE 基目录名，因为系统中没有设置 ORACLE_BASE环境变量，所以只有自己记住该变量了 /db/SID Target system base directory for source homes:/db/dev   #utl_file文件的存放目录，可以随便指向一个可用的目录，一般在 ORACLE基目录下面增开一个临时目录 Target system utl_file accessible directories list:/db/dev/tmp #ORACLE数据文件存放的目录数目，有几个就输入几，我们公司的数据文件目录只有一个 Number of DATA_TOP's on the target system [4]:1 #ORACLE数据文件存放的目标目录 Target system DATA_TOP 1:/db/dev/db/apps_st/data #ORACLE_HOME环境变量的值，即 ORACLE的主目录 Target system RDBMS ORACLE_HOME directory:/db/dev/db/tech_st/10.2.0 #需要保存相关设置 Do you want to preserve the Display set to null (y/n) [y] ?:y Clone Context uses the same port pool mechanism as the Rapid Install. #目标数据库的基准端口号，公司的产品环境是 0，测试环境是 1，开发环境是 2 Enter the port pool to be used for the target system node [0-99]: 2 到此，脚本可以顺利运行，只需要等待脚本运行完毕就好了。 #运行完上面的脚本后，应检查数据是否可以让普通用户注册，最好在 PL/SQL DEVELOPER里面用 APPS帐号注册一次，如果成功就行，如果失败应该查找原因，比如监听器没有启动等。 该脚本运行的日志文件一般是 /db/dev/db/tech_st/10.2.0/appsutil/log/DEV_erpdb/ApplyDBTier_12200032.log /db/dev/db/tech_st/10.2.0/appsutil/clone/bin/CloneContext_12200029.log /db/dev/db/tech_st/10.2.0/appsutil/log/DEV_erpdb/addlnctl.txt connect 10.0.31.221 #此时应用是关闭的，数据库是启动状态 log on the target system as the APPLMGR user and run the following commands.   #su – appltest  #记住查看 /app/test/apps/apps_st/appl/admin/adconfig.txt的所有者，一定要确保该文件的所有者是正在使用的帐号，如果不是应该更改成正在使用的帐号   $cd  $ADMIN_SCRIPTS_HOME/   $adautocfg.sh [apps password]:apps Using Context file          : /app/dev/inst/apps/DEV_erpapp/appl/admin/DEV_erpapp.xml 日志文件是/app/dev/inst/apps/DEV_erpapp/admin/log/12200850/adconfig.log 一切都成功执行后，就可以启动应用了。 Update Workflow configuration settings Cloning an Oracle Applications instance will not update the host and instance specific information used by Oracle Workflow. Review the following tables and columns to verify there is no instance specific data in the Workflow configuration on the target system. Update WF_NOTIFICATION_ATTRIBUTES Set TEXT_VALUE = replace(TEXT_VALUE,’ http://<old web host>’,’ http://<new web host>’) Where TEXT_VALUE like ‘% http://<old web host>%’ Table Name Column Name Column Value DetailsWF_NOTIFICATION_ATTRIBUTES TEXT_VALUE Value starts with http://<old web host> : Update to new web host WF_ITEM_ATTRIBUTE_VALUES TEXT_VALUE Value starts with "http://<old web host> : Update to new web host WF_SYSTEMS GUID Create a new system defined as the new global database name using the Workflow Administrator Web Applications responsibility. WF_SYSTEMS NAME Value needs to be replaced with the database global name WF_AGENTS ADDRESS Update database link with the new database global name. FND_FORM_FUNCTIONS WEB_HOST_NAME Update with the new web host name FND_FORM_FUNCTIONS WEB_AGENT_NAME Update to point at the new PLSQL listener name FND_CONCURRENT_REQUESTS LOGFILE_NAME Update with the correct path to the logfile directory FND_CONCURRENT_REQUESTS OUTFILE_NAME Update with the new directory path on the target system 修改完以上表的字段后，还要进入 ERP的管理员职责下面的 profile>system里面修改“地点名称”字段，把相关的 SID修改成目标 SID。如果虚拟节点没有注册成功，此时应到“系统管理员职责”：控制面板 -》 sitemap->hosts下面注册该节点。画面信息如下