EBS R12.2最大的改进--Online Patching
Online Patching就是允许用户在运行时打patch,并且无需重启服务器。以前如果用户要打patch,用户必须重启服务器,这个很麻烦并且让会造成几个小时的停机,给客户也造成了成本的损失,12.2以后引入Online Patching,就不会有这样的烦恼了,对于EBS DBA绝对是一个福音
R12.2 OLP的实现方式:12.2引入了双文件系统(一个是run time文件系统,另一个是patching文件系统),包括APPL_TOP, Common Top,
Oracle Home, Web Home等等.
那么对于DB来说,在runtime和patching文件系统,是怎么管理数据库对象的?R12.2引入了一个新的概念“the logical view of the data model”,如果对于具体的实现方式可以看下边这篇文章
Oracle E-Business Suite Release 12.2 introduces Online Patching (OLP) using the new adop (AD Online Patching) utility. Online patching allows the application of patches while the system is up and running, and the users are online processing transactions.
Oracle Apps 12.2 comes with dual file systems (one for run time and another is for patching) and two port pools (one for each file system). Think of dual file systems as two copies of R12.1 file systems, including APPL_TOP, Common Top, Oracle Home, Web Home..etc.
This enables online patching the system on patch APPL_TOP, while application is still running on runtime APPL_TOP. This might sound like advanced staged APPL_TOP patching.
All right, we got two APPL_TOPs, but how do we manage the database objects in the same database between runtime and patching to make online patching even possible? Well, Release 12.2 introduces a new concept, the logical view of the data model. This is implemented
via editioning views, which isolate the running application from changes to the data model that may be introduced by a patch. So, data model changes are guaranteed to not affect the running application. Oracle Database 11g R2 Edition-Based Redefinition (EBR)
feature is used to maintain the runtime and patch editions of the database objects. The following are few important concepts here.
Two identical file systems are created during the Oracle Apps Installation in 12.2. After the installation, services can be started from either of the file systems. Once an online patch is applied, services must be started from the right RUN File system
only. Both the file systems are not equal any more. During the next prepare phase, ADOP copies the differences (Sync the file systems).
ADOP is a wrapper on top of auto patch (adpatch). ADOP manages the file sync, creating editions, etc and finally invokes adpatch to patch the PATCH environment.
ADOP always patches the $PATCH_BASE, while application is running out of $RUN_BASE.
Once patching $PATCH_BASE is complete, we need to flip $PATCH_BASE into $RUN_BASE and $RUN_BASE into $PATCH_BASE. This is known as cutover phase in ADOP. This still needs downtime/outage.
There are three editions in the database:
Run - Online users connect to this edition, which is the default database edition
Patch - Patching tools connect to this edition
Old - the previous run edition is now old edition
ADOP has got different phases: Prepare, Apply, Finalize, Cutover, and Cleanup. These phases are explained below.
Oracle Database 11g R2 Edition-Based Redefinition (EBR) feature enables multiple copies of the same code object in the database in different editions of the database. However, not all database objects are editioned. In this case, a temporary object is created
and all the rows are copied there. This may cause serious problems if the database is very large.
Online patching analysis report, ADZDCHKP.SQL, provides detailed report about the non-editioned object references. This can be run in R12.1 database before the upgrade.
You can still apply patches using ADPATCH, but not support (or not recommended).
Database would have two services defined out of the box.
转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7352177
分享到:
相关推荐
包含EBS从R12版本到R12.2版本的一些改进特征
EBS R12.2 更改apps密码
ORACLEEBS-OU-BG-INV-HR等组织架构介绍.pdf
ORACLEEBS-OU-BG-INV-HR等组织架构介绍(20211120083100).pdf
ORACLE ERP EBS经验整理之---月结关帐检查要点
晶澳太阳能Oracle EBS ERP升级项目-系统升级及平台迁移详细方案 客户EBS系统信息如下: EBS应用版本:12.0.6 平台:HP-UX B.11.31 U ia64 EBS数据库版本:10.2.0.3.0 平台:HP-UX B.11.31 U ia64 数据库大小:900G EBS...
EBS-R12.2.4-安装指南-V01EBS-R12.2.4-安装指南-V01EBS-R12.2.4-安装指南-V01EBS-R12.2.4-安装指南-V01
EBS 12.2 Application and database tier components along with details about the newly introduced EBS 12.2 FMW components, the new application filesystem (dual fs) and the new patching concept called on...
Oracle_EBS_R12_操作手册的中文操作手册,适合对R12的入门学习
ERP-ORACLE-EBS-AP发票管理--功能流程
ERP-ORACLE-EBS-AP发票管理--操作手册
ERP-ORACLE-EBS-AR发票管理--功能流程
ERP-ORACLE-EBS-AR发票管理--基本概念
ORACLE-EBS-OU-BG-INV-HR等组织架构介绍.doc
EBS R12.2环境克隆(使用rman备份);
ERP-ORACLE-EBS-AR收款管理--功能流程基本概念
Oracle EBS R12系统管理员,内部培训交流
ORACLE EBS OPM标准功能培训资料-OPM成本
Oracle EBS R12中的配置文件及中文说明
完整的Oracle ebs ASCP(高级计划排程)模块的方案及相关对应的设置测试文档,可以学习整个ASCP的设置和流程。