Infrastructure at your Service

Oracle Enterprise Manager Archives - Blog dbi services

Pierre Sicot

Upgrade to Enterprise Manager 13.2

By | Database Administration & Monitoring | 2 Comments

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 the following point: – you have to use Oracle Interim Patch Installer version 12.2.0.1.8 Once…

 
Read More
Pierre Sicot

UKOUG 2016 Day 2

By | Database Administration & Monitoring | No Comments

Today I assisted at a first session about one of my favorite tool: Upgrade to EM 13c now. The session was presented by Phil Gric from Red Stack Tech. At the begining he described us the most common mistakes while implementing Enterprise Manager: – EM 13c is an enterprise application – It is a critical part of your infrastructure – it is designed to help you – EM 13c is not a glorified db console…

 
Read More
Pierre Sicot

Enterprise Manager 13.1.0.0 does not display correct values for memory

By | Database Administration & Monitoring | No Comments

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      44762       3512          0        205      37483 -/+ buffers/cache:       7073      41201 Swap:         8189       2397       5791 Em 13c…

 
Read More
Pierre Sicot

EM13c and postgres plugin

By | Database Administration & Monitoring | No Comments

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 the Blue Medora plugin for EM13c, you have to unzip it: oracle@vmtestoraCC13c:/home/oracle/psi/ [rdbms12102] unzip bm.em.xpgs_12.1.0.2.0_2.0.3.zip…

 
Read More
Pierre Sicot

EM 13c corrective actions

By | Database Administration & Monitoring | No Comments

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 your corrective action as it has been created as a draft version, you select Publish….

 
Read More
Pierre Sicot

EM13c Gold Agent Image

By | Database Administration & Monitoring | 3 Comments

One of the most interseting new feature in Enterprise Manager 13c is the Gold Agent Image. This new feature will simplify the agent management. The first thing to do is to create a Gold Agent image, from the setup menu , select Gold Agent Image: Then select Manage All Images: Select Create Enter the image name, a description and the platform name, then submit: Your gold image is created: Before to subscribe an agent, we…

 
Read More
Pierre Sicot

EM13c and Management Pack Annotations

By | Database Administration & Monitoring, Database management | No Comments

Enterprise Manager 13c offers a new feature allowing displaying the management packs used by a feature. To enable the Management Pack Annotations, you select Enable Annotations from the Setup Menu –> Management Pack: From now on your menus are filled up with acronyms more or less comprehensive, from a performance page on a target database:   From now on your menus are filled up with acronyms more or less comprehensive, for example from a performance…

 
Read More
Pierre Sicot

Enterprise Manager 13c and BI Publisher

By | Database Administration & Monitoring | One Comment

In Enterprise Manager 12c, if you need to display the database storage, from the report menu you have the following possibilities: From now on, with Enterprise Manager 13c, this possibility does not exist anymore in the report menu, you have to use the BI publisher feature. If during the EM13c installation phase, you choose not to configure BI publisher, you will see the following message while trying to access the BIP page: If you have…

 
Read More
Pierre Sicot

Always-on Monitoring EM 13C

By | Database Administration & Monitoring | No Comments

As the Enterprise Manager Cloud 12c is configured for sending warnings and alerts if a target database is down, what’s happening if the Enterprise Manager Repository database crashes? With Enterprise Manager Cloud Control 12c, a quite good solution is available: after an easy configuration, the management agent is able to run script to notify database administrators there is a problem with the repository. But what happens if the OMS itself is down? Enterprise Manager 13c offers…

 
Read More
Pierre Sicot

EM 13c target is fully broken !!

By | Database Administration & Monitoring | One Comment

At a client’ site I decided to install the Enterprise Manager Cloud Control 13c. I did not encountered any special problem :=) , then I installed an agent 13c on the development plattform and added targets as usual, but at this timeI discovered that half of my database targets in 11.2.0.3 version were in the following state : 2016-02-05 15:31:46,863 [2527:A154C6AD] INFO – Target: [oracle_database.TESTDBA] is fully broken: Dynamic Category property error (code=0x400) The gcagent.log showed…

 
Read More