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,…
-
-
How many times have you had maintenance or a release complete and everyone is sure that everything’s been put back the way it should have been, all t’s crossed, all i’s dotted and then you release it to the customers only to find out that NOPE, something was forgotten in the moving parts of technology? As the Database Administrator, you can do a bit of CYA and not be the one who has to say- Having the ability to compare targets is a powerful feature in Enterprise Manager 13c, (and 12c, don’t feel left out there…:)) The comparison feature is the…
-
I just built out my own EM13c environment so I can answer many questions that I won’t be able to ignore just because I no longer work at Oracle. Tips Installation of EM13c is different on Windows than Linux or Unix, (no duh!) but it’s good to know a few tips for those that required to use Windows as their hosting or monitoring OS. Ensure you use a user with administrative privileges on the hosts and that they have appropriate privileges to access the target hosts. Always start any of the installations or deployments with administrator access, (this can be…
-
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…
-
I fly out tomorrow for NoCOUG’s Spring Conference, which will be held on Friday, the 13th in San Jose, California. If you were thinking of attending and needed an added incentive to attend, I’ll be putting on a FOUR hour Enterprise Manager 13c hands on lab, so admit it, you’re intrigued… 🙂 I want to thank Iggy Fernandez, who is the heart of NoCOUG, for contacting me and asking me to do the HOL, along with the folks from Oracle ensuring that I have the environment to offer the attendees to enjoy this great event! I’ll fly back out of San…
-
There are two ways to compare one database to another in the AWR Warehouse. I covered the ADDM Comparison Report here and now we’ll go through the second one, which is much more involved and has us empowering the AWR Warehouse taking two AWR Warehouse reports and comparing two databases to each other. The AWR Warehouse, once setup and databases that are targets already monitored by your EM12c or EM13c environment, can then be added and upload all AWR snapshots to this central repository. Comparison Period Report The AWR Warehouse second comparison reporting option is accessible from the drop down…
-
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…
-
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…
-
Licensing can be a confusing topic for many, but additional stress can be felt for those that use tools that cover multiple products and features that can span more than one management pack. I’ve demonstrated how you can see what management packs are used and how to control this via EM13c, (also available in EM12c) but that can take you away from the task at hand. That’s where turning on Annotations for Management Packs may be beneficial. Annotations What are annotations and why use them? For Enterprise Manager 13c, this results in initials for management packs placed after feature drop down menus…
-
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…
-
While at Collaborate 2016, a number of us were surprised that people still aren’t using Corrective Actions and in EM13c, there are a number of cool ones built into the system to make your life easier. In this post, we’ll use the very valuable, Add Tablespace corrective action to ensure the DBA is no longer woke up at night, automating the tedious task of adding logical space by extending or adding data files. So let’s talk about how you can stop databases from making you get out of bed to add tablespace… 🙂 Creating the Corrective Action Most of this corrective…
-
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…