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 wait for a patch when you want to use a report you need in the meantime? It is is not advisable to modify a standard report, because undoubtedly there will be other changes in a patch to come (e.g. the datamodel), but as long you are aware of this…..

So I chose to modify my favourite report ‘Database Usage Tracking Summary’ for this blog.  And it turned out to be surprisingly simple.

(more…)

By | February 27th, 2016|Categories: Oracle Enterprise Manager|Tags: , , |0 Comments

Oracle Public Cloud Confusion

I always thought I could address the main differences between private and public cloud. Oracle announced the ‘Oracle Private Cloud Machine’ at Oracle Open World 2015 which runs locally, offering a private cloud for an organization. Then Oracle decided to rename it to ‘Oracle Public Cloud Machine’.

And I think a public cloud has two important aspects: (1) resources are shared by multiple organizations and (2) services are available through a public network.

Does this new name make any sense? Where does this machine fit in? Is Oracle trying to change the definition of ‘public cloud’? They already renamed the ‘Oracle Virtual Compute Appliance’ to ‘Oracle Private Cloud Appliance’. This post is just a short reflection of my land of confusion.

(more…)

By | February 19th, 2016|Categories: Uncategorized|Tags: , |0 Comments

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 OEM repository, so there should be standard report facilities to get me informed (other then my own sql-reports from the repository). And guess what, these reports are available.

The Usage Tracking Reports, including the two reports which are important for monitoring the use of licensing, were already present in OEM 12C (wrote about it a while ago) , and I was curious if the usability and functionality improved in OEM 13C (as told me at the demogrounds of OOW2015..).

(more…)

By | February 4th, 2016|Categories: Architecture, licensing, Oracle Enterprise Manager|Tags: , , , |0 Comments

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 are two ways for downloading and deploying : offline-patching and on-line, which means whether OEM is connected to My Oracle Support or not. In this post I will describe both methods ( every method by the way with varying success). And of course you can choose between using the command-line EMCLI and the graphical user interface. It’s Enterprise Manager, so mainly using the gui, but sometimes  forced to use the command-line.

(more…)

By | February 3rd, 2016|Categories: Database, Meta-DBA|Tags: , |0 Comments

Oracle OpenWorld 2015 – a customer’s perspective

At the start of the each year, I always take the time to look back on the year we left behind. Last year, one of my most memorable experiences was Oracle OpenWorld in San Francisco. The event has always been an overwhelming experience, but this year it seemed even more so. I have never experienced such an amount of announcements and innovations, varying in importance and readiness, and all more or less related to the cloud.

A massive technology push to the cloud, a ‘cloud overload’. That could be the management summary of Oracle Open World 2015 (OOW15).

Oracle as software vendor is evolving to a cloud service provider. The force is strong….

(more…)

By | February 2nd, 2016|Categories: Architecture, Database|Tags: , , |0 Comments