Database

My project with Dbvisit Standby – basics

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:

By |March 31st, 2013|Database, Standby|1 Comment|

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|Database|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|Database|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|Database, RAC|11 Comments|

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

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. Now we tested it.

Start with a mockup of the first post.

Setup:

3 HP DL380 G6 systems with a basic RHEL 5u5 x86_64 installation (2 x RAC clusternodes, 1 x NFS-voting-node)

2 SAN’s HP EVA 6400 systems with 2 controllers each (resulting in 8 paths per device)

Oracle 11.2.0.2

Test: power off 1 SAN.  Default result / problem: i/o freeze of minutes, Oracle didn’t like it, started to evict, shutdown, startup = expected behaviour after such a long i/o freeze. But this is not the intention when installing a RAC with two SAN’s….

By |January 3rd, 2012|Database, RAC|0 Comments|