Infrastructure at your Service

Oracle Enterprise Manager Cloud 12c 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

How to rename listener target in EM Cloud 12c ?

By | Database Administration & Monitoring | No Comments

Sometimes it is necessary to rename targets in Enterprise Manager Cloud Control 12c. In my case I have listener targets discovered by EM12c with the hostname at the end of the target name: TESTDBA_LSN_dbserver1 As I work in a Veritas clustered environment, when the target switches to the other node (dbserver2) the listener target is relocated, but its name is always TESTDBA_LSN_dbserver1. How to rename a listener target in EM Cloud Control 12c? We use…

 
Read More
Pierre Sicot

Querying the Oracle Management Repository

By | Database management | No Comments

The Enterprise Manager Cloud Control 12c is an amazing tool allowing the DBA to display a lot of informations from the console . But there are also a lot of repository views that may be consulted by the DBA to build a lot of various reports. The Oracle Management Service collects a huge amount of raw data from the agents installed on each managed host you administer with EM 12c. Those raw data are inserted…

 
Read More
Pierre Sicot

Oracle Compliance Standard

By | Database Administration & Monitoring | No Comments

In Enterprise Manager 12c, using the compliance standard results might be a good solution for DBA’s to detect security incoherences (for example a lambda user who has the sysdba role …) for their various targets. From the 12.1.0.3 version, a new column named ‘Required Data Available’ appeared in the Compliance Standard Result screen. This column defines if the data for the compliance evaluation rules for each target are in the repository or not. If the…

 
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

statistics_level parameter

By | Database management | No Comments

With Enterprise Manager Cloud Control 12c configuring and using the compliance standard utility allows us to discover events we should not have seen in other ways. Today at a customer’s site I discovered the following message:   The configuration Best Practice for Oracle Database discovered the statistics_level parameter was set to the value ALL.   By selecting the Violation in the Configuration Best Practice for Oracle Database, we can display the message:     By…

 
Read More
Franck Pachot

Oracle cloud control / SQL Details / Statistics

By | Database management | No Comments

A question that I had several times: in Enterprise Manager, in the screen about one SQL statement, the ‘statistics’ tab shows the number of executions, elapsed time, etc. Question is: which time window does it cover? There is a one hour chart above, and two timestamps displayed as ‘First Load Time’ and ‘Last load Time’, and we don’t know which one is related with the execution statistics numbers. I’ll explain it clearly on an example….

 
Read More
Pierre Sicot

Oracle Cloud Control 12c: removing an agent is much easier in OEM 12.1.0.4

By | Database management | 10 Comments

To remove an agent in the previous Oracle OEM Cloud Control 12c versions, you first had to delete its targets, stop the agent, and remove the host target. Only then were you able to remove the agent. In version 12.1.0.4, the decommission agent feature has been greatly improved. From the agent menu, you select the new feature Agent Decommission: The agent must be in stopped status to be decommissioned: It shows the targets which will…

 
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
Gérard Wisson

Day 2 at Oracle Open World – best practices for WebLogic & Cloud Control

By | Application integration & Middleware | No Comments

Today, in this post I will describe some Oracle WebLogic and Cloud Control best practices I have learned in the last sessions. It’s always good to see what is advised by other people that are confronted with other or the same challenges.   Managing Oracle WebLogic Server with Oracle Enterprise Manager 12c One session was related to the best pratices for managing WebLogic with Cloud Control 12c. Use the administration functions: Now you can, with…

 
Read More