DBA Kevlar

Tips, tricks, (and maybe a few rants) so more DBAs become bulletproof!

Note Pro 12.2 Review- Officially Drove Me to Apple!

I am a long time supporter of Samsung products- I’ve always had Samsung phones, (currently a Note 3 owner…) Samsung TVs, monitors and even have a Samsung microwave and refrigerator. I love Samsung products and this has included my tablets, recently deciding to upgrade my Samsung Note 10.1, (original) for a Samsung Note Pro 12.2. […]

EM12c Release 4, Private Roles

Until OEM11g, it was very common that all folks were either Super Administrators or Administrators and only a few shops took the time to create roles outside of these two essential roles.  Super Administrator, (SA) was pretty straight forward-  the SA had essentially the same access as the repository owner and should only be allocated […]

EM12c and Hardware

I often hear, “My EM12c environment is slow!” and I just as often am granted access to the environment and find out that EVERYTHING is running on an old single core server with 2Gb of RAM someone found lying around.  Enterprise Manager is often an after thought to many IT organizations.  After all the work […]

KSCOPE 2014, Seattle!

Just a blog post on the great conference coming up at the end of the month from ODTUG, KSCOPE 2014.  The conference will be held in Seattle, Washington this year, (yeah, look forward to cooler temperatures than last year in New Orleans KSCOPE 2013… :)) I’ll be heading up the Database Track and the Women […]

EM12c Rel. 4, the Security Console

Why is the Security Console an important new feature?  I was contacted by three people just this last week on how to secure an EM12c environment.  How many of you are still logging in to the EM12c console or CLI with the SYSMAN account? Bad DBA, BAD!!  Security Console The Security Console helps the administrator […]

The *New and Improved* Extensibility Exchange is Here!

How many of you use Oracle Enterprise Manager 12c, recognize it can do so much more than just taking it out of the box and plugging it in, then proceed to start building metric extensions, plug-ins, writing EM CLI scripts, etc? How cool would it be if you could peruse a library of plug-ins to […]

AWR Warehouse in EM12c, Rel 4, Part II

So, there is a lot to cover on this topic and I hope Part I got you ready for more!  Part II, I’m going to cover the following areas of the AWR Warehouse: Installation Access ETL Load Process Installation Let’s start with Prerequisites: The AWR Warehouse Repository must be version 11.2.0.4 or higher. The Targets […]

AWR Warehouse in EM12c Rel. 4

I know a number of us performance tuning DBAs who’ve long wanted to retain AWR data, at least high-level AWR data for an extended period outside of the AWR repository on the local database. I implemented my own solution back in 2009-2010 at a previous employer as I was tired of hearing, “nothing’s changed”.  Nothing […]

Installation of ASH Analytics with EM12c Rel4

If you have the Diagnostics/Tuning Management Packs and EM12c, you should be installing ASH Analytics to get the full benefit of optimization data that is available via the AWR and ASH. ASH Analytics is the future of the Top Activity view and I’ve written a number of posts on the value of the ASH Analytics […]

The DBSNMP Account and User

I talk a lot about Enterprise Manager 12c, from the OMS all the way to the EM CLI and the Agent, but I was discussing some interesting history with the account used by the OEM Management Agent- the DBSNMP account. The origination of the DBSNMP account was to support Oracle SNMP, (Simple Network Management Protocol.)  […]

Previous Posts Next posts

  • Facebook
  • Google+
  • LinkedIn
  • Twitter