This issue can be seen in either EM12c or EM13c AWR Warehouse environments. It occurs when there is a outage on the AWR Warehouse and/or the source database that is to upload to it. The first indication of the problem, is when databases appear to not have uploaded once the environments are back up and running. The best way to see an upload, from beginning to end is to highlight the database you want to load manually, (click in the center of the row, if you click on the database name, you’ll be taken from the AWR Warehouse to the…
-
-
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…
-
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…
-
As I’m playing with the AWR Warehouse in EM13c, I noticed a few changes that may send up a red flag and wanted to assist in removing those. As many know, the AWR Warehouse is very dependent upon EM Jobs…even more so now that we’ve moved to EM13c. The EM Job System has gone through quite an overhaul, so let’s go through how this may impact what you’re common to seeing when adding a database to the AWR Warehouse. Discovery After adding a database to the AWR Warehouse in EM13c, you’ll note within just a few minutes, the database will…
-
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…
-
This question was posted in Twitter from @matvarsh30, who asked, “How can I display CPU usage over different periods of time for databases in Enterprise Manager?” Everyone loves their trusty Top Activity, but the product’s functionality is limited when it comes to custom views and this is what our user had run into. There are numerous ways to display this data, but I’m going to focus on one of my favorite features in the product that was created to replace Top Activity, ASH Analytics. Retaining AWR Data for ASH Analtyics Note: This process to display CPU graphs will work for…
-
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…
-
The only thing that is constant is change. There were some major changes to Enterprise Manager with 13c and many of them may seem small to someone who knows the product well, but then again, it may trip you up as you’re accustomed to features working as you knew them in EM12c. One of these features is the manual edition of targets through the guided process. Adding a Target The Setup menu is still on the right, it just has some company now in the new EM13c interface: Click on Setup, Add Target, Add Targets Manually. This is where the…
-
As I patiently wait for approvals to post my Oracle Management Cloud blog posts, I thought I would just post on Enterprise Manager 13c and answer questions that have been posed to me via email and comments. Is there anything new I need to watch for as I install EM13c? Your management repository database should be a single-tenant 12.1.0.2 database. Disable adaptive_features parameter in the database you will use for your repository. Update the /etc/security/limits.conf file to set soft nofiles to 30000 from previous common setting of 8192 session_cached_cursors parameter should be set to 500 Even though it may warn you…
-
I’m thrilled to see the outpouring of support for EM13c already out with it just being announced on Friday! As technologists all over the world jump in and start installing the newest and greatest version of Enterprise Manager, there is a second group already working on the task of upgrading their existing EM12c environments, (seen a few already, including one from Gokhan!) Along with other requirements, like setting optimizer_adaptive_features set to false, there is pre-requisite that I’d like to recommend that everyone perform on any EM12c environment before endeavoring on an upgrade- do a health check with EM Diagnostics. Enterprise…