Category: Update

This post discusses the introduction of a new patching feature (one-button patching) in the AutoUpgrade tool, now at version 24.7, which simplifies the database release update process. Although currently, it only supports single-instance homes and Oracle Database 19c on Linux, the Oracle Database Upgrade Team will be addressing additional requirements in future versions. Since automating patching is essential for large environments to ensure updates and compliance, I have provided a comprehensive set of Ansible playbooks for database patching(19.24) on my GitHub repo, which can help promote efficiency and reduce errors in the patching process.

This post discusses using Ansible Playbooks to patch Oracle database software, from installing Ansible to completing the patching process. It provides detailed playbooks for creating new database software directories, applying release updates and one-off patches, running datapatch, and removing old database homes. The author also revised the playbooks for better readability and compatibility.

This blog post discusses the usage of Redhat Ansible to patch grid infrastructure, emphasizing its simplicity and efficiency. It explains the process of installing Ansible, preparing the environment, and executing playbooks for grid software patching with detailed steps. The author also provides valuable insights into the revision of playbooks for best practices.

Patching your database is crucial for security and performance. Develop a strategy based on your organization’s needs. Regularly schedule routine patches, test thoroughly, and inform stakeholders. Prioritize critical security fixes. Read release notes and consider expert blogs. Apply patches selectively, and consider in-place and out-of-place patching methods. Fleet Patching and Provisioning can scale patch deployment effectively.

The post discusses the process of cleaning old Oracle Homes after patching database servers. It advises keeping old homes for 15 days as a precaution, then removing them when comfortable with the new ones. The methods described for removal involve the deinstall command and fleet maintenance using cleanup_software verb.

The content details the process of patching Oracle RAC databases using fleet maintenance. It includes steps for creating a gold image, deploying the image to target databases, and migrating instances to the newly patched Oracle Home. It also discusses post-patching tasks such as updating shell scripts and addressing alert.log messages. Additional steps are provided for RMAN catalog users.