Author Archives: Ronny Egner

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

I am now certified as MCITP MS DBA for SQL Server 2008

Posted on December 12, 2010 by Ronny Egner

Altough not oracle related i successfully completed my certification as an MS SQL Server DBA. In most companies MS SQL is used for smaller databases in addition to oracle. So from my point of view it is a plus. I … Continue reading →

Posted in Oracle in general | Leave a comment

Do you know “chopt” ?

Posted on November 6, 2010 by Ronny Egner

Starting with Oracle 11g Release 2 there is a new tool called “chopt” which lets you enable or disable database features such as partitioning, olap and so on without the need to re-install the bianries. You can read about the … Continue reading →

Posted in Oracle 11g Release 2, Oracle in general | Leave a comment

How to restore an rman backup without any existing control files

Posted on November 3, 2010 by Ronny Egner

This week a came across the following very interesting scenario: The customer made an RMAN online backup and saved it to an NFS location. Controlfile autobackup was on. During backup the backupset was written to that NFS location. The control … Continue reading →

Posted in Oracle in general | 6 Comments

Networker: Fixing “NSR peer information” errors

Posted on October 21, 2010 by Ronny Egner

Just because i have to use google to find the solution often here the direct link for fixing nsr peer information error messages. An example error message can be found below: 39078 19.10.2010 12:07:35  nsrexecd GSS error: There is already … Continue reading →

Posted in Networker | Leave a comment