I’ve been studying for over a week for my certs. It really is a challenge for my ADHD brain, as I learn by interacting and using a product, not be reading about it and guess what? Most of what the certs are on are not in my technical area. Yeah, this is not fun for me. I find that my brain hits a limit on what it can absorb before the activity levels in the temporal lobes diminish and I need to take a break, which is what I’m doing right now after a full day of Azure Synapse Analytics,…
-
-
Per Oracle documentation, you’re able to upgrade from EM12c to EM13c, including the OMR, (Oracle Management Repository) to DB12c and the OMS, (Oracle Management Service) to EM13c, but leave the agent software at a version of 12.1.0.3 or higher, leaving upgrades of the agents to be performed later on using the Gold Agent Image, removing a lot of work for the administrator. This is a great option for many customers, but what if your existing EM environment isn’t healthy and you need to start fresh? What options are left for you then? I’ve covered, (and no, it isn’t supported by…
-
Enterprise Manager does a LOT. Sometimes it may do too much. Customers on forums, on support or via email and social media may come to us asking how to address something they view as not working right and the truth is, we could simply answer their question, but they aren’t using the right tool to accomplish what they’re attempting. The Export Feature in Enterprise Manager A customer was frustrated as he was performing scheduled exports using the export utility that can be found under the Database, Schema drop down. He wanted to perform these exports more than once per hour and…
-
This last week I presented at Great Lakes Oracle Conference, (GLOC16) and the discussion on monitoring of non-Oracle databases came up while we were on the topic of management packs, how to monitor usage and what ones were required to monitor non-Oracle databases. I didn’t realize how confusing the topic could be until I received an email while in on layover in Chicago and relaying what the attendee had taken away from it. I was even more alarmed when I read the email again, planning to blog about it today after a full nights sleep! You’ll often hear me refer…
-
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…
-
With the addition of the Configuration Management from OpsCenter to Enterprise Manager 13c, there are some additional features to ease the management of changes and drift in Enterprise Manager, but I’m going to take these posts in baby steps, as the feature can be a little daunting. We want to make sure that you understand this well, so we’ll start with the configuration searches and search history first. To access the Configuration Management feature, click on Enterprise and Configuration. Click on Search to being your journey into Configuration Management. From the Search Dashboard, click on Actions, Create and History. You’ll…
-
Monitoring templates are an essential feature to a basic Enterprise Manager environment, ensuring consistent monitoring across groups and target types. There’s an incredibly vast group of experts in the EM community and to demonstrate this, Brian Williams from Blue Medora, a valuable partner of Oracle’s in the Enterprise Manager space, is going to provide a guest blog post on how simple and efficiently you can monitor even PostgreSQL databases with EM13c using custom monitoring templates! Creating and Applying Custom Monitoring Templates in Oracle Enterprise Manager 13c Guest Blogger: Brian Williams Oracle Enterprise Manager 13c is a premier database monitoring platform…
-
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…
-
The change in EM13c, is that it support multiple proxies, but you may still not know how to set up a proxy and then use it with your MOS credentials and then assign out your CSI’s to targets. Proxies To do this, click on Settings, Proxy Settings, My Oracle Support. Click on Manual Proxy Setting and then type in your proxy host entry, (sans the HTTPS, that’s already provided for you) and the port to be used: Once entered, click on Test and if successful, then click on Apply. If it fails, make sure to check the settings with your network administrator…
-
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…
-
I get a lot of questions starting with, “Where do I find…” and end with “in the Oracle Management Repository, (OMR)?” The answer to this is one that most DBAs are going to use, as it’s no different than locating objects in most databases, just a few tricks to remember when working with the OMR. SYSMAN is the main schema owner you’ll be querying in an OMR, (although there are others, like SYSMAN_RO and others.) Most views you will be engaging with when querying the OMR start with MGMT or MGMT$. DBA_TAB_COLUMNS is your friend. Know the power of _GUID…
-
The Gold Agent Image is going to simplify agent management in EM13c, something a lot of folks are going to appreciate. First step to using this new feature is to create a image to be used as your gold agent standard. This should be the agent that is the newest, most up to date and patched agent that you would like your other agents to match. Managing Gold Images You can access this feature via your cloud control console from the Setup menu, Manage Cloud Control, Gold Agent Images. If it’s the first time you’re accessing this, you’ll want to…
-
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…
-
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…
-
Let’s say you’re on call and you’re woke from a deep, delightful sleep from the pager, stating the Enterprise Manager Cloud Control isn’t available. You log into the host, check the status, it tells you that the Weblogic server is up and everything else is down. The host logs show that the servers were restarted unexpectedly, so you want a clean shutdown before bringing Enterprise Manager back up, so you shut it down and then attempt to start it clean: $ ./emctl start oms Oracle Enterprise Manager Cloud Control 13c Release 1 Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. Starting…
-
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…