In this post,  we will perform patching on BM (Bare Metals) and VM ( Virtuals Machine) database systems by using DBCLI on the 2-Node RAC running on Oracle Database 19c.

Note: This tool is not applicable to Exadata DB systems.

Prerequisites

  • The /u01 directory has at least 15 GB of free space.
  • The Oracle Clusterware is up and running on the DB system.
  • All nodes of the DB system are up and running.

Before starting the patching, we need to upgrade the DBCLI utility. For that perform the below steps

  • Login to OPC user with Public IP/Private IP by using private key. Switch the user to root.
  • Update the CLI by using the cliadm update-dbcli command.
  • Wait for the update job to complete successfully. Check the status of the job by using the dbcli list-jobs command.
  • Display the installed patch versions by using the dbcli describe-component command.
  • Display the latest patch versions available in Object Storage by using the dbcli describe-latestpatch command.
  • Now, we can perform the prechecks on the server components (Grid InfraStruture) by using the dbcli update-server command with -p argument. Note the Job Id.
  • Check the job output by using the dbcli list-job command.
  • Apply the patch by using the dbcli update-server command. Note the Job Id.
  • Check the job output by using the dbcli describe-job command with the job ID.
  • Once the patching has been completed on Grid Infrastructure of 2-Node RAC. You can verify by using list-jobs, describe-component and describe-job with DBCLI utility.
  • Before run the precheck, we need the database home ID by using dbcli list-dbhomes.
  • Now, we can start the precheck for the database home by using the dbcli update-dbhome command with -p argument . Note the Job Id.
Note: -i is used for Database home ID and -p to run the prechecks.
  • Check the job output by using the dbcli list-job command.
  • Apply the patch by using the dbcli update-dbhome command. Note the Job Id.
  • Check the job output by using the dbcli describe-job command with the job ID.
  • Once the patching has been completed on Grid Infrastructure of 2-Node RAC. You can verify by using list-jobs, describe-component and describe-job with DBCLI utility.

In the next post, we will see more usage of DBCLI utility.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Tagged:

Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.