2008.03
本文档目的是为了广大 - Oracle EBS Release12 爱好者测试参考使用，本文档内容将全部是Oracle 技术内容，将不含有任何可能有商业信息的内容，请不要用于其他商业用途，如有违反，原创作者有权追究相关责任
文章主要内容:
- Oracle EBS R12 DB/AP 跨Server 安装
- Oracle EBS R12 DB 单instance 转换成双节点RAC
- Oracle EBS R12 Muti App Server Setup and Configration
- Parallel Concurrent Processing（PCP） 安装配置
- Muti APP/PCP/DB RAC 功能测试
- ERP 系统备份和恢复系统测试
测试系统环境
软件信息
测试环境软件清单
l 操作系统：HP-UX 11.23
l Application:Oracle E-Business Suite 12.0.4
l 数据库：Oracle DB Enterprise Edition 10.2.0.2
l Oracle Cluster Software 10.2.0.2
l HP MC/Service Guard 11.16
l HP Service Guard Cluster File System(CFS) 11.17
资源分布
系统资源分布
测试环境搭建
安装新系统
安装一套DB/AP分布到2台机器 上的新系统
l 在DB 和AP 服务器上分别创建oratest和appltest 用户
l 分别在DB/AP 服务器上创建相同的文件系统，例如：/u01/prod
l 详细安装方法，请参考我以前写过的文档
安装Oracle Cluster Software(CRS)
l Check Network Requirements(public/private/vip 设置检查)
l Verify Kernel Parameters
详细设置参数请参考Metalink Notes
l Check rsh and Host Equivalence
l Set up Shared Storage
这部分由HP工程师已经准备完毕，所以，不用做任何操作
配置Oracle DB RAC
l 详细方法请参考我以前写过的Single Instance Conversion RAC
小结
l 通过以上的步骤已经完成从单instance 向Oracle db RAC的转变
测试过程
双AP安装和配置
Shared Application Tier File System Layout
双AP安装和配置
操作过程
l Clone Application Server
$cd $INST_TOP/admin/scripts
$perl adpreclone.pl appsTier
l 限制操作修改现有AP SV文件属性
$mkdir $HOME/bin
$ln –s /bin/true $HOME/bin/chmod
$PATH=$HOME/bin:$PATH
l Create a new context file for new node
$cd /u01/ test/apps/apps_st/comn/clone/bin
$perl ./adclonectx.pl addnode \
Contextfile= ../context/apps/TEST_erpapp1.xml
l 删除文件限制属性
$rm $HOME/bin/chmod
l 产生一个新的Intance Home for new Node
$cd /u01/test/apps/apps_st/appl/ad/12.0.0/bin
$$AD_TOP/bin/perl ./adconfig.pl \
/u01/test/apps/TEST_erpapp2/appl/admin/TEST_erpapp2.xml
测试过程
对比两个节点Contextfile的下面值
文件系统权限
OAM 中确认
|
测试过程
LoadBalance 安装
Load Balance System Layout
修改context文件
| Context Variable Name | Old Context Value(erpapp1) | Old Context Value(erpapp2) | New Context Value |
|
| http | http | https |
|
|
| erpapp2 | test |
|
| zhulch.com.cn | zhulch.com.cn | zhulch.com.cn |
|
| 8000 | 8000 | 443 |
|
|
|
|
|
|
|
|
|
|
测试环境安装
F5 设置
操作过程
l 此部分有网络厂商完成，不过DBA需要指导他们去完成
测试环境安装
PCP配置
l Execute AutoConfig by using $INST_TOP/admin/scripts/adautocfg.sh on all concurrent nodes.
l Source the application environment.
l Check the configuration files tnsnames.ora and listener.ora located at $INST_TOP/ora/10.1.2/network/admin. Ensure that you have information of all the other concurrent nodes for FNDSM and FNDFS entries.
l Restart the application listener processes on each application node.
l Logon to Oracle E-Business Suite Release 12 using SYSADMIN in login and System Administrator Responsibility. Navigate to Install > Nodes screen and ensure that each node in the cluster is registered.
l Verify whether the Internal Monitor for each node is defined properly with correct primary and secondary node specification and work shift details. Also make sure the Internal Monitor manager is activated by going into Concurrent -> Manager -> Administrator and activate the manager.
(e.g. Internal Monitor: Host2 must have primary node as host2 and secondary node as host3)
l Set the $APPLCSF environment variable on all the CP nodes pointing to a log directory on a shared file system.
l Set the $APPLPTMP environment variable on all the CP nodes to the value of the UTL_FILE_DIR entry in init.ora on the database nodes. This value should be pointing to a directory on a shared file system.
l Set profile option ' Concurrent: PCP Instance Check' to OFF if database instance-sensitive failover is not required. By setting it to 'ON', Concurrent Managers will failover to a secondary Application tier node if the database instance it is connected to goes down.
Set Up Transaction Managers
l Shut down the application services (servers) on all nodes
l Shut down all the database instances cleanly in RAC environment using the command: SQL>shutdown immediate;
l Edit $ORACLE_HOME/dbs/<context_name>_ifile.ora. Add the following parameters:
§ _lm_global_posts=TRUE
§ _immediate_commit_propagation=TRUE
l Start the instances on all database nodes, one by one
l Start up the application services (servers) on all nodes
l Logon to Oracle E-Business Suite Release 12 using SYSADMIN login and System Administrator Responsibility.
Navigate to Profile > System and change the profile option ‘Concurrent: TM Transport Type' to ‘QUEUE' and verify the transaction manager works across the RAC instance.
l Navigate to Concurrent > Manager > Define screen, and set up the primary and secondary node names for transaction managers
l Restart the concurrent managers
l If any of the transaction managers are in de-activated status, activate them using
Concurrent > Manager > Administrator screen.
Set Up Load Balancing on Concurrent Processing Nodes
l Edit the applications context file through Oracle Applications Manager interface and set the value of Concurrent Manager TWO_TASK (s_cp_twotask) to load balancing alias (<service_name>_balance>)
l Execute AutoConfig by using $INST_TOP/admin/scripts/adautocfg.sh on all concurrent nodes.
功能测试
双AP 功能测试
双AP功能测试
l 可以通过拔网线的方式，模拟机器故障，详细过程，由于原来的截图不能在次显示
PCP 功能测试
PCP功能测试
l 可以通过拔网线的方式，模拟机器故障，详细过程，由于原来的截图不能在次显示
DB RAC功能测试
DB RAC功能测试
l 这个是普通DB RAC测试一样，整体思路，TNS文件。。拔网线模拟故障
备份系统测试
备份/恢复测试
备份测试
l 采用第3方软件，如TSM，Veritas或者HP DP+RMAN进行归档方式备份
恢复测试
l 采用第3方软件，如TSM，Veritas或者HP DP+RMAN进行归档方式恢复
总结
l 本文档只是能给大家一个思路，详细操作过程还需要参考metalink相关notes
