-
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
Monthly Archives: October 2009
New public oracle yum server
I just found a new public yum server hosted by oracle. This server can be used to install missing packages over the internet. It does not contain any security updates or bug fixes. The public yum server can be found … Continue reading
Posted in Oracle in general
3 Comments
Configuring a small DNS server for SCAN
A few users asked what to do if there is no DNS server available for configuring the SCAN names when installing oracle grid infrastructure. Most asked if they can use hosts file entries. The short answer is: Nope. The grid … Continue reading
Posted in Oracle in general
28 Comments
ASM resilvering – or – how to recover your crashed cluster – Test no 4
Test #4: Corrupting the ASM disk with ASM disk group being online and active After overwriting the ASM disk header while the disk group was offline we will now put some load on the full running cluster and corrupt the … Continue reading
Posted in Oracle 11g Release 2, Oracle ASM
3 Comments
The Oracle Database File System (DBFS)
The following post is a summary of my tests with DBFS on a 11g Release 2 RAC. DBFS – An Overview Since the introduction of LOBs the database was used to store all kinds of files, for instance images, audio … Continue reading
Posted in Oracle 11g Release 2, Oracle in general
6 Comments
ORA-12157 TNS:internal network communication error when connecting after fresh installation
Recently i came across a problem i thought was fixed since 10g: After a fresh installation of oracle 10g when trying to connect to the instance (for instance to create the database for the first time) you get the following … Continue reading
Posted in Oracle in general
1 Comment
ASM resilvering – or – how to recover your crashed cluster – Test no 3
Test #3: Overwriting the ASM disk header with ASM disk group being offline In this post we will dig a little bit deeper with ASM. We will overwrite the ASM disk header on one disk while the disk group is … Continue reading
Posted in Oracle in general
8 Comments
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