Shulou(Shulou.com)06/01 Report--

Release

Standard product release. For example, the first release of Oracle Database 10g Release 2 is 10.2.0.1, which can be publicly downloaded from OTN, edelivery and other sites.

Patch Set Release

PSR is what people used to say in the early days. This is a patch set released on the major release number that fixes more Bug and may include some enhancements (Enhancement). For example, 11.2.0.1 is a major version, then 11.2.0.2 and 11.2.0.3 are two different Patch set. This patch set has undergone rigorous integration testing and is cumulative. Therefore, it is recommended to install the latest Patch Set.

Patch Set Update

PSU is what DBA&DMA often calls PSU. Oracle selects patches that have the largest number of downloads per quarter and have been verified to have a lower risk and put them into the PSU of each quarter to fix some serious problems, including the CPU of each quarter, which is cumulative. Although the 5th bit of the database version is used when describing PSU, such as Database PSU 11.2.0.3.5, in fact, the version of the database will not really change after typing PSU. The version seen in v$version is still 4 digits (11.2.0.3.0), and the fifth bit is still 0.

Pay attention to

(1) there is no CPU and PSU on Windows. Using BundlePatch instead of PSU,Bundle Patch for Windows and Exadata,Oracle will include the content of PSU.

(2) starting from version 11.2.0.2, a new patch strategy has been introduced, and the Patch Set released after 11.2.0.1 is itself a complete installation package, and the basic Release version installation is no longer required.

Critical PatchUpdate

This refers to the CPU patch. Released quarterly, some of the patches used to fix security are cumulative. Now it has been renamed Security Patch Update (SPU).

"this kind of problem is not a software error, and there will not be any problems in normal use. But people with ulterior motives can bypass the security management mechanism of the database system and achieve the purpose of unauthorized access by running very cleverly designed code.

Important patch announcements can be found here.

InterimPatch/One-OffPatch

A patch is what we often call a patch, a patch released to fix one (or several) Bug. This patch is recommended to be tested on the test library and then installed on the production library.

Merged Patch

The merged patch. This Merged Patch is required when there is a conflict between several small patches and cannot be installed at the same time. Patch conflicts are mainly due to two or more patches that modify the same file, but the contents of the changes are different.

Bundle Patch (BP)

Patch set to fix multiple Bug. There are no small patches for Oracle on the Windows platform, only this Bundle Patch. This cumulative patch set is released periodically (at least quarterly), meaning that each Bundle Patch contains all previous Bundle Patch. Windows Bundle Patch 16, for example, will contain all the previous 15 Bundle Patch, so we always recommend installing the latest Bundle Patch. The Window Bundle Patch of Oracle's cluster software is the same as that of database software, such as Windows Bundle Patch 16 (patch number 16167942, which can be used either on the cluster or on the database).

For ■ to know the patch number of Windows Bundle Patch, you can refer to the MOS documentation:

Note 161549.1 Oracle Database, Networking and Grid Agent Patches for Microsoft Platforms

This part of ■ needs to be added.

Diagnostic Patch

Diagnostic patch. As the name implies, such patches are not used to solve the problem, but to find the cause of the problem. Such patches need to be installed only when required by Oracle Technical support. You should uninstall this patch as soon as you get the diagnostic information you need.

Composite Patch

Since April 2012, Database PSU 11.2.0.3.2 and 11.2.0.2.0.7 have introduced a new concept called Composite Patches. This is a new type of patch package, which is different from other cumulative patch packs. If you install Composite Patches for the first time, all the patches included in the Composite Patches will be installed, and the subsequent installation of Composite Patches will only install the changes and new patches compared to the previous Composite Patches.

Improvements to overlay patches Composite Patche include reducing patch installation time and reducing the need to roll back previously applied overlay patches. The new Composite Patches format makes it possible for the overlay patches of the previous PSU application and the newly installed PSU to coexist. For more information, please see Document 1376691.1'Composite Patches for Oracle Products' and Oracle Database Support NEWS April edition.

■ PSU is a kind of Composite Patch.

"the composite patch installed for the first time is PSU 11.2.0.3.5:

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.3.0

There are 1 products installed in this Oracle Home.

Interim patches (1):

Patch 14727310: applied on Fri Dec 09 10:59:28 EST 2011

Patch Description: "Database Patch Set Update: 11.2.0.3.5 (14727310)"

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.