This is Part III in a multi-part series, demonstrating how to take EM12c from out of the box to enterprise level. You can read Part I and Part II to complete the first phases of this setup and look for future posts in this series to ensure your EM12c is set up to support your database world. Monitoring Templates Monitoring templates, when created via an example database and then used as the default for all databases, allows the DBA control to create incidents and notify on what metrics are important to the business. Creating a Template As templates are…
-
-
This is part II of the series on effective monitoring with EM12c. You can read Part I of this series to ensure you have the complete setup for your Enterprise Manager 12c for effective monitoring and notifications. Groups and Administration Groups There are two different features that can be used to assign targets to groupings to ease management. Groups were introduced early on and Administration Groups is new to EM12c. Although Administration Groups is the newer feature, it is limited to one escalation type, as a target can only belong to one administration group and notification type. Administration Groups predecessor,…
-
This is the last week for RMOUG Abstract Submissions for Training Days 2014! Last day is Aug. 31st and we want your abstract to show us all you know and how much everyone else can learn from you! I’m thrilled to announce I have a great conference committee and we are on the road to a fantastic event this February, but we can’t do it without you, the great speakers of the Oracle Community. Submit your abstract today and don’t be left out on all that RMOUG Training Days has to offer. If you are a seasoned speaker, you know how great…
-
Effective Monitoring This is going to be a five part series discussing how to set up EM12c effectively and productively so DBAs are offered critical alert notification and the ability to manage the environment through the incident manager in a (possibly) different way than first conceived. For any DBA who serves an on call schedule, the importance of receiving pages that are production critical outages and contain no “white noise” is essential to your success and your sanity. Its been a goal that Enkitec has been striving towards regularly and I can attest to this as a Remote DBA I’ve…
-
I have a number of sessions going on the week of Oracle Open World and figured I better get some info out there with it just over a month away! My main sessions, along with others offered by my phenomenal, fellow Enkitec folks can be found here. I have also traded in my technical session at Oak Table World for two WIT, (Women in Technology) sessions. The wonderful Kyle Hailey has built us a great web site to promote it and we’ve got Oracle’s support as we bridge between Oak and Oracle for these two exciting sessions where the women…
-
Post a recent migration to consolidate a number of new databases to one of my client’s Exadatas, I found myself staring at a familiar wait event on one of them that I run into way too often when hopes of Exadata migration performance glory is reviewed. Where, with all the features that are available to the consolidated database to perform more effectively on Exadata, Temp usage just isn’t one of them. Many know that I’m a proponent of ensuring design and code is as efficient as possible to not “over run” PGA allocation per session and “swap” over to temp.…
-
Didn’t know that was the name of a little know feature in 11g, eh? OK, so I may have named it that, but this is where I’m at right now with dynamic sampling at many of the shops I’ve worked at. I know it’s due to the common sizes and types of databases I’ve worked on, too. Many of them have unique hybrid databases that require unique solutions. These databases often have both transactional and ETL processing/reporting, along with adhoc queries from GUI tools. For best results we’ve implemented the following in most of them: 1. Throughout ETL loads, I work…
-
Thanks to everyone that tuned in for Redgate’s All things Oracle Webinar I did on Database 12c today. I know we went way over on time and appreciate everyone staying on for the extra time as we went through and demo’d how many ways we can create, copy and clone DB12c pluggable databases. As promised, here’s the demo playbook and the links to the Virtualbox image with the DB12c installation files on it. You will need to do the following to set everything up: 1. Set the host name in the /etc/hosts file, (in case you want to rename your…
-
I will be presenting another webinar with my good friends at Redgate this Wednesday, July 17th on the new Database 12c feature, Pluggable Databases. This session will be one hour, but will include a live demo on the pluggable database feature. Seats are limited and I know in just one week, over 500 have already registered, so if interested, register here! See you on Wednesday and thanks!
-
So for those of you that aren’t going to be “deep diving” soon, there will be two interfaces for creating a pluggable database- a GUI or through a CLI and for many, the former is going to be the choice as we ascend into DB12c land. Many are still asking why we even want to go the pluggable database route, “What’s all the fuss?” The concept is easy for any MSSQL DBA to comprehend- they’ve had a lot of the feature set in place for quite some time as we detached and attached SQL Server databases since version 7. So what…
-
As we all know, it’s always the little things that come back to bite us when we are working with our own VM setups. I’m using the newest Oracle Virtualbox 4.2.16 and have been quite happy with my new Linux6 installation. I configured my listener and was ready to work with EM Express, but when logging in, received the error that I needed Adobe Flash Player to proceed. Strange thing was, I was quite aware of this and had already updated it. Just for the fun of it, I tried again, and was told that it was already installed…which means…
-
I returned home last night after a week in the great city of New Orleans for ODTUG’s KSCOPE 2013. We arrived last Thursday, Tim is a director on the board, so were picked up from the airport in grand fashion and were delivered to our lovely suite at the hotel- ODTUG making sure we were all well cared for. This is one of three conferences that Enkitec has a booth at. I am very fortunate to work for a supportive company that includes RMOUG in that list, but know that KSCOPE, a very developer oriented conference is one of those…
-
I will be presenting this next week at KSCOPE 2013. I have a number of presentations, both technical and WIT, (Women in Technology) related. My main presentation can be found listed with my speaker bio And the WIT panel, although a bit out of date, (our line up has changed a little…) is here. I just forwarded my Imposter Syndrome slides onto Maria Colgan so she can review them and let me know what she thinks. It’s a subject that seems to be very near to any successful woman’s heart, but what really surprises me is how many men I…
-
The idea of providing databases as a service to customers and companies can be a very foreign idea to the database administrator. The DBA’s job is to carefully control and dole out resources. The concept that “in the cloud” the user can just “order up” a database on demand is a difficult one. How does it work? Infrastructure First, the a cloud-based Paas Infrastructure zone must be created. Without this, the plug-in for the “database as a service” will function. Once this is setup, then the “Database for a Service” can be completed. The DBA must create a couple users for…
-
As many know, I joke about being a strange, ADHD kid. I didn’t really fit in with the other kids and was really, really small for my age. I was bullied and very much a loner. Growing up, my closest friend was my middle sister, Kristi who is 2 1/2 years younger. She was the golden child- blond hair, blue eyes and very, very sweet. She was so easy-going that she was often frustrated by other kids, so my easy-going, but, hyper personality was preferable to them and we were happy to hang out together. We grew up in a…
-
How many performance specialists have experienced projects where reporting was horrid in the beginning, maybe didn’t even complete? The focus of the project may have sat with data loads or due to the data architect’s design specialty, etc., the reporting aspect was just the last thing on everyone’s mind until it was too late. I come into this conversation with companies all the time and it is a difficult one, as there are so many database myths. “Can’t you just do something to make the database go faster? I don’t know, isn’t there a parameter that can be updated, maybe…
-
I won’t apologize to Oracle for saying that the new Incident Manager has some quirks to it, but it does, especially when it comes to managing incidents, events and how to clear out both. I’m going to attempt in this post to explain how to check to see if you have alerts that can be cleared with an EMCLI command and then also take you through clearing out from the GUI, which is available in the Release 2 of EM12c. If you want to know what kinds of stateless alerts that can be cleared manually, then once logged into the…
-
As many of you know, the WIT Session at RMOUG and subsequent planning for a WIT program has been very successful. I just received my evaluations, as this was offered just like any technical session. There was a wonderfully, honest comment that I hope the author will not mind me sharing anonymously and I hope my response will help her in return. “to be honest, if I could [do] it all over again, I wouldn’t be a DBA. I have a degree in CIS, computers were the in thing when I was in college. I chose CIS for the money…