Category Archives: Oracle 11g Release 2

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

MEMORY_TARGET (SGA_TARGET) or HugePages – which to choose?

Posted on March 31, 2010 by Ronny Egner

Oracle 10g introduced the SGA_TARGET and SGA_MAX_SIZE parameter which dynamically resized many SGA components on demand. With 11g Oracle developed this feature further to include the PGA as well – the feature is now called “Automatic Memory Management” (AMM) which … Continue reading →

Posted in Oracle 11g Release 2, Oracle in general | 20 Comments

Oracle 11g Release 2 – RMAN compression comparison

Posted on November 4, 2009 by Ronny Egner

Starting with Oracle 11g Oracle added several compression algorithms to compress data. They can be used for compressing tables, LOBs , compressed data pump exports or even RMAN backups. Unfortunately for some compression algorithms you need to purchase the “Advanced … Continue reading →

Posted in Oracle 11g Release 2, Oracle in general | 15 Comments

Calculate required kernel parameters for running Oracle 11g Release 2 on Linux

Posted on October 28, 2009 by Ronny Egner

The following is a short guide on how to calculate the required kernel parameters for running Oracle 11g Release 2 database on Linux. In addition to that i add some parameters recommended by myself. Note that for running Oracle Grid … Continue reading →

Posted in Oracle 11g Release 2, Oracle in general | 4 Comments

ASM resilvering – or – how to recover your crashed cluster

Posted on October 27, 2009 by Ronny Egner

In this and the following posts i will perform some crash and recover scenarios and show how to recover the cluster successfully. At the moment the following tests are planned and will be published during the next days: suddenly turning … Continue reading →

Posted in Oracle 11g Release 2, Oracle ASM, Oracle in general | 2 Comments

ASM resilvering – or – how to recover your crashed cluster – Test no 4

Posted on October 13, 2009 by Ronny Egner

Test #4: Corrupting the ASM disk with ASM disk group being online and active After overwriting the ASM disk header while the disk group was offline we will now put some load on the full running cluster and corrupt the … Continue reading →

Posted in Oracle 11g Release 2, Oracle ASM | 3 Comments

The Oracle Database File System (DBFS)

Posted on October 8, 2009 by Ronny Egner

The following post is a summary of my tests with DBFS on a 11g Release 2 RAC. DBFS – An Overview Since the introduction of LOBs the database was used to store all kinds of files, for instance images, audio … Continue reading →

Posted in Oracle 11g Release 2, Oracle in general | 6 Comments

Oracle 11g Release 2 – How to enable SSH equivalence

Posted on September 30, 2009 by Ronny Egner

There is a problem with shared oracle homes on ACFS documented here. However if you have not configured SSH equivalence before this short guide shows how to do set up ssh equivalence between the nodes “rac1.regner.de” and “rac2.regner.de”: 1. Unpack … Continue reading →

Posted in Oracle 11g Release 2 | Leave a comment

Oracle 11 Release 2 Install Guide – Creating a RAC database

Posted on September 30, 2009 by Ronny Egner

This is the final part of the Oracle 11g Release 2 installation guide. At this point you should have: Oracle database and grid infrastructure binaries installed at least ONE or better two disk groups configured for: database and binary files … Continue reading →

Posted in Oracle 11g Release 2 | 3 Comments

Oracle 11g Release 2 – SCAN explained

Posted on September 30, 2009 by Ronny Egner

Starting with Oracle 11g Release 2 Oracle introduced a new cluster database connection concept: SCAN – “Single Client Access Name”. SCAN on the server side When installing a 11g Release 2 grid infrastructure you are asked for the cluster name … Continue reading →

Posted in Oracle 11g Release 2 | 9 Comments