Oracle EBS 打3类补丁主要步骤

Oracle EBS的补丁大致可以分为3类: apps_st(adpatch) / tech_st(opatch) / db(opatch)

本文简单介绍打这3类补丁主要步骤.

1. adpatch 应用层: 需要启用维护模式, 不需要shutdown数据库

down ap tier

enable maintenance mode

adpatch

disable maintenance mode

up ap tier

instance check(count invalids)

sanity check(Active User request)

2. opatch 应用层(forms/reports): 不需要启用维护模式, 不需要shutdown数据库

down ap tier

opatch

up ap tier

instance check(count invalids)

sanity check(Active User request)

注意:

这里的opatch是patch ap tier的technology stack, 不是DB本身, technology stack和ap tier的关系参照如下:

ap tier = technology stack + application stack
technology stack(tech_st)  = $ORACLE_HOME + $IAS_ORACLE_HOME
application stack(apps_st) = $APPL_TOP + $COMMON_TOP

3. opatch 数据库: 不需要启用维护模式, 需要shutdown数据库

down ap tier

down db

opatch

up db

up ap tier

instance check(count invalids)

sanity check(Active User request)