Complément : EM12c pour mettre en place une solution MWaaS

Complément : AWR Warehouse (ODTUG Webinar)

Integrate BI-Publisher with OEM12c

Regularly I create VM's for courses as a 'Virtual Course Environment'. Earlier I did an install of Oracle Enterprise Manager 12c. But now there was a request for an integrated BI Publisher install.

Having an OEM12c install, the integration with BI Publisher with OEM12c is pretty straightforward. The install guide (more...)

EM12c upgrade from to

Now that Oracle Enterprise Manager Cloud Control 12c Release 3 (aka EM12cR3!) has been out for a few weeks, I decided to brave it and upgrade our Production stack today. In this post, I’ll be upgrading an EM12cR2 ( installation which consists of two OMSes, running (more...)

Automatically purging OMS log and trace files in EM12c

Enterprise Manager Oracle Management Server (OMS) installations generate huge amounts of log and trace files under the covers these days, and although the logs are rotated out-of-the-box, they’re not automatically deleted.  Over time (as I was reminded again today ), these logs can amount to a large portion of your (more...)

Changing the heap size of Enterprise Manager 12c

Enterprise Manager 12c is a product that is being deployed a lot lately, a vast improvement over previews version. For most DBA’s it is a tool they use regularly on a daily basis so performance is key. Fortunately oracle provides us with some documentation on how to size the repository database and heap size of the Oracle Management Service. An excellent white paper on EM12c sizing can be found here on OTN:

Interestingly enough it states that Oracle considers installation with +1000 targets as a medium sized em12c environment. That limit of +1000 targets is reached (more...)

Upgrade Enterprise Manager Cloud Control to

Original Post can be viewed at Upgrade Enterprise Manager Cloud Control to

Oracle released Enterprise Manager few days back and have released it for most of platforms. You can directly upgrade Enterprise Manager Cloud Control 12c Release 1 ( [with or without Bundle Patch 1] to There are no pre patches required for this. But this upgrade requires considerable downtime. Oracle has termed this upgrade [...] Weblog

ORA-00942 Querying Tablespaces from Enterprise Manager

In order to meet the minimum security requirements, the SYSTEM user use must be restricted, only the actual DBA must have access to it. Other users requiring access to Enterprise Manager to monitor and "view" must be granted especific minimum privileges.
The SELECT_CATALOG_ROLE and the CONNECT roles are good enough to see most of the E.M. contents, but when trying to access the Tablespaces page from Enterprise Manager the ORA-00942 error shows up.
When tracing I discovered the query used to fill up the Tablespaces Page:

SELECT /*+first_rows */ d.tablespace_name, NVL(a.bytes / 1024 / 1024, 0), DECODE(d. (more...)

Tablespace 195% Full … must be the metric system

I was recently refreshing a test database with production data (using datapump if anyone cares) and had forgotten to check the tablespace sizes between prod and test. During the load, I obviously ran out of space. A quick check in prod showed I needed 4GB of space. The test tablespace was set to grow to 2GB max. To add space, I performed a simple command to add the space.

ALTER DATABASE DATAFILE '/u01/oracle/data01/blah.dbf' RESIZE 8GB;

I resumed the datapump and went on my merry way. A few minutes later I received an email from Grid Control that the tablespace (more...)