Category Archives: Oracle in general

11g Release 2 for Windows – Single Database Installation Guide

Posted on April 21, 2010 by Ronny Egner

The following illustrates the installation of Oracle 11g Release 2 database on Windows. Installation is quite straight forward. Before installing the database you can optionally install grid infrastructure which offers some nice feature – for instance Oracle Restart and ASM. … Continue reading →

Posted in Oracle in general | Leave a comment

11g Release 2 for Windows – Grid Infrastructure Installation for Single Databases

Posted on April 20, 2010 by Ronny Egner

The following pictures show the grid infrastructure installation of Oracle 11g Release 2 for Windows. This is a rather short posting without much text because the pictures are quite self-explaining. Requirements Windows Note there is no grid infrastructure or ASM … Continue reading →

Posted in Oracle in general | 8 Comments

11g Release 2 for Windows – Grid Infrastructure Installation Buggy?

Posted on April 17, 2010 by Ronny Egner

I just tried installing Oracle 11g Relese 2 on Windows 2008 R2 64-bit and Windows 2008. The system were installed with Windows 2008 and 2008 R2 standard edition 64-bit on a VMWARE server with 4 core with two core assigned … Continue reading →

Posted in Oracle in general | 59 Comments

Using EMC (formerly Legato) Networker with Opensolaris

Posted on April 16, 2010 by Ronny Egner

I have written an guest article (direct link) for Preston de Guises fine blog on how to use networker client on opensolaris.

Posted in Oracle in general | Leave a comment

Happy Easter: Oracle 11g Release 2 for Windows released

Posted on April 6, 2010 by Ronny Egner

As of April 5th Oracle released Oracle 11g Release 2 for Windows 32-bit and 64-bit. The software can be donwloaded from OTN. Update: I just noticed neither Clusterware (aka “RAC”) nor ASM are available for 32-bit Windows.

Posted in 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

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

Creating database clones with ZFS really FAST

Posted on February 17, 2010 by Ronny Egner

While working on my most recent project i tested an interesting ZFS feature: writeable snapshots aka “clones”. While testing i came to the conclusion that with the help of clones oracle databases (and, of course – other databases as well) … Continue reading →

Posted in Oracle in general | 3 Comments