Monthly Archives: March 2010

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

Integrate EM Console Startup/Shutdown into Clusterware Control

Posted on March 16, 2010 by Ronny Egner

When installing a RAC clusterware is responsible for starting and stopping required resources automatically and in required order. Under normal circumstances every resource is integrated with one exception: EM Control. So this is a short guide on how to integrate … Continue reading →

Posted in Oracle in general | 5 Comments

Creating a Oracle 10g Release 2 or 11g Release 1 database on a 11g Release 2 Cluster

Posted on March 11, 2010 by Ronny Egner

Today i installed a Oracle 11g Release 2 cluster on Solaris SPARC. Installation went smooth – except installation was not able to set up SSH equivalency automatically so i had to configure it myself. After installing Oracle 11g R2 grid … Continue reading →

Posted in Oracle in general | 6 Comments

How to trace DBCA (>= 10g)

Posted on March 11, 2010 by Ronny Egner

Tracing DBCA can be useful. Starting with 10g onwards this can be achieved by: 1. Copy dbca to dbca_debug cp dbca dbca_debug 2. Edit dbca_debug file, fine the last line and add “-DDEBUG” before the “-classpath” argument. The edited line … Continue reading →

Posted in Oracle in general | 3 Comments