RAC

Recommendation for the Real Application Cluster Interconnect and Jumbo Frames

February 9, 2012 Architect, oracle, RAC, software 2 comments

Recommendation for the Real Application Cluster Interconnect and Jumbo Frames

Applies to:

Oracle Server – Enterprise Edition – Version: 9.2[……]

Read more

Configuring Temporary Tablespaces for RAC Databases for Optimal Performance

January 6, 2012 oracle, RAC No comments

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

Read more

快速升级Oracle 11.2.0.2 RAC到11.2.0.3 on Windows 2008

December 18, 2011 11g, oracle, RAC No comments

基于windows 2008平台升级rac 11.2.0.2.0->11.2.0.3.0

OS环境windows 2008 x64 数据库环境oracle 11g rac ,version 11.2.0.2.0 64bit

SQL> conn / as sysdba
已连接。
S[……]

Read more

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

December 11, 2011 oracle, RAC No comments

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

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

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

Read more

[转] cluvfy使用说明

December 9, 2011 oracle, RAC No comments

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

一、CVU程序的位置

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

Oracle DVD[……]

Read more

[转] Oracle 10g RAC中的DRM问题及关闭

December 1, 2011 Internals, oracle, RAC 2 comments

在RAC环境中,Oracle使用GRD(Global Resource Service)来记录各个RAC节点的资源信息,具体通过GCS(Global Cache Service)和GES(Global Enqueue Service)这两个服务进行管理。
由于在RAC中每个节点都有自己的SGA和b[……]

Read more

Oracle 9i 单节点文件系统 升级到 10g RAC

November 10, 2011 migration, oracle, RAC No comments

最近做了一次Oracle 9i 升级到10g RAC 的测试,现做如下简要记录:
1.查看目前数据库版本

SQL> select * from v$version;

BANNER
—————————————————[……]

Read more

一次cursor: pin S wait on X的解决

November 2, 2011 oracle, RAC 3 comments

环境描述:双节点rac 数据库版本10.2.0.5 通过awr发现down机时间段产生大量的cursor: pin S wait on X等待,同时伴随大量的library latch等待,通过与相关人员沟通得知,此库在每月的月头都会有大量的报表业务,从而负载将会增长几十倍之多。通过下面
的awr[……]

Read more

Why ASMLIB and why not?

October 19, 2011 oracle, RAC 2 comments

ASMLIB是一种基于Linux module,专门为Oracle Automatic Storage Management特性设计的内核支持库
(kernel support library)。
长久以来我们对ASMLIB的认识并不全面,这里我们来具体了解一下使用ASMLIB的优缺点。[……]

Read more