前几天在VMWare上安装了RAC,安装过程中以及今天在启动时都出了几个错误,简要记录下:
1.配置 Oracle 集群文件系统 (OCFS2)出错:
# ocfs2console Configure Nodes --> Add --> 输入NODE名和IP --> OK --> Apply 出现如下错误: o2cb_ctl: Unable to access cluster service while creating node Could not add node node1
|
解决办法:先把/etc/ocfs2/下的cluster.conf文件删掉,重新配置就可以了。
2.DBCA创建数据库过程中进行到拷贝安装文件至远程节点时出错:
WARNING: Error while copying directory /u01/oracle/product/10.2.0/db_1 with exclude file list '/tmp/OraInstall2008-12-27_01-48-46PM/installExcludeFile.lst' to nodes 'rac1'. [PRKC-1002 : All the submitted commands did not execute successfully] ---------------------------------------------------------------------------------- rac1: /bin/tar: ./assistants/rconfig/sampleXMLs: time stamp 2008-12-27 13:25:06 is 768 s in the future /bin/tar: ./assistants/rconfig: time stamp 2008-12-27 13:24:34 is 736 s in the future /bin/tar: ./assistants/jlib: time stamp 2008-12-27 13:25:19 is 781 s in the future …… ---------------------------------------------------------------------------------- Refer to '/u01/oracle/oraInventory/logs/installActions2008-12-27_01-48-46PM.log' for details. You may fix the errors on the required remote nodes. Refer to the install guide for error recovery. Click 'Yes' if you want to proceed. Click 'No' to exit the install. Do you want to continue? |
解决办法:这种错误是因为节点间时间不同步造成的。这种情况下可以选择"Yes"忽略此错误,继续往下。
3.启动RAC过程中出错:
rac2-> srvctl start nodeapps -n rac1 CRS-1028: Dependency analysis failed because of: CRS-0223: Resource 'ora.rac1.gsd' has placement error. CRS-1028: Dependency analysis failed because of: CRS-0223: Resource 'ora.rac1.ons' has placement error. CRS-1028: Dependency analysis failed because of: CRS-0223: Resource 'ora.rac1.LISTENER_RAC1.lsnr' has placement error.
|
查看CRS状态:
rac2-> crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.....crm.cs application OFFLINE OFFLINE ora....db1.srv application OFFLINE OFFLINE ora.devdb.db application ONLINE UNKNOWN rac1 ora....b1.inst application ONLINE OFFLINE ora....b2.inst application ONLINE OFFLINE ora....SM1.asm application ONLINE UNKNOWN rac1 ora....C1.lsnr application ONLINE UNKNOWN rac1 ora.rac1.gsd application ONLINE UNKNOWN rac1 ora.rac1.ons application ONLINE UNKNOWN rac1 ora.rac1.vip application ONLINE ONLINE rac1 ora....SM2.asm application ONLINE UNKNOWN rac2 ora....C2.lsnr application ONLINE UNKNOWN rac2 ora.rac2.gsd application ONLINE UNKNOWN rac2 ora.rac2.ons application ONLINE UNKNOWN rac2 ora.rac2.vip application ONLINE ONLINE rac2
|
发现很多服务都不正常,尝试使用crs_start -all 启动:
rac2-> crs_start -all CRS-1028: Dependency analysis failed because of: 'Resource in UNKNOWN state: ora.rac1.ASM1.asm' CRS-1028: Dependency analysis failed because of: 'Resource in UNKNOWN state: ora.rac2.ASM2.asm'
Attempting to start `ora.devdb.crm.cs` on member `rac1` Attempting to start `ora.devdb.crm.devdb1.srv` on member `rac1` Start of `ora.devdb.crm.devdb1.srv` on member `rac1` failed. Attempting to start `ora.devdb.crm.devdb1.srv` on member `rac2` Start of `ora.devdb.crm.devdb1.srv` on member `rac2` failed. CRS-1006: No more members to consider Start of `ora.devdb.crm.cs` on member `rac1` failed. Attempting to start `ora.devdb.crm.cs` on member `rac2` Start of `ora.devdb.crm.cs` on member `rac2` failed. CRS-1006: No more members to consider CRS-0215: Could not start resource 'ora.devdb.crm.cs'. CRS-0215: Could not start resource 'ora.devdb.crm.devdb1.srv'. CRS-0223: Resource 'ora.devdb.devdb1.inst' has placement error. CRS-0223: Resource 'ora.devdb.devdb2.inst' has placement error.
|
竟然不成功,于是尝试一个个重新启动:
rac2-> crs_start ora.rac1.gsd CRS-1028: Dependency analysis failed because of: 'Resource in UNKNOWN state: ora.rac1.gsd' CRS-0223: Resource 'ora.rac1.gsd' has placement error.
|
靠,还是不成功,先STOP:
rac2-> crs_stop ora.rac1.gsd Attempting to stop `ora.rac1.gsd` on member `rac1` Stop of `ora.rac1.gsd` on member `rac1` succeeded. rac2-> crs_start ora.rac1.gsd Attempting to start `ora.rac1.gsd` on member `rac1` Start of `ora.rac1.gsd` on member `rac1` succeeded. |
耶,成功,于是逐个先stop后start。不过发现"ora.rac1.ASM1.asm"服务竟然有大小写区分:
rac2-> srvctl start asm -n rac1 PRKS-1009 : Failed to start ASM instance "+ASM1" on node "rac1", [PRKS-1009 : Failed to start ASM instance "+ASM1" on node "rac1", [CRS-1028: Dependency analysis failed because of: CRS-0223: Resource 'ora.rac1.ASM1.asm' has placement error.]] [PRKS-1009 : Failed to start ASM instance "+ASM1" on node "rac1", [CRS-1028: Dependency analysis failed because of: CRS-0223: Resource 'ora.rac1.ASM1.asm' has placement error.]] rac2-> crs_stop ora.rac1.asm1.asm CRS-0210: Could not find resource 'ora.rac1.asm1.asm'.
rac2-> crs_start ora.rac1.asm1.asm CRS-0210: Could not find resource 'ora.rac1.asm1.asm'. rac2-> crs_start ora.rac1.ASM1.asm CRS-1028: Dependency analysis failed because of: 'Resource in UNKNOWN state: ora.rac1.ASM1.asm' CRS-0223: Resource 'ora.rac1.ASM1.asm' has placement error. rac2-> crs_stop ora.rac1.ASM1.asm Attempting to stop `ora.rac1.ASM1.asm` on member `rac1` Stop of `ora.rac1.ASM1.asm` on member `rac1` succeeded. CRS-1016: Resources depending on 'ora.rac1.ASM1.asm' are running CRS-0223: Resource 'ora.rac1.ASM1.asm' has placement error. rac2-> crs_start ora.rac1.ASM1.asm Attempting to start `ora.rac1.ASM1.asm` on member `rac1` Start of `ora.rac1.ASM1.asm` on member `rac1` succeeded.
|
最后检查crs状态,都正常:
rac2-> crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.....crm.cs application ONLINE OFFLINE ora....db1.srv application ONLINE OFFLINE ora.devdb.db application ONLINE OFFLINE ora....b1.inst application ONLINE OFFLINE ora....b2.inst application ONLINE OFFLINE ora....SM1.asm application ONLINE ONLINE rac1 ora....C1.lsnr application ONLINE ONLINE rac1 ora.rac1.gsd application ONLINE ONLINE rac1 ora.rac1.ons application ONLINE ONLINE rac1 ora.rac1.vip application ONLINE ONLINE rac1 ora....SM2.asm application ONLINE ONLINE rac2 ora....C2.lsnr application ONLINE ONLINE rac2 ora.rac2.gsd application ONLINE ONLINE rac2 ora.rac2.ons application ONLINE ONLINE rac2 ora.rac2.vip application ONLINE ONLINE rac2 |
分享到:
相关推荐
Oracle 19c CDB RAC To RAC ActiveDataguard部署方案
浦东机场货运站核心数据库升级至Oracle RAC 11gR2。操作系统采用RedHat Enterprice Linux 6.3 x64,操作系统平台为x86-64。 Oracle网格管理器和数据库安装版本为11.2.0.3.,并且升级GI和DB至PSU 6,数据共享存储采用...
目录 推荐序 前言 第1章 认识Oracle RAC 1.1 RAC产生的背景 1.2 RAC体系结构 1.2.1整体结构 1.2.2物理层次结构 1.2.3逻辑层次结构 1.3 RAC的特点 ...1.4 RAC存在的问题 ...1.5 RAC软件 ...15.5本章小结
1,Oracle19c RAC+ RACDG配置详细部署文档 2,Oracle19c RAC+ RACDG+racdg2配置详细部署文档 涉及主库备库参数配置、spfile、crs资源配置更新及实施过程中故障排除等; 来自于现实上亿级生产系统的实操记录。
Linux 常用命令 oracle rac 中文手册 官网翻译 oracle rac
文章描述如何设置oracle 11.2.0.4 的 RAC to RAC dataguard.
rac节点架构图,图片,便与你更加形象的了解rac
RAC启动
oracle 19c容器多租户 rac to rac的adg测试部署方案,完全实测步骤。 使用了DG_BROCKER管理,方便switchover。
某客户需要将一套Oracle 10gR2 双节点RAC 生产数据库升级至Oracle 11gR2 RAC,所以便有了本系列实战的教程。 为更贴切还原生产过程中的实际操作,本系列教程一个分两大部分: 第一部分已发 一步一步在Linux上部署...
Oracle RAC 2 RAC DataGuard 配置,主要详述备份恢复方式搭建dataguard
orace RAC for vmware
资源名称:深入理解Oracle RAC 12c内容简介:《深入理解Oracle RAC 12c》介绍了Oracle RAC 12c技术的方方面面,涵盖了与RAC技术相关的集群件知识、数据库知识、存储知识、网络知识,并在基于RAC的应用软件设计、优化...
RAC-小布老师rac部署文档图解 里面介绍的非常详细,绝对是好资料
【RAC】rac数据库的备份和恢复rac数据库的备份和恢复.pdf