[Oracle EBS]5. About Maintenance Mode

最新推荐文章于 2022-02-14 00:17:55 发布

Petergepeter

最新推荐文章于 2022-02-14 00:17:55 发布

阅读量1k

点赞数

分类专栏： EBS 文章标签： oracle function manager patch user apache

本文链接：https://blog.csdn.net/Petergepeter/article/details/2108876

版权

EBS 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

Maintenance Mode 是EBS 11.5.10后给出的新特性。
首先，可以制定SYSTEM 正常down机计划，给出公告来，这通过Oracle Applications Manager (OAM)来完成。 <script language="JavaScript" type="text/javascript">function doHelpTag(helpTag){ var helperFrame; helperFrame = document.getElementById("helpTag"); //helperFrame.src='f?p=200:99:9562249948755645530::NO::P99_HELP_TAG:'+helpTag; if (helperFrame.contentDocument) { helperFrame.contentDocument.location.replace('f?p=200:99:9562249948755645530::NO::P99_HELP_TAG:'+helpTag); } else { helperFrame.Document.location.replace('f?p=200:99:9562249948755645530::NO::P99_HELP_TAG:'+helpTag); } } </script> <script type="text/javascript" src="/i/css/metalinkblaf.js"></script> <script type="text/javascript" src="/i/javascript/htmldb_html_elements.js"></script> <script type="text/javascript" src="/i/javascript/htmldb_get.js"></script> <script type="text/javascript"> </script> href="/i/css/core_V22.css" type="text/css" rel="stylesheet" /> href="/i/css/core_ie_V22.css" type="text/css" rel="stylesheet" /> <script language="JavaScript" type="text/javascript"> if (self.location.href != top.location.href){ top.location.href = self.location.href; } </script> <script type="text/javascript" src="/i/javascript/core.js"></script> href="/i/css/core.css" type="text/css" rel="stylesheet" /> href="/i/css/flows.css" type="text/css" rel="stylesheet" /> href="/i/css/marlin.css" type="text/css" rel="stylesheet" /> href="/i/css/platform2.css" type="text/css" rel="stylesheet" /> href="/i/css/metalinkblaf.css" type="text/css" rel="stylesheet" /><script language="JavaScript" type="text/javascript"> function doHelpTag(helpTag){ var helperFrame; helperFrame = document.getElementById("helpTag"); //helperFrame.src='f?p=200:99:9562249948755645530::NO::P99_HELP_TAG:'+helpTag; if (helperFrame.contentDocument) { helperFrame.contentDocument.location.replace('f?p=200:99:9562249948755645530::NO::P99_HELP_TAG:'+helpTag); } else { helperFrame.Document.location.replace('f?p=200:99:9562249948755645530::NO::P99_HELP_TAG:'+helpTag); } } </script> <script type="text/javascript" src="/i/css/metalinkblaf.js"></script> <script type="text/javascript" src="/i/javascript/htmldb_html_elements.js"></script> <script type="text/javascript" src="/i/javascript/htmldb_get.js"></script> <script type="text/javascript"> </script> href="/i/css/core_V22.css" type="text/css" rel="stylesheet" /> href="/i/css/core_ie_V22.css" type="text/css" rel="stylesheet" /> <script language="JavaScript" type="text/javascript"> if (self.location.href != top.location.href){ top.location.href = self.location.href; } </script> <script type="text/javascript" src="/i/javascript/core.js"></script> href="/i/css/core.css" type="text/css" rel="stylesheet" /> href="/i/css/flows.css" type="text/css" rel="stylesheet" /> href="/i/css/marlin.css" type="text/css" rel="stylesheet" /> href="/i/css/platform2.css" type="text/css" rel="stylesheet" /> href="/i/css/metalinkblaf.css" type="text/css" rel="stylesheet" />
其次，在Maintenance Mode时有Restricted Mode访问页，
最后，上Patch时，需要使用Maintenance Mode，即Maintenance Mode设置为ENABLE。
否则adpatch需要options=hotpatch ，而且速度很慢。

可以用以下方法查看：
select fnd_profile.value( ' APPS_MAINTENANCE_MODE ' ) from dual;

select v.profile_option_value v_profile

from fnd_profile_option_values v

, fnd_profile_options_vl p

where v.profile_option_id = p.profile_option_id

and (v.level_id = 10001 )

and p.PROFILE_OPTION_NAME = ' APPS_MAINTENANCE_MODE ' ;

总的来说，这样，更加人性化，用户知道目前系统在干嘛！

Step:
<script language="JavaScript" type="text/javascript"> function doHelpTag(helpTag){ var helperFrame; helperFrame = document.getElementById("helpTag"); //helperFrame.src='f?p=200:99:9562249948755645530::NO::P99_HELP_TAG:'+helpTag; if (helperFrame.contentDocument) { helperFrame.contentDocument.location.replace('f?p=200:99:9562249948755645530::NO::P99_HELP_TAG:'+helpTag); } else { helperFrame.Document.location.replace('f?p=200:99:9562249948755645530::NO::P99_HELP_TAG:'+helpTag); } } </script> <script type="text/javascript" src="/i/css/metalinkblaf.js"></script> <script type="text/javascript" src="/i/javascript/htmldb_html_elements.js"></script> <script type="text/javascript" src="/i/javascript/htmldb_get.js"></script> <script type="text/javascript"> </script> rel="stylesheet" type="text/css" href="/i/css/core_V22.css" /> rel="stylesheet" type="text/css" href="/i/css/core_ie_V22.css" /> <script language="JavaScript" type="text/javascript"> if (self.location.href != top.location.href){ top.location.href = self.location.href; } </script> <script type="text/javascript" src="/i/javascript/core.js"></script> rel="stylesheet" type="text/css" href="/i/css/core.css" /> rel="stylesheet" type="text/css" href="/i/css/flows.css" /> rel="stylesheet" type="text/css" href="/i/css/marlin.css" /> rel="stylesheet" type="text/css" href="/i/css/platform2.css" /> rel="stylesheet" type="text/css" href="/i/css/metalinkblaf.css" />

1 . Schedule the ' System Downtime ' from OAM

OAM: Site Map -- > Maintenance --> Manage Downtime Schedules

At the moment of the downtime, do the following:

2 . Shutdown Apache ( on Normal Mode):

adapcctl.sh stop

adstpall.sh < apps_user >/< apps_pwd >

3 . Enable ' Maintenance Mode ' from adadmin

adadmin: Options 5 , 1

4 . Start Apache ( on Restricted Mode)

adaprstctl.sh start

5 . Apply the Patch with adpatch

6 . Stop Apache ( on Restricted Mode)