11g RAC搭建错误

1、[INS-08106]

[php]  view plaincopy

SEVERE: [FATAL] [INS-08106] Unexpected error occurred while loading the view 'GridPlugPlayInfoUI' associated to state 'GridPlugPlayInfoUI'.  

这步设置 GridPlugPlay 信息时，需读取 /etc/hosts 文件内定义的网络接口信息。

仔细查看hosts文件内容，发现自己把 ip 地址写错了，随后两个节点都更正再次运行正常了。

另外hosts文件内有无效字符也会出现这个问题。

2、 Package "cvuqdisk-1.0.9-

cd /tmp 解压安装包时候的目录

>rpm -ivh cvuqdisk-1.0.9-1.rpm。

3、rac2节点运行root.sh报错：

发现没有asm-disk文件夹！！！靠！猪脑子啊！

创建完软连接以后：

一直在闪

说明的问题：没有这些盘！

没有添加盘！

vi /etc/udev/rules.d/99-asm-highgo.rules

重启udev 守护进程

start_udev

检查是否生成ls -l /dev/raw/raw* 磁盘, 以及磁盘权限是否是grid:asmadmin！！！

4、linux解决xhost +: unable to open display ""

实用技巧：在Linux下设置xhost方法步骤

第一步：用root登陆linux，启动vnc服务；

第二步：根据vnc起来的端口，设置export DISPLAY=localhost:1（1表示vnc在第一个tty上启动的），vnc的启动信息见附件1；

第三步：执行xhost +，并且提示“access control disabled, clients can connect from any host”才正确。

linux下的操作日志如下：

[root@localhost ~]# vncserver

New 'localhost:1 (root)' desktop is localhost:1

Starting applications specified in /root/.vnc/xstartupLog file is /root/.vnc/localhost:1.log

[root@localhost ~]# export DISPLAY=localhost:1

[root@localhost ~]# xhost +

access control disabled, clients can connect from any host 

在设置xhost时，出现了unable的问题。使用上诉方法就可以搞定。

下面方法也可以：

Steps to resolve this issue:

1) login into root user( su -l root)

2) execute this command :  xhost +SI:localuser:oracle

3) login to the oracle user

4) execute ./runInstaller

5.clock synchronization【时钟同步】

 在oracle 11gR2 RAC版本中,oracle自己增加了集群中的时间同步服务,如果操作系统没有配置NTP,就会启用oracle 自带的 Cluster Time Synchronization Service 

[root@rac1 ~]# date

Thu Nov 24 16:35:00 CST 2016

[root@rac1 ~]# date -s "20161124 16:41:00"

Thu Nov 24 16:41:00 CST 2016

[root@rac1 ~]# date

Thu Nov 24 16:41:03 CST 2016

[root@rac2 ~]# date

Thu Nov 24 16:30:52 CST 2016

[root@rac2 ~]# date -s "20161124 16:41:00"

Thu Nov 24 16:41:00 CST 2016

[root@rac2 ~]# date

Thu Nov 24 16:41:03 CST 2016

6:创建数据库时候报错检测时候报错

解决方法：

看看hosts文件

以及 看看防火墙关闭没有

service iptables stop

chkconfig iptables off

7.创建数据库报错

权限问题：

[grid@liuqi1 oracle]$ cd $ORACLE_HOME/bin

[grid@liuqi1 bin]$ ll oracle

-rwxr-x--x 1 grid oinstall 203974257 Mar  9 20:42 oracle

[grid@liuqi1 bin]$ chmod 6751 oracle

[grid@liuqi1 bin]$ ll oracle

-rwsr-s--x 1 grid oinstall 203974257 Mar  9 20:42 oracle

[grid@liuqi1 bin]$

CD

将$GRID_HOME/bin和$ORACLE_HOME/bin下的oracle都赋6751权限：

chmod 6751 $GRID_HOME/bin/oracle

chmod 6751 $ORACLE_HOME/bin/oracle

8.start_udev的时候

udev still not settled. Waiting.

udevadm settle - timeout of 0 seconds reached, the event queue contains:

/sys/module/scsi_wait_scan (6625)

/sys/module/scsi_wait_scan (6626)

udev still not settled. Waiting.

udevadm settle - timeout of 0 seconds reached, the event queue contains:

/sys/module/scsi_wait_scan (6627)

/sys/module/scsi_wait_scan (6628)

udev still not settled. Waiting.

udevadm settle - timeout of 0 seconds reached, the event queue contains:

/sys/module/scsi_wait_scan (6629)

/sys/module/scsi_wait_scan (6630)

udev still not settled. Waiting.[ OK ]

查看

[root@rac1 asm-disk]# cd /etc/udev/rules.d/

[root@rac1 rules.d]# ls

55-usm.rules 60-pcmcia.rules 70-persistent-cd.rules 90-alsa.rules 97-bluetooth-serial.rules 99-asm-highgo.rules

60-fprint-autosuspend.rules 60-raw.rules 70-persistent-net.rules 90-hal.rules 98-kexec.rules 99-fuse.rules

[root@rac1 rules.d]# cat 99-asm-highgo.rules

发现有空格存在，所以导致start_udev报错

ACTION=="add",BUS=="scsi", KERNEL=="sd*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",

RESULT=="0QEMU_QEMU_HARDDISK_drive-scsi0-0-0-0",

RUN+="/bin/raw /dev/raw/raw1 %N"

ACTION=="add",BUS=="scsi", KERNEL=="sd*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",

RESULT=="0QEMU_QEMU_HARDDISK_drive-scsi0-0-0-4",

RUN+="/bin/raw /dev/raw/raw2 %N"

ACTION=="add",BUS=="scsi", KERNEL=="sd*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",

RESULT=="0QEMU_QEMU_HARDDISK_drive-scsi0-0-0-3",

RUN+="/bin/raw /dev/raw/raw3 %N"

ACTION=="add",BUS=="scsi", KERNEL=="sd*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",

RESULT=="0QEMU_QEMU_HARDDISK_drive-scsi0-0-0-2",

RUN+="/bin/raw /dev/raw/raw4 %N"

ACTION=="add",BUS=="scsi", KERNEL=="sd*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",

RESULT=="0QEMU_QEMU_HARDDISK_drive-scsi0-0-0-1",

RUN+="/bin/raw /dev/raw/raw5 %N"

KERNEL=="raw1", OWNER="grid", GROUP="asmadmin", MODE="660"

KERNEL=="raw2", OWNER="grid", GROUP="asmadmin", MODE="660"

KERNEL=="raw3", OWNER="grid", GROUP="asmadmin", MODE="660"

KERNEL=="raw4", OWNER="grid", GROUP="asmadmin", MODE="660"

KERNEL=="raw5", OWNER="grid", GROUP="asmadmin", MODE="660"

发现有空格:

要改成以下形式把空格去掉

ACTION=="add",BUS=="scsi", KERNEL=="sd*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="0QEMU_QEMU_HARDDISK_drive-scsi0-0-0-ACTION=="add",BUS=="scsi", KERNEL=="sd*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="0QEMU_QEMU_HARDDISK_drive-scsi0-0-0-ACTION=="add",BUS=="scsi", KERNEL=="sd*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="0QEMU_QEMU_HARDDISK_drive-scsi0-0-0-ACTION=="add",BUS=="scsi", KERNEL=="sd*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="0QEMU_QEMU_HARDDISK_drive-scsi0-0-0-ACTION=="add",BUS=="scsi", KERNEL=="sd*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="0QEMU_QEMU_HARDDISK_drive-scsi0-0-0-ACTION=="add",BUS=="scsi", KERNEL=="sd*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="0QEMU_QEMU_HARDDISK_drive-scsi0-0-0-0",RUN+="/bin/raw /dev/raw/raw1 %N"

ACTION=="add",BUS=="scsi", KERNEL=="sd*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="0QEMU_QEMU_HARDDISK_drive-scsi0-0-0-4",RUN+="/bin/raw /dev/raw/raw2 %N"

ACTION=="add",BUS=="scsi", KERNEL=="sd*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="0QEMU_QEMU_HARDDISK_drive-scsi0-0-0-3",RUN+="/bin/raw /dev/raw/raw3 %N"

ACTION=="add",BUS=="scsi", KERNEL=="sd*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="0QEMU_QEMU_HARDDISK_drive-scsi0-0-0-2",RUN+="/bin/raw /dev/raw/raw4 %N"

ACTION=="add",BUS=="scsi", KERNEL=="sd*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="0QEMU_QEMU_HARDDISK_drive-scsi0-0-0-1",RUN+="/bin/raw /dev/raw/raw5 %N"

KERNEL=="raw1", OWNER="grid", GROUP="asmadmin", MODE="660"

KERNEL=="raw2", OWNER="grid", GROUP="asmadmin", MODE="660"

KERNEL=="raw3", OWNER="grid", GROUP="asmadmin", MODE="660"

KERNEL=="raw4", OWNER="grid", GROUP="asmadmin", MODE="660"

KERNEL=="raw5", OWNER="grid", GROUP="asmadmin", MODE="660"

9 .Creation of ASM spfile in disk group failed. Following error occured: ORA-29783: GPnP attribute SET failed with error [CLSGPNP_ERR]

Configuration of ASM ... failed

see asmca logs at /u01/app/grid/cfgtoollogs/asmca for details

Did not succssfully configure and start ASM at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 6912.

/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl execution failed

因为之前执行多次root.sh脚本所以导致报错，执行下列命令清空配置信息：

/u01/app/11.2.0/grid/crs/install/rootcrs.pl -deconfig -force -verbose

10. 11gRAC报错CRS-4535, CRS-4000解决

检查一下两节点ip地址是否正确，特别是private ip

的网关地址， 要保持一致

11. ora.listener.lsnr offline

报哪个节点的监听offline，要启动或者重新启动监听，这样还不行的话

把对应节点的集群重新启动