Last week, I was letting you know about an opportunity to hear all about the Snap Clone functionality with EMC storage. This week, there’s a similar presentation on Wednesday, March 4 at 8AM PT (San Francisco), 11AM ET (New York), 4PM GMT (London) and 5PM CET (Paris), only this time we’re discussing Snap Clone with NetApp storage instead.
To register, go to this link.
I was recently asked to help a customer set up File Monitoring in Enterprise Manager and I thought since I haven’t blogged in a while, this could be a good way to start back up again..
Enterprise manager 12c provides a very nice Compliance and File Monitoring Framwork. There are many Built in Frameworks include for PCI DSS and STIG but this How-to will only focus on a custom file monitoring framework.
Many thanks to all those who attended my session "SQL Tuning without Trying" at Oracle Open World 2014 #oow14. I hope you found the session useful.
If you want to download the slide deck, here
it is. As always, I would really, really like to hear from you.
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 (126.96.36.199) installation which consists of two OMSes, running (more...)
Original Post can be viewed at Upgrade Enterprise Manager Cloud Control 188.8.131.52 to 184.108.40.206
Oracle released 220.127.116.11 Enterprise Manager few days back and have released it for most of platforms. You can directly upgrade Enterprise Manager Cloud Control 12c Release 1 (18.104.22.168) [with or without Bundle Patch 1] to 22.214.171.124 There are no pre patches required for this. But this upgrade requires considerable downtime. Oracle has termed this upgrade [...]
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
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...)
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...)