Author Archives: Ronny Egner

Useful ASM scripts and queries

This short post covers some useful ASM queries and scripts. chk_asm_mapping.sh The following is a script i found somewhere on the web. Unfortunately it was not totally correct for newer asm libraries. The script itself: /etc/init.d/oracleasm querydisk -d `/etc/init.d/oracleasm listdisks … Continue reading

Posted in Oracle in general | 5 Comments

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

In this post we will terminating the private network interconnect between the two nodes by moving node “rac1” lan interfaces to a different vlan. This will result in still connected network ports but interrupted connectivity.

Posted in Oracle in general | 2 Comments

Oracle 11g Release 2 – AWR emergency purging

During the night my SYSAUX tablespace filled up to the maximum allowed size so AWR could not save it´s data. In the database alert.log i found the following: Tue Oct 06 02:02:38 2009 ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition … Continue reading

Posted in Oracle in general | 1 Comment

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

In the first test we will just disable one node under normal load. Lets see what the different components (clusterware, asm instance, advm/acfs) report:

Posted in Oracle in general | 2 Comments

ASM resilvering – or – how to recover your crashed cluster – the Environment

We use the same environment we installed here which consists of two virtual machines running Oracle Enterprise Linux 5 Update 3 64-bit with Oracle 11g Release 2 (Grid Infrastructure and Oracle binaries) installed. All data is placed in ASM with … Continue reading

Posted in Oracle in general | 1 Comment

Is it allowed to quote Metalink Notes completely or partially?

Writing posts for this blog i wondered: Am i allowed to post Metalink Notes entirely or partially in my blog posts? Looking at the web i did not find any information. I might have read the Oracle Support License but … Continue reading

Posted in Oracle in general | Leave a comment

ext3 – beware of periodic file system checks

Users running Oracle on Red Hat or Oracle Enterprise Linux will most probaly use ext3 as default file system. It is robust, well maintained, a journaling file system and supports file system sizes up to 32 TB. Database servers must … Continue reading

Posted in Oracle in general | 5 Comments

Oracle 11g Release 2 – How to enable SSH equivalence

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

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

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