Patching a DB System in OCI
Anil Mahadev
Oracle ACE PRO ? | Principal Cloud Architect (MS Azure and OCI) @ IDERA Software | Innovating Database & Multi-Cloud Solutions | Expert in OCI & Data-Driven Strategies | Bridging Technology with Business Impact
Howdy! Y'all!
Let's learn how to patch an Oracle Database 19c - 19.16 to 19.18 using OCI DB System.
1) Login to the OCI Cloud Console
2) Navigate under Oracle Database --> Database (BM/VM) - BM - Bare Metal / VM - Virtual Machine
3) Now navigate to the DB System in question and click on the Node and login to the box to validate the current version: Mine is 19.16.0.0.0
We shall now navigate to the console:
Click on the DB Systems section --> At the bottom left of the screen click on
Databases
Now navigate to the Database Page.
Scroll down to the section where it is says Version:
Click on the View hyperlink to view the latest version:
As you can see below, the latest is 19.18. Let's Patch this database.
Couple of Notes:
1) Ensure a maintenance window is setup - Mine was a test. so no biggie.. However in Test, Dev and Production environments.
2) Once that is set, go ahead and perform the patch upgrade
Just hang on for one last part!
We need to pre-check that the patch won't break our current DB in any shape or form.
To make sure this doesn't happen, lets run a pre-check
领英推è
Once everything is satisfied.
A great way to find out what's going click on the Worker Requests area.
Let's patch!
Navigate to the Database and the hamburger menu and click on Apply
Note with Apply , it does a pre-check and then applies the patch
Now go ahead and grab a cup of your fav beverage and let OCI do the magic!
You will now see the status change from Available to Applying
Once the patching process begins, you should see a screen like this below.
Once it completes, you should see a screen like this below.
Your database is ready to be accessed again!
Let's verify in our SQL*Plus console
Congrats!! You have successfully patched an OCI bound DB system!
Analyst III infrastructure service | Oracle DBA | hands on with On-Premises, OCI & windows servers | Cloud-Certified in Azure (AZ-900) & AWS (practitioner) | Skilled in Databricks, pyspark, SparkSQL and ADF
6 个月Could you please provide rollback plans and logfile location for this patching activity
AWS | Oracle | Enthusiastic learner
1 å¹´In oracle cloud infrastructure What are tge rollback actions for dbcs patching? IF the dbcs patching fails what action should consider? I have DR in dbcs with 2 node. I want to perform patching on that DR?? Does anyone have any idea regarding patching rollback in dbcs?? What should I consider while applying patch on the DR with 2 node jn the dbcs? Please comment your thoughts on this... #oci #dbcs #dbcspatching #patchingrollback #oraclecloud
Senior Consultant at Winfo
1 å¹´Hi Anil, Could you please help us in illustrating for applying the RU patch(19.16 to 19.20) on Datagauard environment DB systems in OCI. what happens when we click on APPLY in OCI Console. Do we need to apply patch primarily on ?physical standby database or on the Primary. Thanks to clarify.