Author Archives: Ronny Egner

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

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

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

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)

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

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

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

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

Test #4: Corrupting the ASM disk with ASM disk group being online and active After overwriting the ASM disk header while the disk group was offline we will now put some load on the full running cluster and corrupt the … Continue reading

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

The Oracle Database File System (DBFS)

The following post is a summary of my tests with DBFS on a 11g Release 2 RAC. DBFS – An Overview Since the introduction of LOBs the database was used to store all kinds of files, for instance images, audio … Continue reading

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

ORA-12157 TNS:internal network communication error when connecting after fresh installation

Recently i came across a problem i thought was fixed since 10g: After a fresh installation of oracle 10g when trying to connect to the instance (for instance to create the database for the first time) you get the following … Continue reading

Posted in Oracle in general | 1 Comment

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

Test #3: Overwriting the ASM disk header with ASM disk group being offline In this post we will dig a little bit deeper with ASM. We will overwrite the ASM disk header on one disk while the disk group is … Continue reading

Posted in Oracle in general | 8 Comments