-
Archives
- April 2019
- March 2019
- September 2018
- August 2016
- July 2016
- May 2015
- April 2015
- December 2014
- November 2014
- August 2014
- February 2014
- January 2014
- November 2013
- July 2013
- June 2013
- March 2013
- December 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- March 2012
- October 2011
- August 2011
- June 2011
- May 2011
- April 2011
- March 2011
- December 2010
- November 2010
- October 2010
- August 2010
- July 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
-
Meta
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