【RAC】How to Troubleshoot Grid Infrastructure Startup Issues [ID 1050908.1]
Applies to:Oracle Server – Enterprise Edition – Version: 11.2.0.1 and later [Release: 11.2 and later ]Information in this document applies to any platform.GoalThis goal of the note is to prov...
【RAC】upgrade GI from11.2.0.1 to 11.2.0.2
升级整个rac 环境则需要先升级Clusterware 层,然后升级Database/RDBMS,整个过程可以选择滚动升级也可以选择将数据库停掉,这个要根据生产库的停机维护窗口来定了。此文描述了非滚动升级的方式!实际过程中要更...
【RAC,DATAGUARD】Creating a physical standby from ASM (RAC ) primary之四
oracle@rac1:/home/oracle>rman target sys/yang402@rac auxiliary sys/yang402@yangdbRecovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 15 15:46:58 2011Copyright (c) 1982, 2009, Oracle and/or it...
【RAC】Creating a filesystem physical standby from ASM (RAC ) primary之三
Starting backup at 11-SEP-11RMAN-03009: failure of backup command on c1 channel at 09/11/2011 17:48:09ORA-19505: failed to identify file "/opt/rac/oracle/11.2.0/db/dbs/orapwrac1"ORA-27037: unable ...
【RAC】Creating a filesystem physical standby from ASM (RAC ) primary 之二
oracle@rac3:/opt/oracle/11.2.0/yangdb/dbs>rman target sys/yang402@rac auxiliary /Starting Duplicate Db at 08-SEP-11released channel: c1released channel: s1released channel: s2RMAN-00571: =======...
【RAC】Creating a filesystem physical standby from ASM (RAC ) primary之一
环境:版本 11.2.0.1 1 primary : name: rac ip: 10.250.7.226 scan ip:10.250.7.200 使用ASM存储数据...
【RAC】PRVF-4664/4657: Found inconsistent name resolution entries for SCAN name
涉及到的版本: 11.2.0.1 to 11.2.0.2 - Release: 11.2 to 11.2现象:After successful 11gR2 Grid Infrastructure clusterware (CRS) installation or upgrade, INS-20802 reported while running Oracle Clus...
【RAC]升级RAC from 11.2.0.1 to 11.2.0.2 on Linux x86_64
执行到最后遇到一个错误,信息如下:[INS-20802] Oracle Cluster Verification实用程序失败。原因-插件的执行方法失败操作-参考日志或与Oracle技术支持联系。日志文件位置:/opt/rac/oraInventory/logs/installAction...
【RAC】failed to online diskgroup resource ora.GI.dg
ALERT.LOG for ASM Shows "WARNING: failed to online diskgroup resource ora.GI.dg (unable to communicate with CRSD/OHASD)" [ID 1060920.1]现象:If OCR is located on ASM diskgroup, following shows in ASM ...
【RAC】Diskgroup shows offline after restart even it is mounted in ASM instance
Diskgroup resource shows status offline after restart even it is mounted in ASM instanceApplies to:Oracle Server - Enterprise Edition - Version: 11.2.0.1.0 - Release: 11.2Information in this document ...
【RAC】asm_diskgroups 参数
初始化参数asm_diskgroups指定了在ASM实例启动时,或执行alter diskgroup all mount语句时,被挂载的磁盘组的名字,即当ASM实例启动的时候,会挂载这个参数指定的所有磁盘组,或当执行alter diskgroup all mount/dis...
【RAC】 oracleasm 工具对应的日志记录
因为删除Clusterware之后,ocr还在磁盘中,使用dd命令格式化磁盘,但是oracle提供了oracleasm工具,所以看看oracleasm deletedisk的操作具体做了什么-------------------------------------------------------------...
【RAC】ORA-15055: unable to connect to ASM instanceORA-12547: TNS:lost contact
rac 安装完成,关闭之后重启数据库遇到如下错误:oracle@rac1:/tmp>sqlplus "/as sysdba"SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 2 13:17:14 2011Copyright (c) 1982, 2009, Oracle. All rights ...
【RAC】关闭Clusterware 遇到CRS-2529,ORA-15097:
需要关闭整个集群,遇到CRS-2529,ORA-15097 错误 ~!grid@rac1:/home/grid/Opatch>srvctl stop asm -n rac1 -o immediate PRCR-1014 : 无法停止资源 ora.asmPRCR-1065 : 无法停止...
【RAC】节点2上不能完全识别节点1上的asmdisk
当主节点安装oracleasm disk[root@rac1 dev]# /etc/init.d/oracleasm deletedisk /dev/sdc1 VOL01 Removing ASM disk "/dev/sdc1":  ...