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

[…]

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

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

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

[…]

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

Red Hat 6 and Oracle, status of certification

By | August 24th, 2011|Categories: Database|Tags: , , |

Red Hat 6 has been there a while, so what about certification with Oracle? Nothing on the Oracle support site, no press releases (maybe I missed one..). But Red Hat finally gave the answer in her Red Hat news - blog

Errors in alert log [NI cryptographic checksum mismatch] TNS-12599

By | May 25th, 2011|Categories: Database, grid control|

Using rdbms 11.2 as the repository for our Grid Control environmont, noticed a lot of the same errors in the alert file of the repository or/and the target database:

NI cryptographic checksum mismatch error: 12599.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.2.0 – Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.2.0 – Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 – Production
Time: 24-MAR-2011 11:58:31
Tracing not turned on.
Tns error struct:
ns main err code: 12599

TNS-12599: TNS:cryptographic checksum mismatch
ns secondary err code: 2526
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0

Note: 1150874.1 gives the cause, workaround and solution:

[…]

Restoring OCR on 11.2.0.2-cluster

By | May 15th, 2011|Categories: Database, RAC|Tags: , , |

As the documentation about restoring an OCR did not work as it should be, hereby a method to do this.