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…
-
When concurrency is the crippling factor in a database performance issue, often I’m told that viewing blocked sessions in Enterprise Manager is difficult. The query behind, along with flash image generation in any Enterprise Manager can take considerable time to render and no matter how valuable the view is, the wait is something DBAs just can’t hold out for when needing the answer now. Blocking Sessions View in OEM If you’re wondering which feature I’m speaking of, once you log into any database, click on Performance, Blocking Sessions. If there aren’t any or any significant load on the database, it…
-
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…
-
I am a long time supporter of Samsung products- I’ve always had Samsung phones, (currently a Note 3 owner…) Samsung TVs, monitors and even have a Samsung microwave and refrigerator. I love Samsung products and this has included my tablets, recently deciding to upgrade my Samsung Note 10.1, (original) for a Samsung Note Pro 12.2. I have nothing against Apple/Mac products. I think they are great, but I’m a long time user of Windows, (it really does what I need…) and I have always loved Android OS. When it came to the Samsung Note Pro 12.2, I found the size…
-
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…
-
Just a blog post on the great conference coming up at the end of the month from ODTUG, KSCOPE 2014. The conference will be held in Seattle, Washington this year, (yeah, look forward to cooler temperatures than last year in New Orleans KSCOPE 2013… :)) I’ll be heading up the Database Track and the Women in Technology, (WIT) luncheon this year again for the conference and I recommend you don’t miss out! The Hands on Training for the Database Track is shaping up nicely thanks to some very hard work from Yury Velikanov, Michelle Malcher, Leighton Nelson, John Piwowar, Tim…
-
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…
-
So, there is a lot to cover on this topic and I hope Part I got you ready for more! Part II, I’m going to cover the following areas of the AWR Warehouse: Installation Access ETL Load Process Installation Let’s start with Prerequisites: The AWR Warehouse Repository must be version 11.2.0.4 or higher. The Targets and I think this will get a few folks, need to be 12.1.0.2 or higher, (now folks know why some docs aren’t available yet!:)) Just as with installing ASH Analytics, etc., make sure your preferred credentials are set up for the database you plan to…
-
I know a number of us performance tuning DBAs who’ve long wanted to retain AWR data, at least high-level AWR data for an extended period outside of the AWR repository on the local database. I implemented my own solution back in 2009-2010 at a previous employer as I was tired of hearing, “nothing’s changed”. Nothing like having the high-level AWR data on CPU, IO, network, application and concurrency waits to rebuke this type of assumption at budget decision time…. 🙂 The AWR data is collected as snapshots from ASH, AWR and ADDM in the target databases and then loaded to…
-
If you have the Diagnostics/Tuning Management Packs and EM12c, you should be installing ASH Analytics to get the full benefit of optimization data that is available via the AWR and ASH. ASH Analytics is the future of the Top Activity view and I’ve written a number of posts on the value of the ASH Analytics product. With EM12c Release 4, there are a few, small improvements in the ASH Analytics installation. Where before, there were some challenges to verification of installation success, checking the status of a scheduled installation job, now it’s much easier. If the ASH Analytics package hasn’t…
-
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…