Managing patch packages for Oracle quarterly packages
This section details how to prepare and apply BMC Database Automation (BDA) patch packages for Oracle quarterly patches.
Before you begin
- Ensure that you have downloaded the latest version of OPatch and have set up OPatch media on the Manager.
- Ensure that a response file exists under /app/clarity/oracle_media/ on the Manager. If not, generate one.
To prepare and apply quarterly patch packages
The following table describes the files you must download to prepare and apply BDA patch packages and Oracle quarterly patches and where you must place the contents.
|Files (.zip) to Download||Example||Description||Required Location|
|BMC Database Automation patch package wrappers||GIPSU-Oct2014-220.127.116.11-Linux-x86-64.zip||Placeholder (0 KB archive) for corresponding Oracle patch media||Patch Repository in BMC Database Automation GUI|
|Quarterly patch media from Oracle||p18705901_121010_Linux-x86-64.zip|
Actual Oracle patch media. In the example file name, 18705901 is the patch ID.
Patch Repository in BMC Database Automation GUI
|OPatch utility from Oracle||/app/clarity/oracle_media/p6880880_102000_Linux-x86-64.zip||OPatch utility. In the example file name, 6880880 is the patch ID.||/app/clarity/oracle_media directory on the Manager|
Download the quarterly BDA patch package wrappers.
- To obtain access to the package wrappers, you need to contact BMC Customer Support.
- The actual Oracle patch media is not included in patch package wrappers.
- Patch package wrappers named ‘GIPSU- DBMS’ are applicable only if you are running a version of BDA earlier than 8.5 (beginning with version 8.5, the ‘GIPSU- DBMS’ wrapper type is no longer necessary).
- If Oracle releases additional OJVM patches, they can be applied (using a separate job) after applying the GIPSU. The BDA OJVM patch package wrappers are available here.
- Starting with version 8.9.01, BDA supports applying the combo PSU / OJVM. Download the appropriate combo patch package wrapper available here.
Download the quarterly patch media from Oracle.
On the Oracle support site, perform a search of the patch ID or OPatch ID to locate the files more quickly. When you download the Oracle patch media, the latest OPatch utility is also downloaded with it.
Import the patch package wrapper (downloaded in Step 1) into the Patch Repository.
- From the Management Console, select Patching > Patch Repository in the Context Frame.
In the Patch Repository page, click Import Package.
Click Browse to select a patch package file.
- Complete the Import Package page and click Import Package.
Replace the imported zero-length placeholder file contained in the patch package with the actual Oracle media.
From the Management Console, select Patching > Patch Repository in the Context Frame.
In the Patch Repository page, select the imported patch package and select Edit from the list box for that row.
- In the Package Configuration page, click Remove in the Patch File row to remove the zero-length placeholder file.
- In the Package Configuration page, click Browse in the Patch File row and select the Oracle patch media downloaded from Step 2.
- In the Package Settings page, do the following:
- Verify that the Package Name is displayed.
- (Optional) Update the Container and Available To settings.
- Click Skip Ahead and complete the wizard
After applying GIRU April 2019 patcc, the permission of $GRID_HOME/bin/sqlplus is changed to root:oinstall. You can use BDA custom action to change the permission manually.
The following patch management options are available for each patch package in the Patch Repository Listing page.
Displays patch package details.
NEW IN 8.9.02Pre-Stage
Allows you to copy and then extract a patch media on a candidate before you install or deploy the patch package.
Note: BMC Database Automation 8.9.02 and earlier versions do not support this option for the Oracle quarterly patch packages. For information about the pre-staging other patch packages, see Pre-staging an Oracle patch package. Starting with version 8.9.03, you can use this option for the Oracle quarterly patch packages as well.
|Verification||Displays the Oracle Patch Installation Verification page so that you can view patch candidates and selected options for patching.|
|Conflicts||Displays the Oracle Patch Conflicts Check page so that you can check for Oracle patch conflicts based on the patch package and candidates selected.|
Displays the patch package settings and permits changes to be made.
Enables you to export a BMC Database Automation patch package from the patch repository. When you export a patch package, a .zip file is created and downloaded to the location that you specify.
Removes that patch package from BMC Database Automation.
The Patch Repository Listing page also contains the following buttons:
- Create New Package: Use to create an Oracle patch package, where you can also granularly control the application and rollback of the patches.
- Import Package: Use to import a patch package that was created on another Manager. Before importing packages into the patch repository, ensure that all the appropriate targets for the intended package are specified under Patching > Packaging Configuration.
Bypassing patch validation
The quarterly BMC Database Automation patch package wrappers provided by BMC include a checksum to validate that the actual Oracle patch media that you uploaded into the patch package wrapper (see Step 4 in the preceding section) is the exact Oracle patch media that was tested by BMC.
To disable (ignore) the checksum, use a patching .xml template and add the following custom field:
<custom_fields> <field> <name>Validate_Patch</name> <value>Yes</value> <value>No</value> <default>Yes</default> <required>false</required> <hidden>false</hidden> <password>false</password> </field> </custom_fields>
Then, when initiating an Apply Patch job, select the template, and select No from the Validate Patch custom field in the Custom Fields page of the wizard:
For more information about working with templates and custom fields, see Adding custom fields to a template.