How to determine which patches have been applied

iteye_21199

于 2012-04-25 16:49:00 发布

阅读量130

点赞数

文章标签：数据库

本文介绍如何通过查询AD_APPLIED_PATCHES和AD_BUGS两个表来确定已应用于Oracle E-Business Suite应用程序的补丁。对于直接应用的补丁，使用AD_APPLIED_PATCHES表；对于直接应用及包含在其他补丁中的补丁，则使用AD_BUGS表。提供了具体的SQL查询语句示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

原文:http://oraqa.com/2006/12/27/how-to-determine-which-patches-have-been-applied/

There are two tables that contain information about patches applied to your Oracle E-Business Suite applications:

AD_APPLIED_PATCHEScontains the list of patches that weredirectly applied.
AD_BUGScontains the list of all the patches that were directly applied or were contained in the patches that were directly applied.

For example, if you are trying to find out if a certain pre-requisite patch has been applied, query AD_BUGS. If you are trying to find out patches applied in a date range, query AD_APPLIED_PATCHES.

SELECT *
  FROM ad_bugs
 WHERE bug_number = 'patch_number';

SELECT *
  FROM ad_applied_patches
 WHERE patch_name = 'patch_number';

Replacepatch_numberwith the number of the patch you want to check.