Author Archives: Ronny Egner

ext4 file systems and the 16 TB limit – how to *solve* it

Posted on August 18, 2011 by Ronny Egner

creating and handling ext4 file systems larger > 16 TB Continue reading →

Posted in UNIX | 28 Comments

When patching is not enough: Oracle 11g R2 on Solaris SPARC requires fresh base installation of Solaris 10 U6

Posted on June 15, 2011 by Ronny Egner

While checking MOS i found an interesting note (ID 964976.1) which states: Applying a kernel patch or a Solaris patch bundle is not the equivalent to installing the specific Solaris 10 “update 6” image. 11gR2 RDBMS software is only certified … Continue reading →

Posted in Oracle in general | Leave a comment

Installing a paravirtualized guest using PXE and Kickstart on Oracle VM 2.2

Posted on June 10, 2011 by Ronny Egner

The past few days i started working on Oracle VM 2.2.1. The task i tried to accomplish was to install Oracle Enterprise Linux in a para-virtualized guest via PXE and Kickstart. Sounds not too complicated, does it? If you are … Continue reading →

Posted in Oracle VM 2.2 | Leave a comment

11.2.0.2: two critical bugs

Posted on May 27, 2011 by Ronny Egner

Just found two nice bugs in Metalink for 11.2.0.2.x: Bug #1 (10205230) [Note ID 1318986.1]: ORA-00600 or DATA CORRUPTION in RAC Environments when using shutdown mode “normal”, “transactional” or “immediate” on 11.2.0.2.1 and 11.2.0.2.0.   This Bug is fixed in … Continue reading →

Posted in Oracle in general | 1 Comment

Removing NFS Locks on Opensolaris / Nexenta (or handling ORA-27086: unable to lock file – already in use when using Oracle over NFS)

Posted on April 29, 2011 by Ronny Egner

Facts Oracle running on Linux / Solaris Oracle data files and control file are stored on NFS NFS server used Opensolaris or Nexenta Symptom ORA-00205: error in identifying controlfile, check alert log for more info ORA-00210: cannot open the specified  … Continue reading →

Posted in Oracle in general | 1 Comment

ORA-27154: post/wait create failed / ORA-27301: OS failure message: No space left on device when starting ASM or database instance

Posted on April 11, 2011 by Ronny Egner

Today i came accross a very strange error. After rebooting one cluster node (which ran flawlessly before!) ASM instance came up fine but database instance failed with: ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28 … Continue reading →

Posted in Oracle in general | 16 Comments

PSU Bundle Patch 3 for 11.2.0.2.0

Posted on March 30, 2011 by Ronny Egner

Bundle Patch 3 for Oracle 11.2.0.2.0 is available. For installation refer to these posts here and here. Patch number is: 10387939 If youre worried about the fact the patch says it is for Exadata read this post from Oracle. Money … Continue reading →

Posted in Oracle in general | Leave a comment

RMAN backup validate database on databases in noarchivelog mode

Posted on March 24, 2011 by Ronny Egner

Starting with 11g RMAN seems to allow a “backup validate database” even if the database is not in archive log mode: SQL*Plus: Release 11.2.0.2.0 Production on Wed Mar 23 11:18:01 2011 Copyright (c) 1982, 2010, Oracle.  All rights reserved. Connected … Continue reading →

Posted in Oracle in general | 2 Comments

Networker cumulative hotfixes

Posted on December 29, 2010 by Ronny Egner

EMC offers so called cumulative hotfixes which include all available and tested hotfixes for a specific version. These hotfixes can be found at the following URL: ftp://ftp.legato.com/pub/NetWorker/Cumulative_Hotfixes

Posted in Oracle in general | Leave a comment

How to corrupt a oracle block within a datafile

Posted on December 21, 2010 by Ronny Egner

For corrupting a block dd can be used. Just adjust the “ibs” argument to match your database block size and adjust “count” to specify the amount of blocks to be corrupted. “Seek” specifies how many blocks are skipped (counted from … Continue reading →

Posted in Oracle in general | Leave a comment