Author Archives: Ronny Egner

Bye bye Oracle 10g Release 2

Posted on July 21, 2010 by Ronny Egner

With end of July 2010 support for Oracle 10g Release 2 ends. You can order (at additional costs of course) so called extended support to get support until July 2011. After this date there is so called “Sustaining Support” which … Continue reading →

Posted in Oracle in general | 6 Comments

Patch News – Oracle Patchset 10.2.0.5.0 released

Posted on May 19, 2010 by Ronny Egner

I just found Oracle released 10.2.0.5.0 patchset for the following platforms: Linux x86_64 Linux x86 See Doc ID 1088172.1 for a list of fixed problems.

Posted in Oracle in general | 1 Comment

Oracle 11g R2: Deferred Segment Creation + imp + table with LOB column = Bug

Posted on May 7, 2010 by Ronny Egner

This is a short posting about an error i found today. This errors prevents the import of tables with lob columns when using traditional import, deferred segment creation and an altered tablespace name. For this i created a test case … Continue reading →

Posted in Oracle in general | 2 Comments

ASM Volumes on thin-provisioned SAN dirtying all blocks?

Posted on May 4, 2010 by Ronny Egner

Some time ago i´ve seen a discussion on OTN about ASM and thin provisioned volumes. Hi there, sorry for the x-post from database-general but it was suggested that I do so. Anyhow, we’ve got 11g (11.1.0.7 with the 6851110 ASM … Continue reading →

Posted in Oracle in general | Leave a comment

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