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…
-
-
So Uwe Hesse caught my interest when he blogged about how to add your twitter handle to your time on your taskbar. This is really cool for those of us that present, so that while we demo, you’ll see our twitter handle displayed at all times. I did notice that his instructions, as most instructions I find for things on the Oracle side are for older versions of Windows or for Mac. I have a Window 10 machine and yes, it’s possible, just a few steps different. There are a number of ways to do this….most of them are long,…
-
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…
-
I was surprised on April 20th when I awoke to find a 1.3G OS update on my Samsung Galaxy 6 Edge+. I’d never experienced any issues with an update before, so I quickly connected my phone to the WiFi and let it download then upgrade my phone, anxiously awaiting what new Android features awaited me. It Broke I proceeded through my day, but was concerned as battery usage was higher than usual and I suffered email failures from Gmail and a few tweets didn’t go through. I consider myself quite familiar with mobile phone trouble shooting and promptly performed the…
-
No, you didn’t get a review of my Samsung Tab S2….I didn’t have it long enough to review it! Actually, I had it just over six months and yes, it was beautiful and yes, I love it and no, it didn’t survive the fall on the tile, even in the protective cover at Denver International Airport. Needless to say, I love my tablets and I’ve had a number of them. I’ve had everything from the first 10.1 from Samsung to the iPad Air. My daily work machine is a Microsoft Surface Pro 4, but it’s a beautiful, lovely piece of hardware…
-
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…
-
Becoming a mentor was not a direct path for me. Even though I inspired people with my perseverance and common sense, I had no inclinations for a corner office position, (I often joke about passing up the corner offices in a fight to get to the server room) and this is often a trait that is expected for someone who is titled with “Mentor.” In the five years in an official mentoring capacity, I’ve learned as much as I feel I’ve imparted among those I’ve mentored. I now find others asking me for advice on how to become a mentor or…
-
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…
-
While at Collaborate on Monday, Oracle has been offered a spot to highlight The Oracle Management Cloud. OMC is a suite of next-generation monitoring and management cloud services designed for heterogeneous environments, all empowered by Oracle’s own cloud! The first three OMC services (Application Performance Monitoring, Log Analytics and IT Analytics) were launched at OpenWorld 2015. Both Log Analytics and IT Analytics contain must-have capabilities for DBAs. This is the only OMC session that will be available at Collaborate and it’s a not to miss session with an all-star cast to present on it. Manning the slides will be Brian…
-
On my previous post, I submitted a job to create a test master database in my test environment. Now my test environment is a sweet offering of containers that simulate a multi-host scenario, but in reality, it’s not. I noted that after the full copy started, my EMCC partially came down, as did my OMR, requiring both to be logged into and restarted. Upon inspection of TOP on my “host” for my containers, we can see that there is some serious CPU usage from process 80: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 80 root…
-
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…
-
Since the introduction of Enterprise Manager 12c, folks have been asking for a list of best practices. I know a lot of you have been waiting for this post! 1.Use previously deployed, older hardware for your Enterprise Manager deployment on 13c. Enterprise Manager is a simple, single service system. There is no need for adequate resources and ability to scale. In fact, I’ll soon be posting on my blog about building an EM13c on a Raspberry Pi 3. 2. Please feel free to add new schemas, objects and ETL’s to the Oracle Management Repository, (OMR.) This database doesn’t have enough…
-
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…
-
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…
-
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…