Author Archives: Ronny Egner

ASM resilvering – or – how to recover your crashed cluster

Posted on October 27, 2009 by Ronny Egner

In this and the following posts i will perform some crash and recover scenarios and show how to recover the cluster successfully. At the moment the following tests are planned and will be published during the next days: suddenly turning … Continue reading →

Posted in Oracle 11g Release 2, Oracle ASM, Oracle in general | 2 Comments

ASM resilvering – or – how to recover your crashed cluster – Test no 5

Posted on October 27, 2009 by Ronny Egner

In this post we will reproduce a more common scenario: We will forcefully remove the asm disk device from the operating system. This simulates common errors like a crashed storage system or some kind of interrupted connectivity (cable plugged, power … Continue reading →

Posted in Oracle in general | 3 Comments

New Server

Posted on October 26, 2009 by Ronny Egner

As you might have noticed the Blog moved to a new server. This is a dedicated server so that i am able to install plugins, modify the layout and do much more (like hosting files different than images and documents). … Continue reading →

Posted in Uncategorized | Leave a comment

Backing up your system configuration

Posted on October 21, 2009 by Ronny Egner

When backing up servers with any kind of backup software you will most certainly backup your data. But how about the system configuration? When restoring a system from scratch do you know how big the disks were, what partition sizes, … Continue reading →

Posted in Oracle in general | Leave a comment

Oracle on linux – yes of course – but what linux?

Posted on October 19, 2009 by Ronny Egner

There is a discussion from December 2008 what Linux (SLES vs. Red vHat vs. Oracle Enterprise Linux) to use for running oracle on Linux by Yann Neuhaus. You can read his post here. After nearly one year i wanted to … Continue reading →

Posted in Oracle in general | 2 Comments

ORA-01555 (snapshot too old) error although undo_retention set to a high value

Posted on October 17, 2009 by Ronny Egner

The past week i had a argumentation with a colleague of mine on the behavior of the parameter undo_retention in 10g. He stated in 10g undo_retention determines the lower number of seconds oracle keeps the undo records. If there is … Continue reading →

Posted in Oracle in general | Leave a comment

11g Release 2 release rumors

Posted on October 16, 2009 by Ronny Egner

There are rumors on the release dates of 11.2.0.1.0 for different plattforms. According to my information the release dates are: Windows: second quarter 2010 Linux: already released (32-bit and 64-bit intel) HP-UX: 4th quarter 2009 Solaris: 4th quarter 2009 AIX … Continue reading →

Posted in Oracle in general | 1 Comment

Data Pump falsely reports the number of imported rows as 1 (one)

Posted on October 16, 2009 by Ronny Egner

Yesterday i did a large import using data pump and the network mode feature. I noticed a table containing a large number of rows were reported by data pump as imported but with only one (1) row. First i checked … Continue reading →

Posted in Oracle in general | 1 Comment

New public oracle yum server

Posted on October 15, 2009 by Ronny Egner

I just found a new public yum server hosted by oracle. This server can be used to install missing packages over the internet. It does not contain any security updates or bug fixes. The public yum server can be found … Continue reading →

Posted in Oracle in general | 3 Comments

Configuring a small DNS server for SCAN

Posted on October 15, 2009 by Ronny Egner

A few users asked what to do if there is no DNS server available for configuring the SCAN names when installing oracle grid infrastructure. Most asked if they can use hosts file entries. The short answer is: Nope. The grid … Continue reading →

Posted in Oracle in general | 28 Comments