ODA – a brief view on a virtualized platform

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

 

 

 

 

 

 

 

 

 

 

 

 

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

What does a DBA really do – in ITIL terms ?

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):

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

How many NUP’s you really need when using Oracle Database ?

Something about licensing. Boring for the most of us, but this may save you a lot of money…. The next is not completely new, but I never had it on writing, so found it worthfull to blog.  The following has by the way no legal status and I’m not held responsible for any claims Oracle might want to put on your company (that is, can’t afford a lawyer..)

Maybe you know the rule: When using Oracle Enterprise Edition database, and want to license by NUP’s – Named User Plus Licenses – you are bound to a minimum of 25 users per Oracle-defined processor. So using a server with one Intel-based quad-core processor (with a factor of 0,5), you have to pay for (4 * 0,5 =) 2 Oracle processors, which is equal to a minimum of 50 users.

This has  been defined in the Software Investment Guide (page 14):

Minimums for this metric may be discrete quantities, or they may be based on the number of processors in the machine on which the software will be installed and/or run. For example, the minimum for the Database Enterprise Edition, the iAS Standard Edition and the iAS Enterprise Edition is 25, 10 and 10 Named Users Plus per Processor, respectively

Let’s stick for a moment on the Enterprise Edition of the database, and the example above. When a second server (1 quad core) is added, also with an Enterprise Edition database on it you’ll have to pay for a total of 100 NUP’s.

But what if I only have got 60 users (non human operating device included) who are directly or indirectly authorized to use those two databases / nodes. Will I pay for 60 users or 100 ? To be sure I asked this question to my contact at LMS (License Management Service at Oracle).

By |December 14th, 2012|Categories: licensing|Tags: , |2 Comments

Oracle and RHEL 6 certification

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 in My Oracle Support.

Oracle Announces the Certification of the Oracle Database on Oracle Linux 6 and Red Hat Enterprise Linux 6

Redwood Shores, Calif. – March 22, 2012

News Facts

  • Oracle Database 11g Release 2 (R2) and Oracle Fusion Middleware 11g Release 1 (R1) are immediately available on Oracle Linux 6 with the Unbreakable Enterprise Kernel.
  • Oracle Database 11g R2 and Oracle Fusion Middleware 11g R1 will be available on Red Hat Enterprise Linux 6 (RHEL6) and Oracle Linux 6 with the Red Hat Compatible Kernel in 90 days.
  • Oracle offers direct Linux support to customers running RHEL6, Oracle Linux 6, or a combination of both.
  • Oracle Linux will continue to maintain compatibility with Red Hat Linux.
  • Effective immediately, Oracle will provide its Red Hat compatible Linux binaries, updates and errata for free http://public-yum.oracle.com. Terms, conditions and restrictions apply.

Some FAQ on this matter can also be found on the Redhat-site here.

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

Oracle on RHEL 6 , using ASM with or without ASMLIB

A while ago, but worth mentioning it for those customers with a roadmap based on Red Hat Linux.  The status regarding RHEL 6 is the following:

- Oracle has indeed certified RHEL 6 for the Oracle database, see also the comments in this article, and my seperate blogpost about it.

- Red Hat announced recently an extended lifecyle (support) of version 5 and 6, from 7 to 10 years.

- Red Hat is making things harder by shipping its RHEL 6 kernel source as one big tarball, without breaking out the patches. Distribution in this form satisfies the GPL, but it makes life hard for anybody else wanting to see what has been done with this kernel

Maybe as a result of this:  regarding ASMLIB Oracle mentioned in note 1089399.1 :

For RHEL 6, Oracle will provide ASMLib software and updates only when configured with a kernel distributed by Oracle. Oracle will not provide ASMLib packages for kernels distributed by Red Hat as part of RHEL 6. ASMLib updates will be delivered via Unbreakable Linux Network (ULN), which is available to customers with Oracle Linux support. ULN works with both Oracle Linux or Red Hat Linux installations, but ASMLib usage will require replacing any Red Hat kernel with a kernel provided by Oracle.

Red Hat has written this general article  about it and this technical article how to overcome this:  using ASM with or without ASMLIB.

First I mentioned in this post that you could not use ASM with RHEL 6, but Tim Hall corrected me on this, read his comment on this post. Thanks (and cheers… ) !

Hope it helps somebody.

 

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