I have been recently blogging on how I have setup Oracle Enterprise Manager 24ai lab, installed an agent and finally configured Oracle AI Database Assistant. It’s time for me to test it now. Product evolution AI integration in Oracle Enterprise Manager 24ai was quite evolving rapidly. In a nutshell Oracle AI Database Assistant will help me interacting with OEM with…
I recently wanted to work on Metric Extensions automation, and realized the task was a bit more complicated than I thought. My original idea was to look into the emcli verb list, but I was unlucky. In fact, emcli does not allow you to retrieve information about Metric Extensions. I had to dig further, looking into the Enterprise Manager SYSMAN…
Introduction I wrote this article to show how you can integrate Legacy OEM with your Cloud environment in this case Oracle ExaCC.To have overall view on your Exadata X9M Cloud Infrastructure, statistics related to CPU/Memory/ASM Storage usage. Your on premise monitoring OEM can read data from Oracle cloud using OCI libraries and present them in combination with your standard DB/VMs…
Introduction This is upgrade procedure to release update from 07 Aug 2024. 13.5.0.23 Its also one of prerequisites for integrating OEM with OCI Exadata Cloud@Customer solution available on my other post under this link: https://www.dbi-services.com/blog/exacc-oci-integration-with-oem-13-5-cloud-control-installed-on-premises Patching procedure and process is basically regular with usage of standard OMSPatcher. We updating from version 13.5.0.16 to 13.5.0.23 This update release bring some improvements…
Recently I received errors messages from OEM13c saying too many cursors were opened in a database: instance_throughput:ORA-01000: maximum open cursors exceeded My database had currently this open_cursors value: SQL> show parameter open_cursors NAME TYPE VALUE ———————————— ———– —————————— open_cursors integer 300 I decided to increase its value to 800: SQL> alter system set open_cursors=800; System altered. But a few minutes…
Working on Enterprise Manager 12.1.0.4 version at a client’s site, we would like to know if oracle database target in 18c version could be discovered and monitored, even if Enterprise Manager 12.1.0.4 does not support Oracle 18c database targets. Installing the agent 12c on the target host did not cause any problem, the oracle database 18c discovery ran successfully, but…
Oracle OEM 13c offers the possibility to generate reports about Oracle Database Tablespace Monthly Space Usage. The displayed information is quite useful and display a lot of information: The report displays the details for each month and for each tablespace, but the GUI is sometimes painful: you have a nice report but many tablespaces and many numbers :=(…
As the last Enterprise Manager Cloud Control 13.3 is out since a few days, I decided to test the upgrade procedure from the Enterprise Manager Cloud Control 13.2 You have to follow some pre-requisites: First you copy the emkey : oracle@localhost:/home/oracle/ [oms13c] emctl config emkey -copy_to_repos_from_file -repos_conndesc ‘”(DESCRIPTION=(ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=em13c)(PORT=1521)))(CONNECT_DATA= (SERVICE_NAME=EMREP13C)))”‘ -repos_user sysman -repos_pwd manager1 -emkey_file /home/oracle/oms13c/sysman/config/emkey.ora Oracle Enterprise Manager Cloud…
I will describe how to upgrade Enterprise Manager 13.1.0.0 to the new 13.2.0.0 version. At the beginning we have to ensure that we applied the latest PSU on the repository database. It is mandatory to apply the following patch before upgrading to Enterprise Manager Cloud Control 13.2.0.0: DATABASE PATCH SET UPDATE 12.1.0.2.160419 To install the patch you have to check…
I recently had problems with Enterprise Manager 13.1.0.0, receiving such alerts: EM Event Critical hostname Memory Utilization is 93,205 % crossed warning (80%) or critical (90%) When we have a look at the EM 13c console for the host: On the system the free -m command displays: oracle@host:~/24437699/ [agent13c] free -m total used free shared buffers cached Mem: 48275 …
As an Oracle DBA I use Enterprise Manager to monitor Oracle databases at my client’s sites. I also administer more and more Postgres databases. I decided to download the Blue Medora plugin in order to monitor the postgresql databases with Enterprise Manager 13c, and to avoid to have different monitoring tools for each kinf of database. Once you have downloaded…
With Enterprise Manager 13c, we have the possibility to define corrective actions. Let me show you how to use it. From the Enterprise à Monitoring select Corrective Actions : Choose Add Space to Tablespace in the Create Library Corrective Action : Enter the name, a description and choose Metric Alert as event: Finally choose to Save to Library You have to publish…
