Infrastructure at your Service
Below, I will try to explain, a particular case for the general error : ORA-01555 snapshot too old error.. Normally, when we have this error, we are trying to adapt the retention parameters or to tune our queries. SQL> show parameter undo; NAME TYPE VALUE ———————————— ———– —————————— temp_undo_enabled boolean FALSE undo_management string AUTO undo_retention integer 3600 –extended from 900, undo_tablespace string UNDOTBS1 But, are some scenarios where the above rule is not working . We…
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…
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…
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…
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…
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…
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…
By Franck Pachot . 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…
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…
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….
