Tag Archives: oracle

Oracle Database Appliance – Problem Replacing Shared Disk (2.4)

Posted on May 23, 2013 by marcel

As with all systems, a disk failure can happen and so we had a failing disk on one of our ODA’s. As mentioned in the ODA documentation, replacing a disk is easy and OAK does everything for you. Actually it … Continue reading →

Posted in Database Appliance | Tagged , , , , , , , , , , , | Leave a comment

Oracle Database Appliance – /opt filling up

Posted on May 23, 2013 by marcel

Last time we had the /opt filesystem on a couple of ODA nodes filling up. It turned out that the OS Watcher archive directory structure (/opt/oracle/oak/osw/archive) contained lots of old files that should have been cleaned by OSWatcher. When OSWatcher … Continue reading →

Posted in Database Appliance | Tagged , , , , , , | Leave a comment

ORA-29283: invalid file operation using UTL_FILE.FREMOVE

Posted on March 13, 2013 by marcel

I’ve been breaking my head over a problem I had with the UTL_FILE.FREMOVE command trying to remove a file created by another (not oracle) process. On *nix command line, logged in as user oracle (same as database) I’m able to … Continue reading →

Posted in Database | Tagged , , , , , , , , , | Leave a comment

ORA-19809: limit exceeded for recovery files

Posted on January 9, 2013 by marcel

In our cloning procedures we use the RMAN “DUPLICATE” command for duplicating databases. This all went fine for a long time until one moment we start getting errors during the duplication process (from the point where media recovery gets started). … Continue reading →

Posted in Database | Tagged , , , , , , , | Leave a comment

Determine versions of connected Oracle clients

Posted on October 8, 2012 by marcel

Last week I was trying to find a way to determine the version of the Oracle clients that are connected/connecting to databases from these databases. We cannot connect to each application server to figure out the used version and certainly … Continue reading →

Posted in Database | Tagged , , , , , , | Leave a comment

Cryptographic flaws in Oracle Database authentication protocol

Posted on September 26, 2012 by marcel

Recently a security researcher (Esteban Martinez Fayo) made the world aware of a problem with the O5LOGON Oracle database authentication protocol (used in 11g – 11.1 & 11.2). This problem, known as CVE-2012-3137, makes it relatively simple for attackers to … Continue reading →

Posted in Database, Security | Tagged , , , , , , , , , , , , , , , , , , , , , , , | 12 Comments

Linking Oracle BBED in 11g

Posted on September 6, 2012 by marcel

Warning: I use the Oracle Block Browser and Edit tool (bbed) for studying the internal structure of database blocks. Be very careful using the tool, you can destroy blocks using this tool so make sure you know what you are … Continue reading →

Posted in Database, Uncategorized | Tagged , , , , , | Leave a comment

Grid Infra – ASM 11.2.0.3 bug on Solaris – slice 2 CANDIDATE

Posted on August 24, 2012 by marcel

We recently ran into a bug (at least that how I look at it) that is introduced with ASM 11.2.0.3. As of this version, ASM shows slice 2 (the complete disk, starting a cylinder 0 thus inlcuding the VTOC) as … Continue reading →

Posted in Grid Infrastructure, Uncategorized | Tagged , , , , , , , , , , , , , , , , | 2 Comments

Oracle Database Appliance – Installing Bundle Patch 2.3.0.0.0

Posted on August 20, 2012 by marcel

On 23 july 2012 ODA bundle patch 2.3.0.0.0 was released, a long awaited version which should (and indeed does) include multi-home support. As with each new bundle patch, in this version the patch process is getting more robust and the … Continue reading →

Posted in Database Appliance | Tagged , , , , , , , | 2 Comments

Oracle Database Appliance – odachk

Posted on May 22, 2012 by marcel

With the release of ODA patch bundle 2.2.0.0.0 a tool available on Exadata only, is available for ODA too. This tool named “Exadata Configuration Audit Tool – exachk” is modified and renamed to odachk and is located in /opt/oracle/oak/odachk. With … Continue reading →

Posted in Database Appliance | Tagged , , , , , , | 1 Comment