克隆环境

  • OS: IBM AIX 5.3 64bit
  • EBS: 11.5.10.2 64bit
  • DB: 9.2.0.6 64bit

ERPProd和ERPTest环境一样,在硬件方面ERPTest配置稍低

准备工作

关闭克隆目标系统的数据库、应用等。目前ERP环境采用定期克隆,这里还需要删除克隆目标系统上以前的数据

1)关闭测试环境应用、监听、数据库

--testmgr
adstpall.sh apps/xxxxxx

--testora
addlnctl.sh stop ERP
addbctl.sh stop immediate

2)删除测试环境数据

--testora
rm -rf /u2/TEST/testora/testdata /u2/TEST/testora/testdb &
--testora
rm -f /erpdata/redodata/redo*.dbf

--testmgr
rm -rf /u2/TEST/testmgr/testappl /u2/TEST/testmgr/testora &

3)删除测试环境上一次克隆时做的备份

--testmgr
cd /u2/TEST/testmgr/testcomn
rm -rf _pages_120422bk &
rm -rf html_120422bk &
rm -rf java_120422bk &
rm -rf clone_120422bk & 
rm -rf util_120422bk &

4)备份测试环境上一次克隆的数据

--testmgr
mv /u2/TEST/testmgr/testcomn/_pages /u2/TEST/testmgr/testcomn/_pages_120527bk
mv /u2/TEST/testmgr/testcomn/html /u2/TEST/testmgr/testcomn/html_120527bk
mv /u2/TEST/testmgr/testcomn/java /u2/TEST/testmgr/testcomn/java_120527bk
mv /u2/TEST/testmgr/testcomn/clone /u2/TEST/testmgr/testcomn/clone_120527bk
mv /u2/TEST/testmgr/testcomn/util /u2/TEST/testmgr/testcomn/util_120527bk

2.正式克隆

在执行rapid clone时,会从原系统创建克隆用的模板配置文件,当原系统文件复制到目标 系统时,rapid clone工具将使用目标心痛的配置来更新这些模板配置文件,达到克隆出另 外一套系统的目的。

1)关闭应用、监听、数据库

--prodmgr
adstpall.sh apps/xxxxxx
--prodora
addlnctl.sh stop PROD
addbctl.sh stop immediate

2)数据库预克隆

--prodora
cd /u1/PROD/prodora/proddb/9.2.0/appsutil/scripts/PROD_erpprod
perl adpreclone.pl dbTier

3)应用预克隆

--prodmgr
cd /u1/PROD/prodmgr/prodcomn/admin/scripts/PROD_erpprod
perl adpreclone.pl appsTier

4)关闭原系统数据

因克隆后,数据库已经开启,再次关闭db

--prodora
addbctl.sh stop immediate

5)拷贝原系统数据到目标系统

目前ERP正式、测试环境使用AIX 5.3操作系统,共用磁阵,拷贝数据可以采用挂载文件系统 的方式进行

卸载正式环境上/u1文件系统

[email protected]
fuser -u /dev/fslv00
umount /u1
varyoffvg prodvg

挂载/u1到测试环境

[email protected]
varyonvg prodvg
mount /u1

复制原系统数据到目标系统

[email protected]
cp -hrf /u1/PROD/prodora/proddb /u2/TEST/testora/testdb &
cp -hrf /u1/PROD/prodora/proddata /u2/TEST/testora/testdata &
cp -hrf /u1/PROD/prodmgr/prodappl /u2/TEST/testmgr/testappl &
cp -hrf /u1/PROD/prodmgr/prodora /u2/TEST/testmgr/testora &

cp -hrf /u1/PROD/prodmgr/prodcomn/_pages /u2/TEST/testmgr/testcomn/_pages &
cp -hrf /u1/PROD/prodmgr/prodcomn/html /u2/TEST/testmgr/testcomn/html &
cp -hrf /u1/PROD/prodmgr/prodcomn/java /u2/TEST/testmgr/testcomn/java &
cp -hrf /u1/PROD/prodmgr/prodcomn/util /u2/TEST/testmgr/testcomn/util &
cp -hrf /u1/PROD/prodmgr/prodcomn/clone /u2/TEST/testmgr/testcomn/clone &

检查复制数据任务是否完成

[email protected]
jobs 或 ps -ef|grep cp

复制完成后,测试环境上卸载/u1,并将/u1挂载至原系统

[email protected]
unmount /u1
varyoffvg prodvg

[email protected]
varyonvg prodvg
mount /u1

开启原系统数据库、应用等,使应用正常提供服务

开启DB、监听

--prodora
adautocfg.sh

备份jserv.properties文件

--prodmgr
cp /u1/PROD/prodmgr/prodora/iAS/Apache/Jserv/etc/jserv.properties /u1/PROD/prodmgr/prodora/iAS/Apache/Jserv/etc/jserv.properties.dist
adautocfg.sh

正式环境加上第三方jar包 开启应用

--prodmgr
adstrtal.sh apps/xxxxxx

3.配置目标系统

配置目标系统,主要是运行一些配置命令,设置目标系统的sid,路径,端口等

1)更改文件所属用户组

[email protected]
chown -R testora:dba /u2/TEST/testora/testdb /u2/TEST/testora/testdata &
chown -R testmgr:dba /u2/TEST/testmgr/testora /u2/TEST/testmgr/testcomn /u2/TEST/testmgr/testappl &

2)配置重做日志

原系统中新增了重做日志组,路径/erpdata/redodata

复制重做日志

su - testora

切换时会提示找不到环境文件,属于正常现象(.profile[11]: /u2/TEST/testora/testdb/9.2.0/ERP_erp.env) 复制redolog到/erpdata/redodata下

cp /u2/TEST/testora/testdata/redo01.dbf /erpdata/redodata
cp /u2/TEST/testora/testdata/redo02.dbf /erpdata/redodata
cd /erpdata/redodata

更改重做日志组设置

系统中重做日志组更改了路径,此时需要手动更改adcrdb.zip中的配置

--testora
cd /u2/TEST/testora/testdb/9.2.0/appsutil/clone/data/stage
cp adcrdb.zip adcrdb.zip.120527bk
unzip adcrdb.zip
Archive: adcrdb.zip
inflating: adcrdbclone.sql
inflating: adcrdb.sh 
inflating: dbfinfo.lst

修改redolog路径,共四处

vi adcrdbclone.sql
GROUP 1 ('%s_dbhome2%/redo01.dbf', '/erpdata/redodata/redo01.dbf') SIZE 314572800

重新打包adcrdb文件

zip -o adcrdb.zip adcrdbclone.sql adcrdb.sh dbfinfo.lst

运行orainstRoot.sh脚本

[email protected]
/tmp/orainstRoot.sh

配置和开启数据库层

从原系统克隆复制过来的配置需要根据目标系统进行一些调整,需谨慎

--testora
cd /u2/TEST/testora/testdb/9.2.0/appsutil/clone/bin
perl adcfgclone.pl dbTier

Do you want to use a virtual hostname for the target node (y/n) [n] ?:
Target instance is a Real Application Cluster (RAC) instance (y/n) [n]:
Target System database name [PROD]:ERP
Target system RDBMS ORACLE_HOME directory [/u1/PROD/prodora/proddb/9.2.0]:/u2/TEST/testora/testdb/9.2.0
Target system utl_file accessible directories list [/usr/tmp, /usr/tmp, /u1/PROD/prodora/proddb/9.2.0/appsutil/outbound/PROD_erpprod]:
/usr/tmp,/usr/tmp,/u2/TEST/testora/testdb/9.2.0/appsutil/outbound/ERP_erp
Number of DATA_TOP's on the target system [2]:1
Target system DATA_TOP 1:/u2/TEST/testora/testdata
Do you want to preserve the Display set to erpprod:1.0 (y/n) [y] ?:n
Target system Display [erptest:0.0]::0.0
Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:n
Enter the port pool number [0-99]:
3
... ...

再次运行orainstRoot.sh脚本

[email protected]
/tmp/orainstRoot.sh

配置和开启应用层

--testmgr
cd /u2/TEST/testmgr/testcomn/clone/bin
perl adcfgclone.pl appsTier

Do you want to use a virtual hostname for the target node (y/n) [n] ?:
Target system database SID [PROD]:ERP
Target system database server node [erpprod]:erp
Target system database domain name [egolife.com]:
Does the target system have more than one application tier server node (y/n) [n] ?:
Is the target system APPL_TOP divided into multiple mount points (y/n) [n] ?:
Target system APPL_TOP mount point [/u1/PROD/prodmgr/prodappl]:/u2/TEST/testmgr/testappl
Target system COMMON_TOP directory [/u1/PROD/prodmgr/prodcomn]:/u2/TEST/testmgr/testcomn
Target system 8.0.6 ORACLE_HOME directory [/u1/PROD/prodmgr/prodora/8.0.6]:/u2/TEST/testmgr/testora/8.0.6
Target system iAS ORACLE_HOME directory [/u1/PROD/prodmgr/prodora/iAS]:/u2/TEST/testmgr/testora/iAS
Do you want to preserve the Display set to erpprod:1.0 (y/n) [y] ?:n
Target system Display [erptest:0.0]::0.0
Location of the JDK on the target system [/usr/java14]:
Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:n
Enter the port pool number [0-99]:
3
UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /usr/tmp
3. /usr/tmp
4. /u2/TEST/testora/testdb/9.2.0/appsutil/outbound/TEST_erptest
5. /u2/TEST/testora/testdb/9.2.0/appsutil/outbound/TEST_erptest
6. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1]:1


addisctl.sh version 115.15

/u2/TEST/testmgr/testora/8.0.6/vbroker/bin/osagent
Started osagent.
Osagent logs messages to the file /u2/TEST/testmgr/testora/8.0.6/discwb4/util/osagent.log.
Waiting for OAD to start...
Started OAD.
OAD logs messages to the file /u2/TEST/testmgr/testora/8.0.6/discwb4/util/oad.log.
Discoverer Locator Started.
Locator logs messages to the file /u2/TEST/testmgr/testora/8.0.6/discwb4/util/locator.log.
Registering Discoverer Session
Completed registration of repository_id = IDL:DCISessionManager:1.0
object_name = erptest.egolife.com_8003OracleDiscovererSession4
reference data =
path_name = /u2/TEST/testmgr/testora/8.0.6/discwb4/util/runses.sh
activation_policy = UNSHARED_SERVER
args = (length=4)[-session; erptestegolife.com_8003OracleDiscovererSession4; -prefere
nce; erptest.egolife.com_8003OracleDiscovererPreferences4; ]
env = NONE
for OAD on host 10.20.1.14
Registering the Collector
Completed registration of repository_id = IDL:DCICollector:1.0
object_name = erptest.egolife.com_8003OracleDiscovererCollector4
reference data =
path_name = /u2/TEST/testmgr/testora/8.0.6/discwb4/util/runcol.sh
activation_policy = SHARED_SERVER
args = (length=2)[-collector; erptest.egolife.com_8003OracleDiscovererCollector4; ]
env = NONE
for OAD on host 10.20.1.14
Applying preferences from file : /u2/TEST/testmgr/testora/8.0.6/discwb4/util/pref.txt
Finished applying preferences

Closing down registry..
Registry File sync...
Registering Discoverer Preference Repository
Completed registration of repository_id = IDL:DCICORBAInterface:1.0
object_name = erptest.egolife.com_8003OracleDiscovererPreferences4
reference data =
path_name = /u2/TEST/testmgr/testora/8.0.6/discwb4/util/runpref.sh
activation_policy = SHARED_SERVER
args = (length=2)[-preference; erptest.egolife.com_8003OracleDiscovererPreferences4; ]
env = NONE
for OAD on host 10.20.1.14

addisctl.sh: exiting with status 0


.end std out.

.end err out.

4.完成目标系统最终设置

1)Profile参数设置

更改颜色和Site name

System profile -> Java Color Scheme : blue
Site Name : ERP

2)重新配置应用

关闭应用

--testmgr
adstpall.sh apps/xxxxxx

运行自动配置脚本

--testmgr
adautocfg.sh

删除原系统节点

-apps
select * from fnd_nodes ;
DELETE FROM FND_NODES WHERE NODE_NAME='ERPPROD';

3)更改工作流设置

--sysadmin
Administrator -> workflow -> Notification Mailers -> Edit

将PROD改为ERP,用户名密码为testmgr的用户名密码 修改并发管理器的节点名为ERP Standard Manager

4)取消请求

取消所有定期跑的请求,如AIS、报表、定期请求等

5)更改密码

生产环境克隆到测试环境后,为安全起见,必须更改测试环境密码 更改数据库和应用用户密码,在更改密码前,先关闭应用

--testmgr
adstpall.sh apps/xxxxxx

运行fndcpass命令,更改密码

FNDCPASS apps/oldpassword 0 Y system/manager SYSTEM APPLSYS newpassword

更改wdbsvr.app中记录的密码

vi $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
password = newpassword

运行自动配置脚本

--testmgr
adautocfg.sh

6)初始化参数设置

关闭数据库

--testora
addbctl.sh stop immediate

设置归档参数

cd /u2/TEST/testora/testdb/9.2.0/dbs
vi initERP.ora

log_archive_start = true # if you want automatic archiving
log_archive_dest_1 ='location=/u2/TEST/testora/arclog/'
log_archive_format ='arch_%t_%s.arc'

开启数据库

$ sqlplus /nolog
SQL> conn /as sysdba
SQL> startup mount pfile='/u2/TEST/testora/testdb/9.2.0/dbs/initERP.ora';
SQL> alter database archivelog;
SQL> archive log start;
SQL> archive log list;
SQL> alter database open;
SQL> alter system switch logfile;
SQL> create spfile from pfile;
SQL> shutdown immediate
SQL> startup
SQL> alter system set sga_max_size = 3000M scope=spfile;
SQL> shutdown
SQL> startup

5.错误记录

1)2012-04-22 出错记录

将testvg挂载到正式环境后复制出现IO错误,重新挂载时出错

# mount /u2
Replaying log for /dev/fslv00.
mount: 0506-324 Cannot mount /dev/fslv00 on /u2: The media is not formatted or the format is not correct.
0506-342 The superblock on /dev/fslv00 is dirty. Run a full fsck to fix.

解决方法

在测试环境将testvg重新激活,使用fsck修复。复制时将prodvg挂载到测试环境进行复制。 testvg无法挂载到正式环境的原因待查。

# fsck /u2
The current volume is: /dev/fslv00
Primary superblock is valid.
J2_LOGREDO:log redo processing for /dev/fslv00 
Primary superblock is valid.
*** Phase 1 - Initial inode scan
*** Phase 2 - Process remaining directories
*** Phase 3 - Process remaining files
*** Phase 4 - Check and repair inode allocation map
File system inode map is corrupt; FIX? y
Superblock marked dirty because repairs are about to be written.
*** Phase 5 - Check and repair block allocation map
File system is clean.
Superblock is marked dirty; FIX? y
All observed inconsistencies have been repaired.

2)2010-11-21 出错记录

Completed Apply...
Sun Nov 21 15:30:38 2010

Beginning APPSIAS_ERP registration to central inventory...

ORACLE_HOME NAME : APPSIAS_ERP
ORACLE_HOME PATH : /u2/TEST/testmgr/testora/iAS
Using Inventory location in /etc/oraInst.loc
Log file located at /etc/oraInventory/logs/OracleHomeCloner_11210330.log

ERROR: Registration Failed... Please check log file.

You can rerun this registration with the following script:
/u2/TEST/testmgr/testappl/admin/out/ERP_erp/regOUI_APPSIAS_ERP.sh

Skipping the starting of services
INFO : Rapid Clone completed successfully , but the AutoConfig run recorded some errors. 
Please review the AutoConfig section in the logfile. If required, you can re-run AutoConfig from command line after fixing the problem
Once Autoconfig issue is fixed , you can start services$ 
$ /u2/TEST/testmgr/testappl/admin/out/ERP_erp/regOUI_APPSIAS_ERP.sh
Using Inventory location in /etc/oraInst.loc
Log file located at /etc/oraInventory/logs/OracleHomeCloner_11210334.log
Registration failed
ERRORCODE = 1 ERRORCODE_END

# cat /etc/oraInventory/logs/OracleHomeCloner_11210340.log|more
Registering local Oracle Home located at /u2/TEST/testmgr/testora/iAS to central
oracle inventory
RC-00126: Update inventory failed. 
Unable to create a new Oracle Home at /u2/TEST/testmgr/testora/iAS. Oracle Home 
already exists at this location. Select another location.
Raised by oracle.apps.ad.clone.util.OracleHomeCloner
Registering local Oracle Home located at /u2/TEST/testmgr/testora/iAS to central
oracle inventory
RC-00126: Update inventory failed. 
Unable to create a new Oracle Home at /u2/TEST/testmgr/testora/iAS. Oracle Home 
already exists at this location. Select another location.
Raised by oracle.apps.ad.clone.util.OracleHomeCloner

解决方法

mv /tmp/oraInventory /tmp/oraInventory.bk
/tmp/orainstRoot.sh

参考

  • Cloning Oracle Applications Release 11i with Rapid Clone
  • EBS 11i Creating a Clone using Oracle Application Manager (OAM Clone)


blog comments powered by Disqus

Published

11 November 2012

Categories

Tags

Github