In the organization I’m currently working for, the OS-patch schedule depends on PatchTuesday (PT) just as Microsoft, Adobe or Oracle are using. And PatchTuesday is, as you all know, the Second Tuesday of each month. But this is a schedule you can not set in the Oracle Enterprise Manager Scheduler. […]
Enterprise Manager
Upgrade Failure as Blessing in Disguise?
or The Findings of an Failed Enterprise Manager Upgrade to OEM13.3 When Oracle Enterprise Manager Cloud Control 13.3 (here just called EM 13.3) came available I read the upgrade documentation and decided that the most cost-effective option for us was to stay with EM 13.2. Later, a rumor about a […]
Creating a Report of available ASM candidate disks from the OEM Repository
A while ago I was reviewing the metric extensions of our Enterprise Manager Cloud Control 13.2.0.0, we use to administer a couple of hundred databases. All acceptance and production databases are installed on Linux RAC-clusters with underlying ASM storage. One of the custom reports summarized the size and number of […]
Enterprise Manager DataGuard Add Standby Database fails without showing errors at Destination Preparation phase
Oracle Enterprise Manager Cloud Control 13c provides the Add Standby Database wizard to create a broker configuration that includes a primary database and one or more standby database. This requires the Oracle Database Lifecycle Management Pack for Enterprise Manager Cloud Control. When adding a Standby Database, after proving all the […]
My “Sinatra-Solution” for Error Code 235 of OMSPatcher 13.8.0.2
and How I resolved it …. My Way 235 … 235 … isn’t it an Interstate in Oklahoma? Is Oracle telling me that I’m now working with only 0.72% of all naturally occurring uranium? Was I testing the maximum speed of a BMW 3series? Or did somehow an Un-locked Control File […]
Using Java Management Extensions within Oracle Enterprise Manager Cloud Control 13c
The answer to using Java Management Extensions(JMX) within Oracle Enterprise Manager Cloud Control is using Metric Extensions. Metric extensions provide you with the ability to extend Oracle’s monitoring capabilities. I will show you how to create an extension to monitor a WebLogic Messaging Bridge. You can use other methods to […]
The Tale of the Ardent SpringCleaning Maniac (ASM)
or If you want to get rid of stuff, you can always do a good spring-cleaning. Or you can do what I do. Move. – Ellen DeGeneres In order to prepare for a network reorganization we needed to move our current Oracle Enterprise Manager machine into another network segment. So […]
The curious case of the blank plugin page in OEM13c
After an upgrade of Oracle Enterprise Manager from 12.1.0.5 to 13.2, I wanted to deploy a new version of the plugin oracle.sysman.db. Downloaded the new version and got to the plugin-management page to apply the patch. But all I got was a blank page. Cost me quite a while to […]
Deploying Oracle OEM agents 13c on windows targets (2008 R2) while OMS is on Linux
Situation at customer’s site: OMS 13.2 on Oracle Linux, targets are Windows machines, and a bit ancient: Windows 2008 R2. How to deploy agents on those targets? Several methods are possible in theory. In this blog I’ll describe my efforts to determine what is really possible and what is efficient.
Relocating base directory Enterprise Manager’s central agent
After the upgrade of the 12c central agent to 13c, I noticed the new central agent’s home located under the wrong – old agent – directory: /u01/app/oracle/agent12c/agent_13.2.0.0.0. Must have done something wrong. How to correct this? Want to move the directory to /u01/app/oracle/agent13c/. A very short blog to describe the […]
Upgrade OEM 12.1.0.5 OMS to OEM13.2
Despite the potential of Oracle Management Cloud, I’m a fan of Oracle Enterprise Manager, with its small imperfections. So when noticing a 12c Oracle Enterprise Manager on Linux, and targets on Windows, I took the challenge of modernizing the customer’s environment a bit. And the starting point , 12.1.0.5 for […]
Connecting Oracle Management Cloud with Oracle Enterprise Manager 13c
Let’s clear about this: Oracle Management Cloud (OMC) is NOT a replacement of Oracle Enterprise Manager Cloud Control (OEM CC) or even an equivalant. Rumours are that this will be Oracle’s policy in a far away future, but in the meantime we focus on what they do best. OEM CC […]
Serial database backups using Oracle Enterprise Manager
For several years now, I’ve been a fan of backups controlled by Enterprise Manager (of Grid Control, or Cloud Control, call it what you want). It is relatively easy to configure backups for your databases and it is well known in our DBA world. Only one thing bothered me though, […]
Deploying Oracle Management Cloud for Infrastructure monitoring
It’s a bit hard to choose the right heading for this article. How do you call setting up Oracle Management Cloud (OMC) – a trial environment – to explore the possibilities for monitoring the infrastructure such as hosts, databases, middleware. You don’t have to install OMC – it’s already there […]
Connect Oracle Enterprise Manager 13 to Amazon’s Cloudwatch
Oracle Enterprise Manager 13C has been introduced as a ‘single pane of glass’. Managing and monitoring all the assets, in or out of the public cloud. But when creating an RDS- database instance in Amazon’s cloud, it is monitored by Cloudwatch, and it’s not possible to install a so-called Oracle […]
Chargeback in Oracle Enterprise manager 13C
Since Oracle Enterprise Manager 12C it is possible to allocate the costs of IT resources to the people of organizations who consume them. This is done through the use of the plugin ‘Consolidation Planning and Chargeback’ . Pete Sharman wrote an excellent blog about configuring this plugin in Enterprise Manager […]
Modifying BI Publisher reports in Oracle Enterprise Manager 13c, e.g. ‘Database Usage Tracking Summary’
Recently I bumped into an annoying bug in the code of a report, wrote about it a while ago, notified Oracle. And they has confirmed that a new version of this specific report is in development phase. But.. a report can be modified, so if it’s not that hard, why […]
Usage Tracking Reports, using Oracle Enterprise Manager 13C as a SAM tool
Still loving the idea to use Oracle Enterprise Manager as a ‘kind of ‘ Software Asset Management Tool, and get regular centralized reports that tells me what Oracle software is running and if there are changes in use of licenses over time. The necessary data is already there in the […]
Implementing ORAchk in Oracle Enterprise Manager 13c
Heard about it at Oracle OpenWorld 2015: A new feature in Oracle Enterprise Manager 13c is the possibility to incorporate ORAchk, the healthcheck tool for databases, RAC and Engineered Systems. This post is about downloading (and importing), deploying and provisioning the ORAchk-plugin. Spoiler-alert: there’s downtime involved of the OMS. There […]
Oracle licenses needed while monitoring your (non-)Oracle environment with OEM
With Oracle Enterprise Manager you are able to monitor an Oracle environment as well as a non-Oracle environment, like Microsoft’s SQL Server. You are also able to exchange notifications between Oracle Enterprise Manager and e.g. Microsoft’s SCOM, and there’s a choice how to monitor this heterogeneous environment. One of the […]
Use DB Vault to protect password strength policy
Suppose your organization wants to enforce a security policy on database password strength. The DBA’s have implemented a password strength verification function in PLSQL such as the oracle supplied ora12c_strong_verify_function in the DEFAULT profile of the database. There seems no way to get around it at first: Database account u4 […]
Keeping track of your licenses with OEM12C – reports
Wouldn’t be nice to get regularly informed how (in)compliant you are with Oracle licenses in an easy – centralized – way, and therefore not have to worry about visits of Oracle’s LMS – License Management Services? I think that would be nice for the most of us. Running LMS-scripts on […]
ADF Performance Monitor: Measuring Network Time to Browser and Browser Load Time
Recently we added a great new feature to the ADF Performance Monitor: network and browser load time information. Now you know exactly every end-user experience of your ADF application, in real-time. You can quickly resolve any performance bottlenecks with this end-to-end visibility. You can even drill down into an individual user to […]
Updating composite properties on runtime (and being misled by the mbean browser)
Recently I walked into something strange. I had developed a simple composite application. The application is used to read a file and route the content to another service. The composite application contains composite properties as shown through the property inspector. Within the composite I am using a file-adapter to read […]
Instrumenting, Analysing, & Tuning the Performance of Oracle ADF Applications
Last week I presented at the UKOUG’14 conference on instrumenting, analyzing, & tuning the performance of Oracle ADF applications. Instrumentation refers to an ability to monitor or measure the level of a product’s performance, to diagnose errors and to write trace information. Instrumenting gives visibility and insight of what is happening inside the […]
Monitor Dell PERC when running on Oracle Virtual Server 3.x
In this article I will try to explain how to monitor your Dell Raid Controller with Cloud Control when running Oracle Virtual server 3.x (OVS3.x). Some time ago a physical drive broke down on one of our Dell PowerEdge Servers. Not causing any problem because it was configured in a […]
Cloud Control authorization with Active Directory
About 2 months ago I wrote an article about setting up user authentication in Cloud control, based on their account in the Active Directory. As promised, here is the second part describing Cloud Control authorization with Active Directory. A small recap about why this could be useful: If your company […]
Cloud Control: How a Camel can make you cross a Data Guard Mountain
In my recent post I already mentioned it a little bit: Integrating your manual Data Guard Broker configuration in OEM Cloud Control can become a sort of climbing a Mountain. And it doesn’t have to be. But first a short description of the situation. I have a working Data Guard broker […]
How to add your Standby Cluster Database to Cloud Control
The last few months I’ve been working with Oracle Data Guard, reading lots of manuals and (parts of) books, to make smart decisions and get a solid foundation. I consider myself part of the people who like to work with the command line. That way you really get to understand what […]
Cloud Control authentication with Active directory
If your company is preferring Microsoft Active Directory as a source of truth (or at least you´re trying to) you should be using the AD as source for the user accounts in Cloud Control. The advantages are obvious: Control the validity of accounts in one single place, no different login’s […]
ADF Runtime Diagnostics: Instrumenting your ADF Application – Part 2
In a series of blog articles I show how you can instrument your ADF Application key actions. Instrumenting gives visibility and insight of what is happening inside the ADF application and in the ADF framework (what methods and queries are executed, when and how often). These runtime diagnostics can be very effective in […]
ADF Runtime Diagnostics: Instrumenting your ADF Application – Part 1
In a series of blog articles I will show how you can instrument your ADF Application key actions. Instrumenting gives visibility and insight of what is happening inside the ADF application and in the ADF framework (what methods and queries are executed, when and how often). These runtime diagnostics can be very effective […]
Installing OEM12c: Compiling problems: cannot find crt1.o
Few days ago I had to install Oracle Enterprise Manager 12 on a fresh installed Oracle Linux 64 bit environment. OS was installed from Oracle supplied template, so this should be an easy going, not….? After checking package dependencies from the installation manual (all confirmed) we started the installer. I […]
ADF performance tuning: Whitepaper published on the ADF Performance Monitor
The AMIS ADF Performance Monitor is an advanced tool designed for measuring, analyzing, improving, and checking the performance of Oracle ADF applications. The monitor can track and collect crucial (production) performance information of the application’s runtime ADF components that are not standard provided by Oracle. It helps development, QA, and […]