ebs clone 原创

最新推荐文章于 2023-05-11 11:04:16 发布

cqgmau820668

最新推荐文章于 2023-05-11 11:04:16 发布

阅读量323

点赞数

一，前期准备
1。 APP 层autoconfig
[appldev@test4 appl]$ pwd
/ebs10/oracle/prod/apps/apps_st/appl
[appldev@test4 appl]$ . ./APPSTEST4_test4.env
[appldev@test4 appl]$ cd $ADMIN_SCRIPTS_HOME
[appldev@test4 scripts]$ sh adautocfg.sh
2。对appsutil进行同步化
[appldev@test4 scripts]$ perl $AD_TOP/bin/admkappsutil.pl
[appldev@test4 scripts]$ cd $INST_TOP/admin/out
[appldev@test4 out]$ cp appsutil.zip /home/appldev
3,复制appsutil.zip 文件到数据层
[appldev@test4 out]$ su - oradev
Password:
[oradev@test4 ~]$ ls
oradiag_oradev rman.cmd
[oradev@test4 ~]$ cd $ORACLE_HOME
[oradev@test4 11.1.0]$ . ./TEST4_test4.env
[oradev@test4 11.1.0]$ mv appsutil.zip appsutil.zip.org
[oradev@test4 11.1.0]$ cp /home/appldev/appsutil.zip $ORACLE_HOME
[oradev@test4 11.1.0]$ cd $ORACLE_HOME
[oradev@test4 11.1.0]$ unzip -o appsutil.zip
4,在数据层AutoConfig
[oradev@test4 11.1.0]$ cd /ebs10/oracle/prod/db/tech_st/11.1.0/appsutil/scripts/TEST4_test4/
[oradev@test4 TEST4_test4]$ sh adautocfg.sh
5,维护快照snapshot --appldev用户下
[oradev@test4 TEST4_test4]$ su appldev
Password:
启动adadmin工具

[appldev@test4 ~]$ cd /ebs10/oracle/prod/apps/apps_st/appl
[appldev@test4 appl]$ . ./APPSTEST4_test4.env
[appldev@test4 appl]$ adadmin 2-4-2-1然后退出adadmin

二，开始预clone

DB层adpreclone 切换到DB用户：
appldev@test4 appl]$ su - oradev
Password:
[oradev@test4 ~]$ cd $ORACLE_HOME

[oradev@test4 11.1.0]$ . ./TEST4_test4.env
[oradev@test4 11.1.0]$ cd /ebs10/oracle/prod/db/tech_st/11.1.0/appsutil/scripts/TEST4_test4/
[oradev@test4 TEST4_test4]$ perl adpreclone.pl dbTier
App层adpreclone：
切换到app用户
[oradev@test4 TEST4_test4]$ su - appldev
Password:
[appldev@test4 appl]$ cd /ebs10/oracle/prod/apps/apps_st/appl/
[appldev@test4 appl]$ . ./TEST4_test4.env
[appldev@test4 appl]$ cd $INST_TOP/admin/scripts
[appldev@test4 scripts]$ perl adpreclone.pl appsTier

三，停止app/db 并拷贝文件
1，停止app层
切换到app用户
[appldev@test4 scripts]$ cd $ADMIN_SCRIPTS_HOME
[appldev@test4 scripts]$ . ./adstpall.sh apps/appsapps
2，停止db层
切换到DB层用户

[appldev@test4 scripts]$ su - oradev
Password:
[oradev@test4 ~]$ cd $ORACLE_HOME
[oradev@test4 11.1.0]$ . ./TEST4_test4.env
[oradev@test4 11.1.0]$ cd appsutil
[oradev@test4 appsutil]$ cd scripts/TEST4_test4/
[oradev@test4 TEST4_test4]$ . ./addlnctl.sh stop TEST4
[oradev@test4 TEST4_test4]$ . ./addbctl.sh stop immediate
3，开始拷贝文件
[root@test4 apps] tar zcvf /ebs10/backup/1/apps2013.tar.gz ./apps
[root@test4 prod]# tar zcvf /ebs10/backup/1/db2013.tar.gz ./db/

四，开始克隆
1，数据库克隆步骤
$ cd /ebs10/oracle/prod/db/tech_st/11.1.0/appsutil/clone/bin
$ perl adcfgclone.pl dbTier
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LANG = "en_CN.UTF-8"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA
                        Oracle Applications Rapid Clone
                                 Version 12.0.0
                      adcfgclone Version 120.31.12010000.8
Enter the APPS password :
Running:
/ebs10/oracle/prod/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /ebs10/oracle/prod/db/tech_st/11.1.0/appsutil/clone/jlib/java:/ebs10/oracle/prod/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/ebs10/oracle/prod/db/tech_st/11.1.0/appsutil/clone/jlib/ojdbc5.jar oracle.apps.ad.context.CloneContext -e /ebs10/oracle/prod/db/tech_st/11.1.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_7360.lst -stage /ebs10/oracle/prod/db/tech_st/11.1.0/appsutil/clone 2> /tmp/adcfgclone_7360.err; echo $? > /tmp/adcfgclone_7360.res
Log file located at /ebs10/oracle/prod/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0506171012.log
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [dev] : dev
Target Instance is RAC (y/n) [n] : n
Target System Database SID : dev
Target System Base Directory : /ebs10/oracle/prod/
Target System utl_file_dir Directory List : /tmp
Number of DATA_TOP's on the Target System [2] : 1
Target System DATA_TOP Directory 1 : /ebs10/oracle/prod/db/apps_st/data
Target System RDBMS ORACLE_HOME Directory [/ebs10/oracle/prod/db/tech_st/11.1.0] :
Do you want to preserve the Display [test4:0.0] (y/n) : n
Target System Display [dev:0.0] :
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 1
报错如下：
\     50% completed       RC-50004: Fatal: Error occurred in ApplyDatabase:
Control file creation failed

ERROR while running Apply...
Sat May 11 10:57:12 2013

ERROR: Failed to execute /ebs10/oracle/prod/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl n/adclone.pl

日志：
-------------------ADX Database Utility Finished---------------

RC-00118: Error occurred during creation of database
Raised by oracle.apps.ad.clone.ApplyDatabase

解决方法：
经过检查数据库已经启动，报错的原因是监听和tns文件没有修改。
修改 lister.ora 把源的名称修改目标sid名称
修改 tns文件
修改环境变量 .bash_profile 添加以下内容
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH
export PATH

. /ebs10/oracle/prod/db/tech_st/11.1.0/dev_dev.env
执行 source ~/.bash_profile 使得生效
然后启动监听就OK了

2，应用层克隆
[appldev@dev prod]$ su - appldev
Password:
[appldev@dev ~]$ cd /ebs20/oracle//prod/apps/apps_st/comn/clone/bin/
[appldev@dev bin]$ perl adcfgclone.pl appsTier
Provide the values required for creation of the new APPL_TOP Context file.

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

Target System Database SID : dev

Target System Database Server Node [dev] :

Target System Database Domain Name [bitland.com.cn] :
Target System Base Directory : /ebs20/oracle/prod/

Target System Tools ORACLE_HOME Directory [/ebs20/oracle/prod/apps/tech_st/10.1.2] :

Target System Web ORACLE_HOME Directory [/ebs20/oracle/prod/apps/tech_st/10.1.3] :

Target System APPL_TOP Directory [/ebs20/oracle/prod/apps/apps_st/appl] :

Target System COMMON_TOP Directory [/ebs20/oracle/prod/apps/apps_st/comn] :

Target System Instance Home Directory [/ebs20/oracle/prod/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 [enabled] : disabled
Do you want to preserve the Display [test4:0.0] (y/n) : n

Target System Display [dev:0.0] :

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

Target System Port Pool [0-99] : 1

/ebs20/oracle/prod/inst/apps/dev_dev/admin/log/ApplyAppsTier_05111331.log
\ 90% completed

ERROR while running Apply...
Sat May 11 13:38:19 2013

ERROR: Failed to execute /ebs20/oracle/prod/apps/apps_st/comn/clone/bin/adclone.pl
日志
RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyApplTop
ERROR: AutoConfig completed with errors. Check logfile at /ebs20/oracle/prod/inst/apps/dev_dev/admin/log/ApplyAppsTier_05111331.log for details.
[appldev@dev ~]$ vi startapp.sh
/ebs10/oracle/prod/inst/apps/dev_dev/admin/scripts/adstrtal.sh apps/appsapps
[appldev@dev ~]$ cat stopapp.sh
/ebs20/oracle/prod/inst/apps/dev_dev/admin/scripts/adstpall.sh apps/appsapps

一步一步打开检查错误
[appldev@dev scripts]$ cd /ebs20/oracle/prod/inst/apps/dev_dev/ora/10.1.2/network k/admin/
[appldev@dev admin]$ ls
tnsnames.ora
[appldev@dev admin]$ vi listener.ora
[appldev@dev admin]$ adalnctl.sh start APPS_DEV
adalnctl.sh version 120.3

grep: /ebs20/oracle/prod/inst/apps/dev_dev/ora/10.1.2/network/admin/listener.ora : No such file or directory
Checking for FNDFS executable.
Starting listener process APPS_dev.

adalnctl.sh: exiting with status 1

adalnctl.sh: check the logfile /ebs20/oracle/prod/inst/apps/dev_dev/logs/appl/ad min/log/adalnctl.txt for more information ...
发现没有监听文件
[appldev@dev scripts]$ cd /ebs20/oracle/prod/inst/apps/dev_dev/ora/10.1.2/network/admin/
[appldev@dev admin]$ ls
tnsnames.ora
[appldev@dev admin]$ vi listener.ora
把源的监听文件拷贝过来进行修改

[appldev@dev scripts]$ adapcctl.sh start
查看日志和状态
[appldev@dev scripts]$ adapcctl.sh status

You are running adapcctl.sh version 120.7.12010000.2

Checking status of OPMN managed Oracle HTTP Server (OHS) instance ...

以上错误是因为没有拷贝INST，重新拷贝，再重新克隆应用。
同步文件没有拷贝inst 文件

rsync -aPv appldev@192.168.1.184: /ebs10/oracle/prod/inst/ /ebs20/oracle/prod/inst/

重新检查
[appldev@dev bin]$ cd /ebs20/oracle/prod/inst/apps/dev_dev/admin/scripts
[appldev@dev scripts]$ adapcctl.sh status

You are running adapcctl.sh version 120.7.12010000.2

Checking status of OPMN managed Oracle HTTP Server (OHS) instance ...

检查APPLCSF环境
[appldev@dev appl]$ pwd
/ebs20/oracle/prod/apps/apps_st/appl
[appldev@dev appl]$ . ./APPSdev_dev.env
[appldev@dev appl]$ env|grep APPLCSF
APPLCSF=/ebs20/oracle/prod/inst/apps/dev_dev/logs/appl/conc
更新 ICS_PARAMETER (目前做)
select a.session_cookie_domain from apps.icx_parameters a
update apps.icx_parameters a set a.session_cookie_domain='ds.com.cn

并发管理检查
提示 FRM-92050：连接服务器失败
FRM-92050:Failed to connect to the Server xxx.domain 9001
出现这个错误的主要要因是f60webmx服务没起来.
#grep –ef|grep f60
如果没发现f60wbmx，可按下列方法解决
1.$ ldd f60webmx | grep 'not found'
libXm.so.2.1 => not found
2. Shutdown all Oracle services (at least the forms services)
3. Login as root:
# cd /usr/X11R6/lib
# ln -s libXm.so libXm.so.2.1

FRM-92050:连接服务器失败：dev.com.cn:9002
at jave.net.PlainSocketconnect(Native Method)
at oracle.forms.engin.......(unknown source)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15187685/viewspace-760972/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15187685/viewspace-760972/

cqgmau820668

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
ebs clone 原创

一，前期准备1。 APP 层autoconfig[appldev@test4 appl]$ pwd/ebs10/oracle/prod/apps/apps_st/appl[appldev@test4 appl]$ . ./APP...
复制链接

扫一扫