Infrastructure at your Service

Oracle Enterprise Manager Archives - Page 2 of 3 - Blog dbi services

Pierre Sicot

EM 13c target is fully broken !!

By | Database Administration & Monitoring | 2 Comments

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
David Schmitt

Oracle EM Cloud Control 12c (CC12c)- Repeat alert notification

By | Database Administration & Monitoring | No Comments

Oracle EM Cloud Control 12c (CC12c) – Repeat alert notification In your EM installation, CC12c will notify your different administrators when specific incidents, events, or problems occurs. But from standard configuration, you will receive only one warning or critical notification/alert … until the Clear or an Acknowledge of the alert. Some times and for different reasons (human error, email was deleted, Mail server issues, …) you can lost or forgot this alert. Hummm this is…

 
Read More
Pierre Sicot

dbsnmp expiring password, manually triggering metrics collections

By | Database Administration & Monitoring | No Comments

When you use Enterprise Manager Cloud control 12c, the monitor username commonly used is dbsnmp. Depending on the Oracle profile used for this user, the dbsnmp password can expire, and as a consequence multiple targets will be seen in a pending status by Enterprise Manager Cloud control 12c. An interesting way to solve this problem is to create a metric extension detecting in how many days the password will expire: You realize the operation as…

 
Read More
Franck Pachot

Query the Enterprise Manager collected metrics

By | Database management, Oracle | 5 Comments

By Franck Pachot . Enterprise Manager (Cloud Control for example) gathers a lot of metrics. You can display them from the GUI, but you can also query the SYSMAN views directly. Today, I wanted to get the history of free space in an ASM disk group for the previous week. Here is how I got it. Enterprise Manager metrics are aggregated in MGMT_METRICS_1HOUR (granularity 1 hour, retention 1 month) and MGMT_METRICS_1DAY (granularity 1 day, retention…

 
Read More
Pierre Sicot

Oracle OEM Cloud Control 12c upgrade to 12.1.0.4

By | Database management | 2 Comments

In this blog post, I will describe how to upgrade from Oracle Enterprise Manager Cloud Control 12.1.0.3 to OEM 12.1.0.4.0. I have already described the main new features of Cloud Control 12.1.0.4 version in an earlier post (Oracle OEM Cloud Control 12.1.0.4 – the new features). The first pre-requisite is to apply the patch 11061801 on the repository database in 11.2.0.3 version, using the classical opatch apply method. Then, we can begin the upgrade phase….

 
Read More
Franck Pachot

Oracle EM agent 12c thread leak on RAC

By | Database management, Oracle | 4 Comments

By Franck Pachot . In a previous post about nproc limit, I wrote that I had to investigate the nproc limit with the number of threads because my Oracle 12c EM agent was having thousands of threads. This post is a short feedback about this issue and the way I have found the root cause. It concerns the enterprise manager agent 12c on Grid Infrasctructure >= 11.2.0.2 NLWP The issue was: ps -o nlwp,pid,lwp,args -u…

 
Read More
Arnaud Berbier

Oracle Open World 2013: Day four – Oracle WebLogic Server management

By | Technology Survey | No Comments

Today, I went to a session on Oracle WebLogic Server management. It was about the challenges of the application infrastructure to deliver a high quality of services in the cloud. The main goal is to optimize production and efficiency through automated management and administration. The speakers were David Cabetlus (Senior Principal Product Manager Oracle) and Glen Hawkins (Senior Director of Product Management Oracle). The session had two parts: Oracle WebLogic Server and Oracle Enterprise Manager…

 
Read More
Pierre Sicot

Oracle Database 12c: Oracle OEM express

By | Database management | No Comments

Together with Oracle Database 12c, Oracle has introduced a new administration console named Oracle Enterprise Manager Express (Oracle OEM Express). This “light” version of Enterprise Manager Database Console – which is not supported in Oracle 12c anymore – is a management product built into Oracle Database 12c. There is no installation or management required, the database creation with dbca enables OEM Express and gives you the URL connect string. As there is no mid-tier or middleware…

 
Read More
Yann Neuhaus

Oracle Enterprise Manager 12c: creation and management of administrators through emcli

By | Database management | No Comments

Cloud Control 12c (and the former Grid Control 11g) offers the possibility to create administrators and manage their privileges through the “emcli” command line utility. The main advantage of this method (based on scripts) is to be able to reproduce the creation of the users as soon as a new Cloud Control infrastructure must be built up (for instance in order to migrate Grid Control 11g on Windows to Cloud Control 12c on Linux). Indeed,…

 
Read More
Pierre Sicot

Oracle Enterprise Manager 12c: Administration Groups & Template Collections

By | Database management | No Comments

This document describes the implementation of the
administration groups and template collections with Oracle Enterprise
Manager Cloud Control 12c.

 

Administration Groups (improvement of Grid 11g Target Groups) and Template Collections improve the management of targets and ease the monitoring strategy.

 

Administration Groups allow to organize targets according to several criteria. For instance the Lifecycle status of the target (prod, dev, integration), the location of the target can be used as criteria. The main goal is to apply common settings (i.e monitoring settings) to targets having the same purpose.

 

The first point about administration groups is to define a clear concept and the hierarchy between these several criteria. The administration groups must be organized in a convenient way according to the company organization. In the next chapter we will present how to handle the hierarchy existing in Cloud Control 12c in order to change it in an administration group organization fitting to the company structure.

The target property is used to implement automatically the target in the appropriate administration group.

 

 
Read More