Monthly Archives: September 2009

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

Storing Oracle database connection strings in OpenLDAP instead of OID

Posted on September 30, 2009 by Ronny Egner

Storing Oracle database connection strings in OpenLDAP – or – “Oracle Names for the masses” Typically Oracle stores it´s database connection strings in a file called TNSNAMES.ORA. Among storing every database connection string in this file there are other different … Continue reading →

Posted in Oracle in general | 21 Comments

Oracle 11g Release 2 – SSH equivalence gone after reboot

Posted on September 28, 2009 by Ronny Egner

Today i came across a strange phenomenon: I set up ssh equivalence during database installation but after rebooting the system some tool complained about misconfigured ssh equivalence. So i digged a little bit. I found out SSH is complaining about … Continue reading →

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

Partition layout on Linux – Recommendations

Posted on September 24, 2009 by Ronny Egner

Partition recommendations for Oracle on Linux Every system engineer or even every DBA comes along the following question from time to time: “How do i arrange my partitions for using oracle on linux?” In the following i am blogging my … Continue reading →

Posted in Oracle in general | 4 Comments

Increasing data checks performed by RMAN with "check logical" switch

Posted on September 24, 2009 by Ronny Egner

By default RMAN checks for physical corruptions in data files when performing backups. For a logical check you can add “check logical” to your rman backup command. With this clause rman also checks the block integrity logically. A few examples … Continue reading →

Posted in Oracle in general | Leave a comment

RMAN in Data Guard configurations – Problems of restoring rman disk backups and standby site and vice versa

Posted on September 24, 2009 by Ronny Egner

… or: the problem of backup association From time to time i come across the same problems in data guard configurations using rman-to-disk: Backups taken on the standby database are not taken into account when trying to perform an rman … Continue reading →

Posted in Oracle in general | 3 Comments

Managing the AWR (automatic workload repository)

Posted on September 24, 2009 by Ronny Egner

Overview on the AWR The automatic workload repository “AWR” was introduced with Oracle 10g. It collects performance data in intervals (default: 60 minutes) and keeps them by default for one week. The data is stored in the SYSAUX tablespace. The … Continue reading →

Posted in Oracle in general | 1 Comment

Oracle 11 Release 2 Install Guide – Install Oracle RAC

Posted on September 23, 2009 by Ronny Egner

System configuration Hardware configuration two virtual machines (VMWARE) 1 vCPU 4 GB RAM 40 GB local Disk Storage exported via ISCSI 4 LUNs with 10 GB each 2 LUNs with 30 GB each Operating system configuration Oracle Enterprise Linux 5.3 … Continue reading →

Posted in Oracle 11g Release 2 | 6 Comments