In this article we are going to see Oracle Automation-Applying PSU patch in Oracle 12c Database Using Ansible Tool. Let’s start the Demo:-Steps to apply oracle PSU patch using Ansible:-Step 1:-Download the ansible-oracle-psu role from github site.Click Here. Step 2:-Copy the ZIP file to ansible server and unzip the file. All databases running in the homes that you update are patched to the Oracle Database 12 c release 1 patch for Oracle Database Appliance (12.1.0.2.160419). Run the oakcli update -patch 12.1.2.7.0 --database command, on Node 0 only.
All patching of Oracle Database Appliance is done using the quarterly Oracle Database Appliance patch bundle.
The patch bundle provides all relevant patches for the entire system, including the following:
![Pes patch download Pes patch download](/uploads/1/2/6/8/126880953/967430498.jpg)
- BIOS
- Hardware drivers, Hardware Management Pack (HWM), and firmware drivers for various components
- Oracle Appliance Manager
- Oracle Linux
- Oracle VM
- Java Development Kit (JDK)
- Oracle Integrated Lights Out Manager (Oracle ILOM)
- Oracle Database Patch Set Update (PSU)
- Oracle Auto Service Request (Oracle ASR)
- Oracle Grid Infrastructure
- Intelligent Platform Management Interface (IPMI)
![Oracle 22291127 patch download Oracle 22291127 patch download](/uploads/1/2/6/8/126880953/490196060.jpg)
The patch bundle consists of three logical groups of patches:
Table 1-1 Patch Components and Purposes
Patch Component | Objects Patched |
---|---|
SERVER ( server ) | Server components: Linux Operating System, Oracle ILOM, BIOS, Hardware Management Pack, IPMI, OAKCLI, Oracle ASR. For the virtualized platform, this component also includes Dom0 updates. The Server patch also includes Oracle Grid Infrastructure stack. |
STORAGE ( storage ) | Shared storage: Disk firmware, Controller Firmware. |
DB ( database ) | Oracle Database RDBMS stack. |
Note:
You must apply patch bundle components in this order:
- SERVER (
server
) - STORAGE (
storage
) - DB (
database
)
Oracle Database Appliance 12.1.2.7 Patch Set Guidelines
If you have Oracle Database running using High Availability options such as Oracle Real Application Clusters, then there is no downtime required while the patches are being installed. Oracle Appliance Manager verifies that the host meets all prerequisites to prevent you from installing patches in the wrong order. For example, you cannot install the
database
patch before you install the server
patch. When applied, the output displayed by the patch process advises you if the patch is being installed on one or both nodes. For older patches that only install on a single node, you must run the command oakcli update -patch
on the second node.As of Smart Update 3.3.0, you can no longer use Smart Update to download patches. You must instead log in to My Oracle Support directly to download the appropriate patches. This chapter describes how to do this.
Before You Begin
Prior to downloading patches from My Oracle Support:
Oracle 22291127 Patch Download
- Have a valid My Oracle Support login and password available. If you do not have a My Oracle Support account, go to
https://support.oracle.com
, click the Register link, and follow the instructions. - Determine the directory to which you want to download patches. If all machines have internet access, you should download patches to the same directory path on each machine (although this is not required). If you have machines that do not have internet access, download patches to a centralized location, such as a remotely mounted disk or removable media.
- Make a note of the version number of your current product installation. You will need this information when searching for available patches on My Oracle Support.
Downloading Patches From My Oracle Support
This section describes how to download patches from My Oracle Support. For additional information, enter document ID 1302053.1 in the Knowledge Base search field on My Oracle Support.
To download patches from My Oracle Support: Diablo 2 lod 1.14 builds.
- Open a web browser and enter the following URL:
- Click the Sign In button and log in using your My Oracle Support login name and password.
- Click the Patches and Updates tab. From this tab, you have two options for downloading patches:
- Enter the patch number and platform to download a single patch. See Downloading a Single Patch Using the Oracle Patch Number.
- Search for all available patches for your current product installation. See Searching for and Downloading All Available Patches.
Note:
As of Smart Update 3.3.0, you can download and apply only those patches for which the description starts with SU Patch.
Downloading a Single Patch Using the Oracle Patch Number
If you know the Oracle patch number for the patch you want to download:
Gta San Andreas Patch Download
- In the Patch Search section, click the Patch Name, Number, or Sun CR ID link.
- Select the appropriate entries for the following fields:
- Patch Name or Number—Enter the patch number.
- Platform—Select up to five platforms for the specified patch number. You can also change to another search criteria. For example, to find the patch for your language, change Platform to Language and then enter one or more languages.
- Click Search. The Patch Search Results are displayed.
- Select the check box for the patch.
- Click Download.
- Click the patch file name, and then click Save.
- Select the download location and click Save.
- Click Close to close the dialog box.
Downloading a Single Patch Using the Smart Update Patch ID
If you know the Smart Update patch ID (for example, CX138) for the patch you want to download:
- In the Patch Search section, click the Product or Family (Advanced Search) link.
- Select the appropriate entries for the following fields:
- Product—Select one or more products from this drop-down list. To select multiple products, press the Ctrl key while clicking on each product name.
- Release—Select one or more release version numbers for the specified product.
- Platform—Change Platform to Description and then enter the Smart Update patch ID as the search text.
- Click Search. The Patch Search Results are displayed.
- Select the check box for the patch.
- Click Download.
- Click the patch file name, and then click Save.
- Select the download location and click Save.
- Click Close to close the dialog box.
Searching for and Downloading All Available Patches
If you want to search for all available patches for your production installation, and download one or more of those patches:
- In the Patch Search section, click the Product or Family (Advanced Search) link.
- Select the appropriate entries for the following fields:
- Product—Select one or more products from this drop-down list. To select multiple products, press the Ctrl key while clicking on each product name.
- Release—Select one or more release version numbers for the specified product.
- Platform—Select up to five platforms for the selected product. You can also change to another search criteria. For example, to find all bugs that contain SU Patch in the description, change Platform to Description and then enter SU Patch as the search text.
- Click Search. The Patch Search Results are displayed.
- Select the check box for each patch that you want to download.
- Click Download. A dialog box appears listing all of the patches that you selected.
- For each patch in the list, click the patch file name, and then click Save.
- Select the download location and click Save.
- When done downloading all patches, click Close on the dialog box.