In this post I want to share the required steps to discover ExaCC or ExaCS in Oracle Enterprise Manager (EM). I’ll provide as much detail as possible. Make sure your EM is at least on 13.5 RU 16. If not, please apply RU 16 to EM. Follow this link if you want to know how to patch EM. HERE! You need to designate a “monitoring” agent for the discovery. Is recommended that this agent sits outside your Exadata rack and has access to the OCI REST APIs. More information HERE! Make sure this agent has both the Database and the Exadata plugins deployed and is patched to the same RU level as the OMS. H ..read more

In my previous post I showed you how you can create custom metrics in order to monitor a Standby database. Those steps detailed how to ingest (post) metrics to the OCI Monitoring service. click here… In this post I’ll show you how you can list metric definitions and how you can extract metric data from the Monitoring service. This metric extraction is really useful when you need to integrate the Monitoring service with 3rd party tools. Step 1 – Prerequisites Please follow all the prerequisites executed in the previous blog. Step 2 – List Metrics In this step we are going to create the Python s ..read more

Monitoring Oracle Standby Database (Data Guard) has been always a tricky task. Just by the nature of them (the fact that the instance is not open in read-write mode) is hard to gather information about them. Even using specialized tools like Oracle Enterprise Manager requires SYSDBA credentials in order to effectively monitor them. But what about when running them on OCI? Oracle OCI Monitoring service allow us to monitor cloud resources using metrics and alarms. Oracle OCI Monitoring Service Architecture In this post I want to show you how you can create a custom metric to monitor the “Apply L ..read more

This post continues the thread of DevOps and automation for the Oracle Database. During the last couple of months I’ve seen more interest in deploying Oracle Databases on Docker containers. Even more now that Oracle released full support of RAC Databases running on Docker. click here… After you deploy your first Oracle Database on Docker, several questions come into mind; like: How do I monitor the status of the Oracle Database? How do I manage the performance of the Oracle Database and the SQL’s being executed on it? How do I alert on issues on a timely manner? Well, if you have the same qu ..read more

I wanted to create a video series covering the basics of Oracle Enterprise Manager 13c. These series are designed to provide insights on how to install, configure and manage Oracle Enterprise Manager 13.5. This week we are going to cover the patching of Oracle Enterprise Manager 13.5. Oracle Enterprise Manager 13c – Patching Hope this is useful. Thanks, Alfredo The post Oracle Enterprise Manager 13c Series – Patching first appeared on alfredokriegdba.com ..read more

I wanted to create a video series covering the basics of Oracle Enterprise Manager 13c. These series are designed to provide insights on how to install, configure and manage Oracle Enterprise Manager 13.5. This week we are going to cover the installation phase of Oracle Enterprise Manager 13.5. Hope this is useful. Thanks, Alfredo The post Oracle Enterprise Manager 13c Series – Installation first appeared on alfredokriegdba.com ..read more

In a previous post I show you how you can integrate DevOps automation and orchestration tools to provision Oracle databases by leveraging Enterprise Manager (EM) and the Cloud Management Pack (CMP). Once provisioned, databases need to be fully maintained in terms of monitoring but most precisely patching. Patching databases decreases the risk of breach by timely mitigating vulnerabilities, but in can be a daunting task for organizations. Manual patching is time consuming and error prone. Home grown scripts are difficult to maintain and they increase maintenance cost. So the question is, how ca ..read more

Before I start this post I want to give a big shoutout to FeedSpot for ranking my blog in the Top 100 Best Oracle Blogs and Websites. It’s honestly an honor. Since the start of this blog the main goal was and still is to share knowledge with the community. Being an Oracle ACE Alumni and able to share all this information with you is a privilege. If you want to take a look at the list click below. Feedspot list… Going back to this post. Last week RU7 for Oracle Enterprise Manager (EM) was released. In this post I’ll share information on new features that may want you think on applying this RU a ..read more

IT Security is popular topic nowadays! We constantly hear news about data breaches, ransomware, malware, unauthorized access to IT systems, etc. IT organizations are constantly looking to keep their systems, networks and data safe and secure. Today’s blog is about how Oracle Enterprise Manager (EM) can help Database Administrators to secure and harden the Oracle Databases they manage along with the hosts those databases are running on. First things first. I strongly recommend to review the Oracle Database 19c Security Guide. This guide provides guidelines on how to secure the Oracle Database ..read more

In this post I want to show you how Oracle Enterprise Manager 13c using the Cloud Management pack, can be easily integrated with DevOps automation and orchestration tools like Ansible in order to provision Oracle Databases. These can be either single instance, multi-tenant container databases, pluggable databases, schemas or databases running on high availability clusters and Dataguard configurations. EM 13c implements pre-checks, best practices and processes to provision all these configurations in a secure, automated and controlled fashion. We have created an step by step laboratory in the O ..read more