oracle crs 配置错误详解.docx

1、oracle crs 配置错误详解oracle crs 配置错误详解*PRKP-1001 CRS-0215*当我们在安装Clusterware 的时候， 需要在第二节点上vipca , 配置到最后安装的时候， 安装到 75% 左右，报错：CRS-0215 : Could not start resource ora.mxb2bcoredb01.ons.Check the log file /u01/product/crs/log/mxb2bcoredb01/racg/ora.mxb2bcoredb01.ons.log and fix the problem before retrying./e

2、tc/hosts 文件配置不对 127.0.0.1 localhost *OUI-25031 *检查linux主机名是否符合规范，因为oracle不是直接获取IP地址的，而是通过解析主机名来获取IP的hostname 检查主机名 两个文件 /etc/sysconfig/network /etc/hosts 添加一项 主机ip 主机名 *ASM装载磁盘组时ORA-15063错误处理 *可以看到这个错误是由于ASM实例无法装载硬盘组的所有磁盘而引起的，有可能是权限问题。马上想到是否是由于OS重启后祼设备的用户、权限是否变更，导致ORACLE用户没有权限访问祼设备。将祼设备的权限更改完后，果然ASM

3、能够正常启动。其实这个问题还是很简单的，LINUX启动后默认会把祼设备的拥有者改为root用户，只需把/etc/udev/permissions.d/50-udev.permissions 这个文件中的行“raw/*:root:disk:0660”注释掉，添加新行“raw/*:oracle:dba:0660”，这样系统启动后祼设备的拥有者就变为ORACLE用户了，当然如果祼设备还有其他用户的话，那么就需要针对不同的祼设备进行更改了。为了防止下次再出现这种情况，可以采用如下的解决方法在/etc/rc.local中加入chown oracle:dba /dev/raw/raw1执行root.sh

4、脚本 卡住Raw 权限不够*无法读取init+ASM.ora 文件 *配置文件 .bash_profile ORACLE_SID 不正确在dbs目录下vi一个init+ASM.ora内容如下：asm_diskgroups=DATAasm_diskstring=/dev/rdsk/*background_dump_dest=/oracle/ora10g/admin/+ASM/bdumpcore_dump_dest=/oracle/ora10g/admin/+ASM/cdumpinstance_type=asmlarge_pool_size=12Mremote_login_passwordfile

5、=SHAREDuser_dump_dest=/oracle/ora10g/admin/+ASM/udump然后$export ORACLE_SID=+ASM$sqlplus / as sysdbaCRS-0213 *ASM重建过程*node1&node2都运行一下命令 cd /opt/ora10g/product/10.2.0/db_1/dbs rm -rf * cd /opt/ora10g/admin rm -rf *dd if=/dev/zero of=/dev/raw/raw3 bs=8192 count=12800 dd if=/dev/zero of=/dev/raw/raw4 bs

6、=8192 count=12800dd if=/dev/zero of=/dev/raw/raw1 bs=8192 count=12800crs disk dd if=/dev/zero of=/dev/raw/raw2 bs=8192 count=12800vot disk /etc/init.d/oracleasm createdisk NOVA1 /dev/sdd1 /etc/init.d/oracleasm createdisk NOVA2 /dev/sde1 vi /etc/oratab 删除+ASM相关字段crs_unregister ora.node2.ASM2.asm crs_

7、unregister ora.node1.ASM1.asm*删除ASM实例的方法*先停掉一个节点的ASM实例 oraclenode1 $ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 Production on Sun Apr 26 14:56:13 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 Production With the

8、 Partitioning, Real Application Clusters, OLAP and Data Mining optionsSQL select instance_name from v$asm_client;no rows selectedSQL select name from v$asm_diskgroup;NAME RAC_DISKSQL drop diskgroup RAC_DISK including contents ;Diskgroup dropped. SQL shutdown immediate ORA-15100: invalid or missing d

9、iskgroup name ASM instance shutdownoraclenode1 $ oradism -delete -asmsid +ASM oraclenode1 $ oradism -delete -asmsid +ASM1 oraclenode1 $ oradism -delete -asmsid +ASM2 srvctl stop asm -n node1 srvctl stop asm -n node2oraclenode2 $ crs_stat -t Name Type Target State Host ora.SM1.asm application ONLINE

10、ONLINE node1 ora.E1.lsnr application OFFLINE OFFLINE ora.node1.gsd application ONLINE ONLINE node1 ora.node1.ons application ONLINE ONLINE node1 ora.node1.vip application ONLINE ONLINE node1 ora.SM2.asm application ONLINE OFFLINE ora.E2.lsnr application OFFLINE OFFLINE ora.node2.gsd application ONLI

11、NE ONLINE node2 ora.node2.ons application ONLINE ONLINE node2 ora.node2.vip application ONLINE ONLINE node2 oraclenode2 $ crsctl check crs CSS appears healthy CRS appears healthy EVM appears healthysrvctl add asm -n node1 -i +ASM1 -o /opt/ora10g/admin删除自动存储管理实例+ASM 实例+ASM的删除是在数据库被卸载之后完成的，并删除/ORACLE_

12、HOME/dbs目录下的所有文件(除了与ASM相关的)。因此必须完成下列步骤： 1）在命令提示符中，设置oracle_sid环境变量为+ASM实例： # export oracle_sid=+ASM 2）启动SQL*Plus并以sys用户连接到自动存储管理+ASM实例： # sqlplus / as sysdba 3）使用下列命令来确定是否有数据库实例正在使用自动存储管理实例+ASM： SQLselect instance_name from v$asm_client; 该命令结果列出所有正在运行并使用+ASM实例的数据库实例。只要+ASM包含正在支持的数据库实例，就不能删除该+ASM实例。

13、4）如果没有与+ASM相关联的数据库实例，则删除与该实例相关联的磁盘组。 首先，识别与+ASM相关联的磁盘组： SQLselect name from v$asm_diskgroup; 其次，用下列命令删除每个要删除的磁盘组： SQLdrop diskgroupincluding contents; 5）关闭+ASM实例并退出SQL*Plus： SQLshutdown SQLexit 6）在命令提示符中输入下列命令，删除+ASM服务： oradim -delete -asmsid +ASM*crs_stop -all 命令后遇到 UNKNOWN*RAC中执行crs_stop -all后提示一些

14、服务停不了，再用crs_stat -t查看状态的时候，停不掉的服务会显示状态是UNKNOWN，服务在UNKNOWN状态下用 crs_start 不能启动服务例如：oraclerac1 $ crs_stop -allAttempting to stop ora.rac1.gsd on member rac1Attempting to stop ora.rac1.ons on member rac1Attempting to stop ora.rac2.gsd on member rac2Attempting to stop ora.ora9i.db on member rac1Attemptin

15、g to stop ora.rac2.ons on member rac2Stop of ora.rac1.gsd on member rac1 succeeded.Stop of ora.rac2.gsd on member rac2 succeeded.Stop of ora.rac2.ons on member rac2 succeeded.Stop of ora.rac1.ons on member rac1 succeeded.Stop of ora.ora9i.db on member rac1 succeeded.Attempting to stop ora.rac1.LISTE

16、NER_RAC1.lsnr on member rac1Attempting to stop ora.rac2.LISTENER_RAC2.lsnr on member rac2ora.rac1.LISTENER_RAC1.lsnr on member rac1 has experienced an unrecoverable failure.Human intervention required to resume its availability.ora.ora9i.ora9i1.inst is already OFFLINE.ora.rac2.LISTENER_RAC2.lsnr on

17、member rac2 has experienced an unrecoverable failure.Human intervention required to resume its availability.ora.ora9i.ora9i2.inst is already OFFLINE.Attempting to stop ora.rac1.ASM1.asm on member rac1ora.rac1.ASM1.asm on member rac1 has experienced an unrecoverable failure.Human intervention require

18、d to resume its availability.Attempting to stop ora.rac2.ASM2.asm on member rac2Attempting to stop ora.rac1.LISTENER_RAC1.lsnr on member rac1ora.rac2.ASM2.asm on member rac2 has experienced an unrecoverable failure.Human intervention required to resume its availability.ora.rac1.LISTENER_RAC1.lsnr on

19、 member rac1 has experienced an unrecoverable failure.Human intervention required to resume its availability.Attempting to stop ora.rac1.ASM1.asm on member rac1ora.rac1.ASM1.asm on member rac1 has experienced an unrecoverable failure.Human intervention required to resume its availability.Attempting

20、to stop ora.rac2.LISTENER_RAC2.lsnr on member rac2Attempting to stop ora.rac1.vip on member rac1ora.rac2.LISTENER_RAC2.lsnr on member rac2 has experienced an unrecoverable failure.Human intervention required to resume its availability.Attempting to stop ora.rac2.ASM2.asm on member rac2ora.rac2.ASM2.

21、asm on member rac2 has experienced an unrecoverable failure.Human intervention required to resume its availability.Attempting to stop ora.rac2.vip on member rac2Stop of ora.rac1.vip on member rac1 succeeded.Stop of ora.rac2.vip on member rac2 succeeded.CRS-0216: Could not stop resource ora.ora9i.ora

22、9i1.inst.CRS-0216: Could not stop resource ora.ora9i.ora9i2.inst.CRS-0216: Could not stop resource ora.rac1.ASM1.asm.CRS-0216: Could not stop resource ora.rac1.LISTENER_RAC1.lsnr.CRS-0216: Could not stop resource ora.rac1.vip.CRS-0216: Could not stop resource ora.rac2.ASM2.asm.CRS-0216: Could not st

23、op resource ora.rac2.LISTENER_RAC2.lsnr.CRS-0216: Could not stop resource ora.rac2.vip.在UNKNOWN状态下，使用crs_start -all命令不会把RAC启动起来，启动的时候会报错。oraclerac1 $ crs_start -allAttempting to start ora.rac1.vip on member rac1Attempting to start ora.rac2.vip on member rac2Attempting to start ora.rac2.gsd on member

24、 rac2Attempting to start ora.rac2.ons on member rac2Attempting to start ora.rac1.gsd on member rac1Attempting to start ora.rac1.ons on member rac1ora.rac2.gsd on member rac2 has experienced an unrecoverable failure.Human intervention required to resume its availability.ora.rac2.ons on member rac2 ha

25、s experienced an unrecoverable failure.Human intervention required to resume its availability.Attempting to start ora.ora9i.db on member rac1ora.rac1.ons on member rac1 has experienced an unrecoverable failure.Human intervention required to resume its availability.ora.rac1.gsd on member rac1 has exp

26、erienced an unrecoverable failure.Human intervention required to resume its availability.ora.ora9i.db on member rac1 has experienced an unrecoverable failure.Human intervention required to resume its availability.Start of ora.rac1.vip on member rac1 succeeded.CRS-1028: Dependency analysis failed bec

27、ause of:Resource in UNKNOWN state: ora.rac1.ASM1.asmStart of ora.rac2.vip on member rac2 succeeded.CRS-1028: Dependency analysis failed because of:Resource in UNKNOWN state: ora.rac2.ASM2.asmCRS-0215: Could not start resource ora.ora9i.db.CRS-0223: Resource ora.ora9i.ora9i1.inst has placement error.

28、CRS-0223: Resource ora.ora9i.ora9i2.inst has placement error.CRS-0215: Could not start resource ora.rac1.gsd.CRS-0215: Could not start resource ora.rac1.ons.CRS-0215: Could not start resource ora.rac2.gsd.CRS-0215: Could not start resource ora.rac2.ons.此时crs_stat -t的状态还是有很多的UNKNOWN（烦、烦、烦，rac中真奇怪，正常启动关闭服务时， 状态只有online和offline两种（启动与未启动），结果RAC中给你来了个UNKNOWN）：oraclerac1 $ crs_stat -tName Type Target State Host -ora.ora9i.db application ONLINE UNKNOWN rac1 ora.i1.inst applic