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.

Licensing ODA on NUP’s ?

By | April 23rd, 2013|Categories: licensing|Tags: , , |

Since Oracle launched the Oracle Database Appliance it is clear that only the Enterprise Edition is allowed on the machine. But for me it was still a little bit fuzzy if and what kind of licensing requirements is needed. More direct : may the ODA be licensed on NUP´s ? Some statements while investigating:

Documentation:

Customers are only required to license processor cores.

 

Licensing on processor cores, but not processor metric! Diving deeper….

[…]

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:

[…]

ODA – a brief view on a virtualized platform

By | February 8th, 2013|Categories: Database|Tags: , , |

Received a pdf from Oracle with the new features of the Oracle Database Appliance (when you are using the OracleVM-option).

Among other things, the two last sheets about the licensing had my attention too. I’m just showing the slides, haven’t worked with it, so I can’t tell you in detail the experiences. But the slides may give you an idea how the Virtualized Platform will look like in the new ODA, and how it will be licensed.

 

ODA_how_VM

 

 

 

 

 

 

 

 

 

 

 

 

[…]

What does a DBA really do – in ITIL terms ?

By | February 5th, 2013|Categories: Meta-DBA|Tags: , , |

legsontable

“A good DBA may relax and put his legs on the table”. These words a senior (in age as well as in experience) DBA used to say while he was trying to teach me the basics of administrating databases. He was trying to say that organizing your work and preparing yourself for future catastrophes is the most important part of the job. Only then you are confident to face the surprises Oracle software and the organisation where you work for comes up with.

But as time passes by I disagree with this attitude. In my opinion a good DBA has always work to do. But it’s not always easy to convince your manager you are busy as hell. What ARE you doing all day long, or moreover, what meaningful pro-active contributions you possibly can do for your company to keep the business online? And how can you make it visible to your manager. I´m convinced that in most organisations the attitude towards DBA´s is quite respectfull, but that was and is not always the case and this writing is for those who continuously struggle with the aspects a DBA is doing or is supposed to do.

In this post I’ll try to summarize the deliverables for a DBA as a kind of checklist. Thought about it what base to choose for this kind of list.  Had the choice for methods as ITIL, ASL (Application Services Library) ISM (Integrated Service Management), COBIT ( Control Objectives for Information and related Technology) and more. Decided to keep it simple, using a lot of ITIL (v2, cause I’m lost with v3):

[…]

Oracle and RHEL 6 certification

By | March 30th, 2012|Categories: Database|Tags: , , |

Waited for a long time now, but here it is, copied it from the official press release. It’s a bit pity of the 90 days in the second bullet, but in the meantime it is certified all the way and it is reflected in the certification […]

Oracle on RHEL 6 , using ASM with or without ASMLIB

By | January 4th, 2012|Categories: Database, RAC|Tags: , , |

Oracle will not provide ASMLib packages for kernels distributed by Red Hat as part of RHEL 6.

Multipath timeout issues with extended 11.2.0.2 – cluster setup. Part II

By | January 3rd, 2012|Categories: Database, RAC|Tags: , , , |

The second and final post about an issue with a RAC-configuration with two SAN's. Problem was a i/o-freeze of minutes when crashing one of the two SAN's. The first post I ended with a 'cliffhanger' because we had a solution, but not tested it yet.

Param ‘_datafile_write_errors_crash_instance’ , TRUE or FALSE?

By | August 26th, 2011|Categories: Database, RAC|Tags: , , |

Since 11.2.0.2 there's a new parameter, "_datafile_write_errors_crash_instance" to prevent the intance to crash when a write error on a datafile occurs. But.. should I use this or not.

Multipath timeout issues with extended 11.2.0.2 – cluster setup

By | August 25th, 2011|Categories: Database, RAC|Tags: , , , |

With this setup we are facing the issue that if we loose a complete SAN, the IO’s to the ASM diskgroups will be blocked for approx 3 till 4 minutes. Oracle does not like this. After 70 seconds after a freeze, rdbms is starting to reboot (expected behaviour).