Category Archives: Oracle in general

When running some high workloads on UEK kernels on systems with a lot of memory you might see the following errors in /var/log/messages:   INFO: task bonnie++:31785 blocked for more than 120 seconds. “echo 0 > /proc/sys/kernel/hung_task_timeout_secs” disables this message. … Continue reading →

Since almost two week Oracle released Oracle database patchset 11.2.0.3.0.   I am a little bit late with this news. Martin Bach already  posted a lot of stuff about this so let me link to his guides: – Release Accouncement … Continue reading →

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 →

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 →

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 →

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 →

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 →

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 →

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

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 →