Category Archives: Oracle in general

Oracle just released a statement which states the immediate availability and support using Oracle database 11g R2 with Oracle Enterprise Linux 6.   You can read the official announce here.

I just played with 11.2.0.3.0 patchset on Linux x86_64 (in my testcase Oracle Enterprise Linux 5.6) and tried to install a 11.2.0.2.0 database on it. It fails with: PRVF-5300: Failed to retrieve active version for CRS on this node The … Continue reading →

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 →