ebs r12克隆数据库时 50%报错... / 50% completed RC-50004: Fatal: Error occurred in ApplyDatabase: ...
1.cd $ORACLE_HOME/appsutil/clone/context/db
2.cp CTXORIG.xml CTXORIG.xml.bak
3.vi CTXORIG.xml
找到<DB_LISTENER oa_var="s_db_listener">PROD</DB_LISTENER>行，将里面的PROD修改为target DB SID，保存。
4.关闭DB，KILL监听进程。
5.继续正常clone步骤：perl adcfgclone.pl dbTier
当遇到ORACLE出现下面提示时：
ora-01034:oracle not available
ora-27101:shared mermory realm does not exist
可以这样解决；
方法1：
1.输入：connect/as sysdba;
2.重起计算机就OK了；
方法2：
在命令行中输入
C:>svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 2000, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SVRMGR> connect internal/oracle
连接成功。
SVRMGR> startup
startup后再连接数据库应该没有问题了。
建议clone之前在源环境做一下per adpreclone.pl
在做完apps Tier和dbTier任何修改时，切记在apps Tier和dbTier分别执行adpreclone.pl，具体的操作如下：
++++++++++++++++++++++++++++++++++++++++++++++
$perl adpreclone.pl dbTier (注：dbTier)
./prodebs/db/tech_st/11.1.0/appsutil/scripts/PROD_erp/adpreclone.pl
++++++++++++++++++++++++++++++++++++++++++++
$perl adpreclone.pl appsTier (注：appsTier)
./prodebs/ap/inst/apps/PROD_erp/admin/scripts/adpreclone.pl
++++++++++++++++++++++++++++++++++++++++++++++
说明：(1)如果只做了dbTier的修改，在dbTier执行adpreclone.pl即可，同理apps Tier
(2) 增加数据文件时，切记在dbTier执行adpreclone.pl
从192.168.99.180的8088 CLONE 到 192.168.99.180的8070
CLONE后的计算机名：erp, 实例名：ERPTEST，端口号：8070
App用户名：appltest ; dba用户名： oratest
AP的目录： /U1/erptest/prodebs DB的目录：/U1/erptest/proddata
clone 文件来自20120320
======================================================
#mkdir /usr/tmp/ERPTEST //临时存放的文件，如果有就存在就没有必要新建，
#chmod –R 777 /usr/tmp/ERPTEST //最好和实例名一个样
cd /U1/erptest
chown –R oratest:dba proddata
cd prodebs
chown -R oratest:dba db
chown –R appltest:app ap
// chown –R oratest:dba db 把db所有者改为oratest并把组别改为dba.
touch /etc/oraInst.loc
echo "inventory_loc=/U1/erptest/prodebs/oraInventory " >> /etc/oraInst.loc
//mkdir -p /U1/erptest/prodebs /oraInventory
//chmod -R 777 /U1/erptest/prodebs /oraInventory
===================================================================================
Clone Database Tier
su – oratest
cd /U1/erptest/prodebs/db/tech_st/11.1.0/appsutil/clone/bin
perl adcfgclone.pl dbTier
Enter the APPS password:xmcowellitapps
Target System Hostname (virtual or normal) [erptest]:erptest
Target Instance is RAC(y/n)[n]:n
Target System Database SID:ERPTEST
Target System Base Directory:/U1/erptest/prodebs
Target System utl_file_dir Directory List:/usr/tmp/ERPTEST
Nouber of DATA_TOP's on the Target System [1]:1
Target System DATA_TOP Directory 1[/u2/proddata/apps_st/data]:/U1/erptest/proddata/apps_st/data
Target System RDBMS ORACLE_HOME Directory[U1/erptest/testebs/db/tech_st/11.1.0]: /U1/erptest/prodebs/db/tech_st/11.1.0
Do you want to preserve the Display [erp:1.0](y/n)?:N
Target System Display [erptest:0.0]:erptest:1.0
Do you want the target system to have the same port values as the source system(y/n)[y]:n
Target System Port Pool [0-99]:70
vi .bash_profile //clone完成再修改此项
. /U1/erptest/prodebs/db/tech_st/11.1.0/ERPTEST_erp.env
PATH=/u5/erptest/prodebs/db/tech_st/11.1.0/appsutil/scripts/ERPTEST_erp:$PATH
export PATH
=========================================================================
Clone Application Tier
su – appltest
/U1/erptest/prodebs/ap/apps_st/comn/clone/bin
perl adcfgclone.pl appsTier
xmcowellitapps
erptest
ERPTEST
erptest
cowell.com
/U1/erptest/prodebs
/U1/erptest/prodebs/ap/tech_st/10.1.2
/U1/erptest/prodebs/ap/tech_st/10.1.3
/U1/erptest/prodebs/ap/apps_st/appl
/U1/erptest/prodebs/ap/apps_st/comn
/U1/erptest/prodebs/ap/inst
Enabled
Enabled
Enabled
Enabled
Disable //建议改为DISABLE
n
erptest:1.0
n
70 //端口号
2 //注意选择
vi .bash_profile //clone完成再修改此项
. /U1/erptest/prodebs/ap/apps_st/appl/APPSERPTEST_erp.env
PATH=/U1/erptest/prodebs/ap/inst/apps/ERPTEST_erp/admin/scripts:$PATH
Export PATH
===================================================================
修改密码
修改apps和system(sys)密码的方法步履
一：appsTier
1.停止应用(appsTier)--用<applmgr>用户登录
$cd $ADMIN_SCRIPTS_HOME
$./adstpall.sh apps/<当前apps密码>
2.查看appsTier是否完全停止
$ps -ef|grep <applmgr>
注：切记一定要应用完全停止
3.修改apps的密码
$FNDCPASS apps/<当前apps密码> 0 Y system/<当前system密码> SYSTEM APPLSYS <修改后的密码>
如：将apps的当前密码xmcowellapps改为apps(system的密码为xmcowellmanager)
$FNDCPASS apps/xmcowellapps 0 Y system/xmcowellmanager SYSTEM APPLSYS apps
二：dbTier
4.修改system(sys)用户的密码--用<oramgr>用户登录
$sqlplus /nolog
SQL>conn /as sysdba
SQL>alter user system(sys) identified by "change_on_install" ;
SQL>exit