转一段网友回复:
Hi there,
It is just a quick idea. I have suspicious that ad_applied_patches
contains information about patches that you applied on the system,
ad_bugs has information about all bugs and patches that have been
included in the patches you applied.
For example you apply merged patch merge123 it contains 5 patches
10001 10002 10003 …
ad_applied_patches – will have one record about merge123
ad_bugs – 5 records
Another example: you apply maintenance patch which includes 51 other
patches. In that case
ad_applied_patches – will have one record about maintenance patch
ad_bugs – 51 + 1
I hope my thought is clear for you.
PS Anyway I use ad_bugs table in order to find out do I have one or
another patch to apply.
Jurijs
—————————–
AD_BUGS holds information about the various Oracle Applications bugs whose fixes have been applied (ie. patched) in the Oracle Applications installation.
AD_APPLIED_PATCHES holds information about the “distinct” Oracle Applications patches that have been applied. If 2 patches happen to have the same name but are different in content (eg. “merged” patches), then they are considered distinct and this table will therefore hold 2 records.
select count(bug_number) from apps.ad_bugs; bug_number 对应 patch号
ad_applied_patches是你自己adpatch打的那些(包括merge),但是安装的时候已经包含的patch,这个表不会记录,
所以如果要查询某个patch是否已经applied,还是ad_bugs。
Filename [adpatch.log] : 10257769_EN_adpatch.log(指定adpatch输出日志的名字,一般放在$APPL_TOP/admin/<SID>/log下,默认名为adpatch.log,不过最好改成补丁编号+语言.log)
最新评论
这个牛
放下欲望,男人从来不醉,充分且必要
勇气、责任、自信、创新,为天下先!
软件即数据,软件即服务,软件即管理,软件就是对人类各种社会活动的仿真和记录。软件很重要,但软件不可能凌驾于业务之上,尤其不可能高人一等。