This may not come up very often, but for some reason, an administrator might have to reconfigure an EM12c environment to NOT use load balancers. This could be due to: 1. Hardware Issue on the Load Balancers 2. Mis-configured Load Balancers 3. Re-allocation of Load Balancer hardware for other purposes. Whatever the reason may be, I noted that the instructions to set up the load balancers are easy to find, but not so clearly found are how to configure the EM12c environment to not use the load balancers once they’ve been put in place. To revert back to non-load balancer…
-
-
This is going to be a “KISS”, (Keep it Simple, Silly) post. I was offered a second Windows cluster to test on when my original one was required for QA. It was a gracious offer, but I also found out why a cluster should be kept simple and this cluster was anything but simple. Many times, issues are created and we’ll never see them coming until we go through the pain and the EM12c on this cluster has been both “educational” and painful. The failover cluster is a Windows 2008 server with three Central Access Points, (CAP). Each CAP has…
-
When installing Enterprise Manager 12c, the host value can come from a number of places for different applications/tiers. For most, it comes from the environment variable $ORACLE_HOSTNAME, (for Windows Servers, %ORACLE_HOSTNAME%). The OHS1 target, aka Oracle Apache in the middle tier of the EM12c environment pulls it’s value from the etc/hosts file, (for Unix as well as Windows) and so it is vulnerable with a virtual host name or host name change occurs. It can, however, be updated post installation when the OHS1 target fails to return an active status in the EM12c console. Update the Configuration File The file…
-
As much as KSCOPE 14 fixed any and all Low-T levels, it couldn’t do anything for our the WiFi problems we were experiencing back in May. I’ve been a telecommuter for almost 4 straight years now and was quite frustrated when our WiFi service became dismal back then. We called Comcast service and worked through trouble-shooting with their support multiple times, only afterward, still unable to download files or watch Netflix into the first three weeks of June. Tim purchased a new modem after Comcast confirmed our model was at “end of support” and yet, still no improvement. After more…
-
This post is to address a failed Weblogic start in EM12c. The fix is performed on a Windows host, but the fix can easily be for any EM12c environment that experiences this issue. In the below instructions, just replace the %OMS_BASE% for Windows Env Var to $OMS_BASE for Linux/Unix. Issue: OMS Fails to Start and Points to Weblogic Issue in EMGC_OMS1.out File. Error in Out File: <Critical> <WebLogicServer> <BEA-000386> <Server subsystem failed. Reason: weblogic.ldap.EmbeddedLDAPException: Empty initial replica Reason: Failure on create domain from template step, aka “Emplty Initial Replica” How to resolve: 1. Stop all Oracle processes/services on the host.…
-
I know, I know- none of you are using Microsoft Windows. This is why I get so many questions on this topic and why there is so much interest in a white paper that no one thought I needed to write. Well, while that pesky ol’ white paper is in review, I’m going to go onto a secondary topic of how to monitor a Microsoft Active/Passive cluster with Enterprise Manager 12c, release 4. There are some disclaimers I’m going to put in this blog post- 1. monitoring a clustered host is not explicitly stated as not supported with EM12c, but…
-
So the AWR Warehouse patches are out, but documentation has not officially caught up to it yet, so as we appreciate your patience. I thought I would post about what I went over in my webinar last week when I had the wonderful opportunity to speak to the ODTUG members on this feature that everyone is so anxious to get their hands on. Let’s start with some of the top questions: 1. Can I just load the AWR data into the OMR, (Enterprise Manager Repository) database? A. No, it is highly recommended that you do not do this- use a…
-
The webinar is over, but you haven’t missed out on everything I presented on the console feature, under the hood and behind the scenes! You can access the slides from today’s presentation, as I’ve uploaded them to slideshare and the scripts are easy to locate on the scripts page here on DBAKevlar. Thanks to everyone who attended and a big thanks to GP for doing the introduction and ODTUG for hosting us! 🙂
-
We went over a few of the Java “tuning” options last time, so let’s go onto the OMS tier for this post. Location, Location, Location High latency issues between the OMS(Service) and the OMR, (Repository) when separated by geographical location is common. It’s important when designing the Enterprise Manager environment that you keep your OMS hosts close to the repository hosts geo-locationally. Your agents can be global, with minor network considerations, but the OMS and OMR should always be planned for one geo-location, (preferably one datacenter location.) Number of Users Sizing the OMS based on number of concurrent users might…
-
I’ve already talked about the recommendations we make for properly sizing an Enterprise Manager 12c and many already know about tuning a database, but let’s look at the tuning that may be a bit foreign to DBAs. We’ll start with Java. We all know that it’s part of the EM12c architecture, but we often don’t realize that it requires attention to assist in Enterprise Manager running efficiently. JAVA Updates The Java component of the Enterprise Manager stack must be maintained- which includes applying java updates and also including the JAVA timezone information, which is so often overlooked. The JAVA TZUpdater…
-
Until OEM11g, it was very common that all folks were either Super Administrators or Administrators and only a few shops took the time to create roles outside of these two essential roles. Super Administrator, (SA) was pretty straight forward- the SA had essentially the same access as the repository owner and should only be allocated to those that should have this deep access to the Enterprise Manager environment, but administrator access was more of a mystery. This was assigned to anyone who wasn’t considered for SA rights and we often called it good. With Enterprise Manager 12c, there was a…
-
I often hear, “My EM12c environment is slow!” and I just as often am granted access to the environment and find out that EVERYTHING is running on an old single core server with 2Gb of RAM someone found lying around. Enterprise Manager is often an after thought to many IT organizations. After all the work has gone into the production environments that build revenue, there is often a disconnect on how important information on the health and status of those revenue machines are, resulting in Enterprise Manager receiving the “cast off” servers for their hosted environment. So today we are…
-
Why is the Security Console an important new feature? I was contacted by three people just this last week on how to secure an EM12c environment. How many of you are still logging in to the EM12c console or CLI with the SYSMAN account? Bad DBA, BAD!! 🙂 Security Console The Security Console helps the administrator set clear expectations for security standards for database administration and EM12c environment security. It provides read only dashboards that clearly show security violations and status, along with steps to secure the EM12c environment. You can access the Security Console for EM12c via the Setup…
-
How many of you use Oracle Enterprise Manager 12c, recognize it can do so much more than just taking it out of the box and plugging it in, then proceed to start building metric extensions, plug-ins, writing EM CLI scripts, etc? How cool would it be if you could peruse a library of plug-ins to support the extensibility framework for you to check out and use for the benefit of your company and you? If you aren’t familiar with the Extensibility Exchange, it is exactly that! Oracle’s Extensibility Exchange is a library of contributions from Oracle, it’s trusted partners and…
-
I talk a lot about Enterprise Manager 12c, from the OMS all the way to the EM CLI and the Agent, but I was discussing some interesting history with the account used by the OEM Management Agent- the DBSNMP account. The origination of the DBSNMP account was to support Oracle SNMP, (Simple Network Management Protocol.) Back in Oracle 7-8i days, this account was vulnerable to all kinds of nasty issues and there were steps that administrators needed to take to secure it- from making the snmp_rw.ora file inaccessible except to the ORACLE OS user, (residing in the $ORACLE_HOME/rdbms/admin directory) to…
-
I’m still asked this question, as I’ve worked for some really fantastic companies in the past and the idea that I “gave up” my Oracle ACE Director and my voting board position at RMOUG seems a high price to pay when I could have gone anywhere. I do appreciate it, as many just want what’s best for me, so I do take this into consideration. I decided a while back that with all Enterprise Manager Cloud Control encompassed, that it was what I really wanted to specialize in. I spent time reading everything I could get my hands on, talked…
-
Most of you know I don’t like pink, but I also am not a fan of yellow. Yellow houses Yellow flowers Yellow in my EM12c summary page You know what yellow I’m talking about: Now I’m just as disturbed by the red section of that graph, but today, we’re going to focus on the unknown, the yellow. If something is down, then you know it isn’t uploading data and is most definitely a critical issue, but what about the unknown? Why is Enterprise Manager reporting something is unknown? To first tackle this type of summary, we need to know the…
-
I’m often asked what management pack is used by what feature and there is actually a very easy way to find out this information in the EM12c console. Let’s say we are in ASH Analytics and want to view what management packs are required as part of this feature utilization: Click on the global Setup menu in the upper right, then click on Management Packs and Packs for this Page– You will quickly see a pop up page that shows you what management pack(s) are required to use the ASH Analytics feature: If we jumped to SQL Monitor and did…