Keeping track of Oracle 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 the target databases, hosts and middleware is for now the most thorough way to get informed about possible incompliancy. Or in some cased,  using some clever – but informal and mostly incomplete – scripting on the OEM-repository.

But… Oracle is making serious attempts to make this easier, by integrating the LMS-information  in the repository of Oracle Enterprise Manager and make this available through a couple of (BI Publisher) reports:

  • Database Usage Tracking Report
  • Database Usage Tracking Summary Report

When running these reports (Enterprise –> Reports  -> BI Publisher Reports) with OEM 12.1.0.4 out of the box, unfortunately no data will be shown. There are some manual configuration and upgrades to be done. In the rest of the post I’ll explain some hurdles you have to overcome to get this working.

By the way, it’s not unthinkable that LMS will accept the outcome of these reports as a valid source for counting the (in)compliancy on a relative short notice.

By |May 16th, 2015|Categories: Database, licensing|Tags: , , |0 Comments

Oracle licenses and the cloud

Suppose the number of Oracle licenses you acquired in the past, is in line with the use. That is, you’re compliant with all the licensing rules Oracle come up with. The  license form you use is the so called ‘Full use’ license, this is the most common license form. Everybody happy. But will this change when moving servers, databases or middleware  to the public cloud?

Well , ‘It depends…’ :

1. Is the chosen cloud provider an ‘authorized cloud’ by Oracle

2. Are you going to use your own licenses (BYOL = ‘Bring Your Own License’) or is this included in the cloud solution

3. Is the use of the software the same as it ever was

I’ll try to explain this in chapters below.

By |March 15th, 2015|Categories: Database, licensing|Tags: , , , , , |0 Comments

Oracle has changed the exhange rate of the Euro

For years the number of 0.7893 meant something to those who are working on regular basis with licenses in Europe. This number is the ‘Current local Pricing Exchange rate’.

And Oracle is entitled to change this rate twice a year:

twice-a-year

By |March 2nd, 2015|Categories: licensing|Tags: , |0 Comments

A short guide to networking in Virtual Box with Oracle Linux inside.

This post is intended to be a dummy guide, best practices, or whatever you call it…   about setting up a network while working with virtual boxes on a desk- or laptop. I was setting up a virtual box environment with several Virtual Boxes on my laptop, and as I’m not a network – specialist, I came across a few annoying things, challenges if you like.  And when I was googling around, it appeared to be I’m not the only one, so I felt the urge to share some experiences.

Already published this post on the amis-blog by the way, a long time ago. Decided to publish it also on my own blog.

What I want is the following environment and some elements smells like a subset of the real life:

1. Connect from my laptop to my virtual box through ssh and sqlplus, with fixed ip-address.

2. Simulate a private network, a network between the virtual boxes, also with fixed ip-addresses.

3. Occasionally connect to the internet from within the virtual boxes. To performs a ‘yum update’ and that kind of stuff.

 

By |August 17th, 2014|Categories: Database|Tags: , , , , , , |0 Comments

Configuring a private DNS server on Openfiler for use with Oracle RAC 12C on Virtual Boxes

image.png 

This post has already been published in the past on the AMIS-blog.

To build an Oracle 12C RAC database – on Virtual Boxes – there’s at least shared storage needed for ASM, and a DNS-server for the SCAN-addresses. Several methods can be used for this, but  for the storage in my private project I chose Openfiler, an open source management storage tool, on a separate Virtual Box. It’s like a SAN in real life (the complete system will be three Virtual Boxes: two RAC-nodes and 1 storage Virtual Box). Version Openfiler: 2.99.

O.k. storage is clear, but what about DNS? The quickest and dirtiest way to accomplish this is to use Dnsmasq on every RAC-node. A nice blogpost about this subject is here to be found.

But what I want is a separate DNS-server, just as in real life. The perfect candidate is to use the separate Openfiler Virtual Box

By |June 7th, 2014|Categories: Database, RAC|Tags: , , |0 Comments