I know Werner DeGruyter will like the title of this post, so here’s a post dedicated to him as my last week at Oracle is off to a busy start…. 🙂 As I attempt to wrap up any open tasks at Oracle, I’m still Training Days 2017 Conference Director for RMOUG, have a planning meeting for the 800 member Girl Geek Dinner Boulder/Denver Meetup group that I’m the owner of, designing the booth and building out all the projects for the MakerFaire event at the Denver Science Museum next weekend and now have taken on the Summer Quarterly Education Workshop at…
-
-
Change is difficult for technical folks. Â Our world is always moving at blinding speed, so if you start changing things that we don’t think need to be changed, even if you improve upon them, we’re not always appreciative. Configuration Management, EM12c to EM13c As requests came in for me to write on the topic of Configuration Management, I found the EM13c documentation very lacking, having to push back to EM 12.1.0.5 to fill in a lot of missing areas. Â There were changes to the main interface that you use to work with the product. When comparing the drop down, you…
-
A lot of my ideas for blog posts come from questions emailed to me or asked via Twitter.  Today’s blog is no different, as I was asked by someone in the community what the best method of comparing databases using features within AWR when migrating from one host and OS to another. There is a  lot of planning that must go into a project to migrate a database to another host or consolidate to another server, but when we introduce added changes, such as a different OS, new applications, workload or other demands, these need to be taken into consideration.…
-
The OMS Patcher is a newer patching mechanism for the OMS specifically, (I know, the name kind of gave it away…) Â Although there are a number of similarities to Oracle’s infamous OPatch, I’ve been spending a lot of time on OTN’s support forums and via email, assisting folks as they apply the first system patch to 13.1.0.0.0. Â Admit it, we know how much you like patching… The patch we’ll be working with is the following: Patch 22920724: enterprise manager for oms plugins 13.1.1.0.160331 Before undertaking this patch, you’ll need to log into your weblogic console as the weblogic admin, (you…
-
Someone pinged me earlier today and said, “Do I even really need to know about logs in Enterprise Manager?  I mean, it’s a GUI, (graphical user interface) so the logs should be unnecessary to the administrator.” You just explained why we receive so many emails from database experts stuck on issues with EM, thinking its “just a GUI”. Log Files Yes, there are a lot of logs involved with the Enterprise Manager.  With the introduction back in EM10g of the agent, there were more and with the EM11g, the weblogic tier, we added more.  EM12c added functionality never dreamed before and…
-
How much do you know about the big push to BI Publisher reports from Information Publisher reporting in Enterprise Manager 13c?  Be honest now, Pete Sharman is watching…. 🙂 I promise, there won’t be a quiz at the end of this post, but its important for everyone to start recognizing the power behind the new reporting strategy.  Pete was the PM over the big push in EM13c and has a great blog post with numerous resource links, so I’ll leave him to quizzing everyone! IP Reports are incredibly powerful and I don’t see them going away soon, but they have a lot…
-
It’s that time of year again and the massive undertaking of the Collaborate conference is upon us. This yearly conference, a collaboration between Quest, Oracle Applications User Group, (OAUG) and Independent Oracle User Group, (IOUG) is one of the largest conferences in the world for those that specialize in all areas of the Oracle database. The conferene is held in different cities, but recently its been sticking to the great destination of Las Vegas, NV.  We’ll be at the Mandalay, which like many casinos, is like it’s own little self-contained city within a city. The week will be crazy and…
-
Even though I didn’t have the “official” prerequisite classes of HTML and CSS for the JavaScript class offered by sister Meetup group, Girls Develop it, I decided on Friday that I wanted to take the weekend class and signed up. The class is held at the Turing Development school and it was a great downtown location. Â Very centralized, no matter if you’re North, South, East or West of the city and the venue is a school, so it’s set up with plenty of power, WiFi and projector with multiple screens. Â It had started another spring time snow, so I was…
-
I appreciate killing two birds with one stone. Â I’m all about efficiency and if I can satisfy more than one task with a simple, productive process, then I’m going to do it. Â Today, I’m about to: Show you why you should have a backup copy of previous agent software and how to do this. Create a documented process to restore previous images of an agent to a target host. Create the content section for the Collaborate HOL on Gold Images and make it reproducible. Create a customer demonstration of Gold Agent Image AND publish a blog post on how to…
-
As we migrate to the cloud, secured credentials are starting to become a standard in most DBAs worlds. Â If you don’t take the time to understand ssh keys and secured credentials, well, you’re not going to get very far in the cloud. Now ssh keys are a way to authenticate to a host without the need for a password. Â Its far more secure, but takes a little time to set up and comprehension between public and private keys, along with the impact of pass phrases. Private keys shouldn’t be shared, as anyone with access to the private key can generate…
-
This is going to be a multi-post series, (I have so many of those going, you’d hope I’d finish one vs. going onto another one and coming back to others, but that’s just how I roll…:)) As I now have access to the Oracle Public Cloud, (OPC) I’m going to start by building out some connectivity to one of my on premise Enterprise Manager 13c environments. Â I had some difficulty getting this done, which may sounds strange for someone who’s done projects with EM12c and DBaaS. Its not THAT hard to do, it’s just locating the proper steps when there…
-
I’ve been working on a test environment consisting of multiple containers in a really cool little setup.  The folks that built it create the grand tours for Oracle and were hoping I’d really kick the tires on it, as its a new setup and I’m known for doing major damage to resource consumption… 🙂  No fear, it didn’t take too long before I ran into an interesting scenario that we’ll call the “Part 2” of my Snap clone posts. Environment after Kellyn has kicked the tires. In EM13c, if you run into errors, you need to know how to start…
-
I fly out on Sunday for HotSos and am looking forward to giving a joint keynote with Jeff Smith, as well as giving two brand new sessions on Enterprise Manager New Features. Â IOUG’s Collaborate is just a month afterwards, so the spring conference chaos is officially under way. With running the RMOUG conference, Feb. 9th-11th, I think you can imagine what my response was like when I realized how much content I had to produce for HotSos’ two sessions and then another four for Collaborate, plus a Hands on Lab. As focused as I’ve been on day job demands for…
-
With EM13c, DBaaS has never been easier. Â No matter if you’re solution is on-premise, hybrid, (on-premise to the cloud and back) or all cloud, you’ll find that the ability to take on DevOps challenges and ease the demands on you as the DBA is viewed as the source of much of the contention. On-Premise Cloning In EM13c, on- premise clones have been built in by default and easier to manage than they were before. Â The one pre-requisite I’ll ask of you is that you set up your database and host preferred credentials for the location you’ll be creating any databases…
-
I thought this was kind of a cool feature- the ability to send a message to appear to specific or all users in the Cloud Control Console.  I have to admit that I used to like a similar feature in Microsoft/MSSQL to send network broadcast messages to desktops that offered one more way to get information to users that they might be less inclined to miss. Anyone who’s already deployed/upgraded to Enterprise Manager 13c and wanted to search how to use this feature, it’s not well documented, so I’m going to blog about it and hopefully that will assist those that would like to put…
-
There was a question posted on Oracle-l forum today that should have a blog post for easy lookup for folks. Â Regarding your Enterprise Manager repository database, (aka OMR.) Â This database has a restricted use license, which means you can use it for the Enterprise Manager repository, but you can’t add partitioning to it or RAC or dataguard features without licensing those features. Â You also can’t use the diagnostic and tuning pack features available in Enterprise Manager on the repository database without licensing it outside of the EMDiagnostics tool. Â You can view information about the license that is part of…
-
I’ve just returned from another post-RMOUG conference mountain trip and happy to say that another RMOUG Training Days conference has successfully completed. Â It’s a massive undertaking that takes an incredible amount of time from our board of directors, volunteers and Team YCC, our conference support company. Â In the end, it’s all worth it and no one regrets the loss in personal life or family time to put on the largest Oracle regional user conference in the US. As my fourth year as conference director completes, I can look back and see how the conference has changed, how we’ve successfully taken…
-
To assist users as they plan out their upgrades and new Enterprise Manager environments, I wanted to go over a few subtle, but important changes from EM12c, 12.1.0.5 to the newest release, the much anticipated EM13c, 13.1.0.0. EM Processes One of the things you’ll notice when starting an EM12c from the command line is WHAT is started. $ ./emctl start oms Oracle Enterprise Manager Cloud Control 12c Release 5 Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. Starting Oracle Management Server... Starting WebTier... WebTier Successfully Started Oracle Management Server Successfully Started Oracle Management Server is Up The Oracle Management…