Infrastructure at your Service

All Posts By

Pierre Sicot

Pierre Sicot

UKOUG 2016 DAY 3

By | Database Administration & Monitoring | No Comments

Today at UKOUG 2016, the Cloud has won against the sun :=) The first sesssion I attended this morning was animated by Kamil Stawiarski from ORA 600 company: Securing the database againt Unauthorized attacks, but the real title was Oracle Hacking Session. The session was amazing, as usual with Kamil, no slides , only technical demos :=)) He first showed us that after creating a standard user in an Oracle database with the classical privileges…

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

UKOUG Super Sunday

By | Database Administration & Monitoring | No Comments

Today at the UKOUG Super Sunday in Birmingham, I had the opportunity to assist at interesting conferences. The first presentation was about Oracle RAC internals and its new features in version 12.2.0.1 on Oracle Cloud. The main new features concern the cache fusion, the undo header hash table, the leaf nodes, and the hang manager. In 12c release 2 in a RAC environment, the cache fusion automatically chooses an optimal path; the cache fusion collects…

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: [email protected]:~/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 | 3 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: [email protected]:/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 | 2 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 | One Comment

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