VMCD.ORG

Focus on DB architect mail:ylouis83#gmail.com

ASM memory fragment problem in 11gR2 RAC

Posted by admin on 7th June 2013

前天处理了一启RAC ASM 内存泄露问题,系统为公司最后一套RAC one node 版本为11.2.0.3

这套核心RAC one node系统出现大量 log file switch buffer busy waits等待,并伴随大量cursor: pin S wait on X re[……]

Read more

Tags:
Posted in Oracle Experience | No Comments »

Solaris 10g CRS 自动reboot一例

Posted by admin on 18th October 2012

最近RAC 的case实在太多,越来越觉得公司逐渐去rac的正确。一套sunOS的系统 在安装完crs 10g之后 服务器不停的自动reboot,具体环境如下:

root@bmsa#showrev 
Hostname: bmsa
Hostid: 84f94303
Release: 5.1[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

11gR2 rac install ASM terminating the instance due to error 481

Posted by admin on 16th October 2012

一套新上线的RAC系统(redhat 5.8 RAC 11.2.0.3) 安装过程中跑GI root.sh时抛出error 481错误:

CRS-2672: Attempting to start 'ora.asm' on 'ptdb1'
CRS-50[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

CRS troubleshooting 两例

Posted by admin on 11th September 2012

一套10.2.0.5 RAC 系统 evmd cssd服务无法启动

CRS version

[oracle@ptdb02 oracle]$ crsctl query crs softwareversion
CRS software version on node [ptdb02] is[……]

Read more

Tags:
Posted in Oracle Experience | No Comments »

11gR2 RAC listener

Posted by admin on 18th August 2012

oracle 11gR2 rac listener引入了3项主要的改变:

1. listener默认owner为grid

[oracle@db-42 ~]$ srvctl config listener
Name: LISTENER
Network: 1, Owner: grid[……]

Read more

Tags:
Posted in Oracle Experience | No Comments »

11gR2 RAC Rebootless Node Fencing

Posted by admin on 6th March 2012

Rebootless Node Fencing

In versions before 11.2.0.2 Oracle Clusterware tried to prevent a split-brain with a fast reboot (better: reset) of the[……]

Read more

Tags:
Posted in Oracle Experience | No Comments »

Recommendation for the Real Application Cluster Interconnect and Jumbo Frames

Posted by admin on 9th February 2012

Recommendation for the Real Application Cluster Interconnect and Jumbo Frames

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.0 - Release: 9.2 to 11.2
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 9.2.0.1 to 11.2
Purpose
 
This note covers the current recommendation for the Real Application Cluster Interconnect and Jumbo Frames
Scope and Application
 
This article points out the issues surrounding Ethernet Jumbo Frame usage for the Oracle Real Application Cluster (RAC) Interconnect. In Oracle Real Application Clusters, the Cluster Interconnect is designed to run on a dedicated, or stand-alone network. The Interconnect is designed to carry the communication between the nodes in the Cluster needed to check for the Clusters condition and to synchronize the various memory caches used by the database.

Ethernet is a widely used n[……]

Read more

Tags:
Posted in Oracle Experience | 2 Comments »

Configuring Temporary Tablespaces for RAC Databases for Optimal Performance

Posted by admin on 6th January 2012

Configuring Temporary Tablespaces for RAC Databases for Optimal Performance
Modified 04-AUG-2010 Type BULLETIN Status ARCHIVED
In this[……]

Read more

Tags:
Posted in Oracle Experience | No Comments »

关于redhat 5.5安装10g Rac的问题总结

Posted by admin on 11th December 2011

环境:redhat 5.5+oracle 10g rac+netapp

首先碰到DMM问题,netapp存储通过DMM软件mapping过来的设备 oracle无法识别 报如下错误:

the location /dev/mapper/ocr1 ,entered for the oracl[……]

Read more

Tags:
Posted in Oracle Experience | No Comments »

[转] cluvfy使用说明

Posted by admin on 9th December 2011

在安装rac之前,可以通过Oracle提供的一个工具进行cluster环境验证,这个工具叫做cluvfy(Cluster Verification Utility)。

一、CVU程序的位置

OTN下载: http://otn.oracle.com/RAC

Oracle DVD[……]

Read more

Tags:
Posted in Oracle Experience | No Comments »