Save money by understanding the Oracle licensing model – part I

By | August 28th, 2016|Categories: Database, licensing, Meta-DBA|Tags: , |

At several companies I worked for, there was a lot of confusion about the licensing model of Oracle. The general feeling was that they paid too much for their use of Oracle products, and they were not certain of their compliancy. This post will try to give some clarity about this issue.

Connect Oracle Enterprise Manager 13 to Amazon’s Cloudwatch

By | June 1st, 2016|Categories: Database, Oracle Enterprise Manager|Tags: , |

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 Hybrid Cloud Agent to connect directly to the Oracle Management Service of OEM13c. Luckily there’s a plugin to connect with Cloudwatch. This article will cover the installation of this plugin and connection of OEM13 to the RDS database instance.

[…]

Implementing ORAchk in Oracle Enterprise Manager 13c

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

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.

[…]

Oracle OpenWorld 2015 – a customer’s perspective

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

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….

[…]

Keeping track of Oracle licenses with OEM12c – reports

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

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.

[…]

Oracle licenses and the cloud

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

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.

[…]

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

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

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.

 

[…]

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

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

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

[…]

Licensing development and test environments

By | May 17th, 2014|Categories: Database, licensing|Tags: , , |

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

Once in a while a company wants to know if her Oracle development- and test- environments needs to be licensed. And in a lot of cases this question simply can be answered as: yes, these environments must be licensed. The cases in which these licenses are not needed, are quite rare and a company should verify this with her Oracle representative or an intermediary.

Recently I bumped into such a lucky company, and I thought it’s a good reason to write about this. And as always when talking about licenses please take notice of the disclaimer in this article.

In this post I will first shortly point out why development- and test-environments need to be licensed according to Oracle, try to explain the ‘OTN Development license’ , describe the case of the lucky company and point out some consideration to make the costs of the environments maybe more bearable.

image

[…]

My project with Dbvisit Standby – basics

By | March 31st, 2013|Categories: Database, Standby|Tags: , , , |

A while ago I made a promise to take a look at the product Dbvisit, found out this is not the product, but just the firm Dbvisit. The product I’m about to install is called officially ‘Dbvisit Standby‘. There’s also a product called ‘Dbvisit replicate’.
I didn’t really know about the product, not related to it, but it was buzzing around that it’s a cheap and a well working alternative for a high available environment with Oracle Standard Edition in stead of the Enterprise Edition with Data Guard.
So my first project (this post) is just to install a lab environment and get it working. The second project should be the real thing, testing the availability and the easiness of administration and monitoring.

What will I do for this part of the project (working from scratch with the latest versions – at the time of writing – of Oracle Linux and VirtualBox…):

1. Create two VM’s (VirtualBox with Oracle Linux 6)
2. Install Dbvisit Standby
3. Configure Dbvisit Standby
4. Get it going!

And not surprisingly, the preparation took most of the time:

[…]