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



检查一下两节点ip地址是否正确,特别是private ip
的网关地址, 要保持一致

11. ora.listener.lsnr offline

报哪个节点的监听offline,要启动或者重新启动监听,这样还不行的话
把对应节点的集群重新启动





评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值