RAC中通过nkmod解决各个节点盘符不一致问题
Node #1:crw-r?????? 1 root sys 118, 40 Apr 2 15:00 /dev/rdsk/disk78crw-r?????? 1 root sys 118, 0 Apr 2 15:00 /dev/rdsk/disk79crw-r?????? 1 root sys 118, 42 Apr 2 15:00 /dev/rdsk/disk80Create the alias:# mkdir /asmdisks# chown oracle:dba /asmdisks# cd /asmdisks...
TAF 与JDBC
JDBC-THINdriver supports Fast Connection Failover (FCF)JDBC-THIN驱动支持FCFJDBC-OCIdriver supports Transparent Application Failover (TAF)JDBC-OCI 支持TAFJDBC-THIN11gR2 supports Single Client Access Name (SCAN)JDBC-THIN11gR2支持 SCANJDBC-OCI 支持TAF 在DocID 2974...
11gr2 RAC配置Service-Side TAF
10g可以用dbca 来配置TAF 11.2以后只能通过命令和EM方式来实现,命令方式试验结果如下:1 创建TAF服务srvctladd service -d orcl -s orcl_taf -r "orcl1,orcl2" -P BASIC2 启动TAF服务srvctlstart service -d orcl -s orcl_taf 3 修改service 参数...
ORACLE RAC 手动建库
环境11.2.0.1 RAC前提条件Grid Infrastructure已经安装 ASM已经创建 DB软件已经安装通过手动创建RAC可以更深的理解单实例DB和RAC DB 的一些区别,在DBCA无法使用的场景中,也需要手动的方式创建,创建步骤如下:大概思路:先创建单实例DB再转为RAC DB1. ...
10g RAC升级到11gr2 RAC
1 创建目录mkdir -p /u01/app/11.2.0/gridchown –R oracle:oinstall /u01/app/11.2.0/grid 2 Backup the database:使用rman全备数据库 3 Backup the OCR file Backu...
Checklist for PRVF-10037 : Failed to retrieve storage type for xx on node xx
(Doc ID 1233505.1)APPLIES TO:Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later [Release: 11.2 and later ]Information in this document applies to an...
Data Collecting for Troubleshooting (CRS or GI) And (RAC) Issues
In this Document (Doc ID 289690.1)Purpose File Formats for Data Uploaded to Oracle SupportTroubleshooting Steps 1. Data Gathering for All Oracle Clusterware Issues 2. Data Gatherin...
【RAC工具】cluvfy
【RAC工具】cluvfy 一、CVU介绍Cluster Verification Utilit(CVU)是Oracle所推荐的一种集群检验工具,CVU可以验证在主群集组件在运作阶段或时期。组件可以是基本的,如免费的磁盘空间,或者也可以是复杂的,...
CRS-2409:The clock on host is not synchronous with the mean cluster time
Oracle Server - Enterprise Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]Information in this document applies to any platform.SYMPTOMSCTSSD runs in observer mode even though no time sync softwa...
SSH and Xauth Warning Before RAC 10g Installation [ID 285070.1]
The information in this article applies to: - Redhat Advanced Server 3.0- Oracle 10G CRS installationSymptoms~~~~~~~~When trying to setup ssh as specified in the 10g CRS installation guide, yo...
10G RAC重新执行root.sh脚本
1,ps -ef|grep crs;ps -ef|grep crs;ps -ef|grep evm2,kill -9 以上的pid3,rm相当的init进程(crs,evm,css)-Sun:rm /etc/init.d/init.cssdrm /etc/init.d/init.crsrm /etc/init.d/init.crsdrm /etc/init.d/init.evmdr...
手动清除Oracle 10g RAC CRS的方法
在安装clusterware时如果出现报错现象,需要重新安装时,必须先清除已经安装的cluserware,否则可能会影响到下次安装。一般情况下,只需要在各节点上依次运行目录$ORA_CRS_HOME/install/下的脚本rootdelete.sh和root...
11g RAC OCR备份与恢复
Backing Up Oracle Cluster RegistryThis section describes how to back up OCR content and use it for recovery. The first method uses automatically generated OCR copies and the second method enables...
11.2 voting disk的备份及恢复
Backing Up Voting DisksIn Oracle Clusterware 11g release 2 (11.2), you no longer have to back up the voting disk. The voting disk data is automatically backed up in OCR as part of any config...
CRS-1606 诊断分析
CRS-1606 CSSD Insufficient voting files available [%s of %s]. Details in %s.表示可用的VOTE盘不够一般和存储 或者 SAN引起的 VOTE盘不可用 MOS有一篇关于11.2以后的版本诊断的文章Oracle Grid Infrastruc...
10gR2 RAC Install issues on Oracle EL5 or RHEL5
10gR2 RAC Install issues on Oracle EL5 or RHEL5 or SLES10 (VIPCA / SRVCTL / OUI Failures) [ID 414163.1]Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.3 [R...
利用UDEV配置OCR VOTE(基于整个磁盘)
CRS的共享磁盘存储OCR\VOTEDISK数据,11G之前,OUI不支持对block设备的直接读取(虽然从10.2.0.2开始,ORACLE可用O_DIRECT标志读取block设备,但OUI还是不支持该特性),一般在CRS安装前将block设备映射为raw设备(...
客户端连接RAC报ora-12545
Client Connection to RAC Intermittently Fails-ORA-12545 TNS: Host or Object Does not Exist [ID 364855.1]Applies to:Oracle Net Services - Version 10.2.0.5 to 11.2.0.3 [Release 10.2 to 1...
How to Validate Network and Name Resolution Setup for the Clusterware and RAC
[ID 1054902.1]Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]Information in this document applies to any platform.PurposeCluster Verification Utility (ak...
【转载】Oracle RAC 常用维护工具和命令
转载地址:http://blog.csdn.net/tianlesoftware/article/details/5358573Oracle 的管理可以通过OEM或者命令行接口。 Oracle Clusterware的命令集可以分为以下4种:节点层:osnodes网络层:oifcfg集...