OCI Cloud Performance Management for On-Premises Databases – Part 1 – Management Agent Installation

The OCI Management Agent service collects data from services and sources for monitoring and management in Oracle Cloud Infrastructure. In this blog post series I will show you how you can monitor and manage an on-premises Oracle databases in OCI. The communication between an agent and OCI requires an Agent Install Key and is based on HTTPS. Service Plugins extend a Management Agent for example for Oracle database performance monitoring and management or log analytics. This is a small blog post series Part 1 shows the installation of the Management Agent on an on-premises system Part 2 describes how to manage this Oracle database in OCI Part 3 watches behind the scenes for billing, job execution etc. My Setup An…

Read More

Patching a DBaaS Database in the Oracle Cloud

To apply a Patch on a Database which is hosted by Oracle is done with one mouse click. This service is available only if you have selected the full database service during the DBaaS order process. To the manual: https://docs.oracle.com/cloud/latest/dbcs_dbaas/CSDBI/GUID-50BDEF7D-A30E-4B32-BAE7-486538413E2D.htm#CSDBI3422 Patchset Availability As soon as a new Oracle patchset is available, you can see that in the database management dashboard of the selected database. The precheck function verifies if the selected database is ready to patch. Precheck Result After 2 until 3 minutes and a refresh of the page you see the result.               Command Line Interface dbpatchm If you have no web access, all these steps can be executed manually in the shell.…

Read More