昨天和今天上午安装ORACLE10G RAC,存储RAW+ASM。安装过程还算比较顺利。就是存储占用了很多时间。(具体文档参考http://space.itpub.net/22779291/viewspace-625329)现将在安装过程中遇到错误整理了下:
重新安装集群软件的时候执行root.sh脚本的时候报错:提示已经存在了配置文件信息(大概是,不太清楚了)。脚本root.sh 执行完后配置信息存放在/etc/oracle/ocr.loc。在重新安装集群软件的时候没删除这个文件所以在执行脚本的时候会报错。删除后执行该脚本,一切正常。
因为直接断电过一次服务器,在启动节点2crs的时候启动不起来报错如下
rac1:/oracle_crs/product/10.2/crs/bin # ./crsctl start crs
Attempting to start CRS stack
Failure at scls_scr_create with code 1
Internal Error Information:
Category: 1234
Operation: scls_scr_create
Location: mkdir
Other: Unable to make user dir
Dep: 2
主机名不正确本该是RAC2却变成了RAC1修改后执行成功。在网上查了也下也有是/etc/hosts文件中主机名不能为大写所导致。:我这里为主机名不正确所致。
节点2的监听,VIP未启动起来,查看日志提示没有默认网关。
rac2:/oracle_crs/product/10.2/crs/bin # ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE OFFLINE
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE OFFLINE
ora....SM2.asm application ONLINE OFFLINE
ora....C2.lsnr application ONLINE OFFLINE
ora.rac2.gsd application ONLINE OFFLINE
ora.rac2.ons application ONLINE OFFLINE
ora.rac2.vip application ONLINE ONLINE rac1
查看ora.rac2.vip.log报错提示没有网关,添加网关。
rac2:/oracle_crs/product/10.2/crs/log/rac2/racg # ls
evtf.log ora.rac1.vip.log ora.rac2.ons.log ora.rac2.vip.log racgeut racgevtf racgmain
rac2:/oracle_crs/product/10.2/crs/log/rac2/racg # tail -50 ora.rac2.vip.log
2010-06-04 09:20:34.523: [ RACG][3065632432] [22819][3065632432][ora.rac2.vip]: clsrcexecut: rc = 1, time = 3.330s
2010-06-04 09:20:37.725: [ RACG][3065632432] [22819][3065632432][ora.rac2.vip]: clsrcexecut: env ORACLE_CONFIG_HOME=/oracle_crs/product/10.2/crs
2010-06-04 09:20:37.726: [ RACG][3065632432] [22819][3065632432][ora.rac2.vip]: clsrcexecut: cmd = /oracle_crs/product/10.2/crs/bin/racgeut -e _USR_ORA_DEBUG=0 54 /oracle_crs/product/10.2/crs/bin/racgvip check rac2
2010-06-04 09:20:37.726: [ RACG][3065632432] [22819][3065632432][ora.rac2.vip]: clsrcexecut: rc = 1, time = 3.200s
2010-06-04 09:20:37.726: [ RACG][3065632432] [22819][3065632432][ora.rac2.vip]: end for resource = ora.rac2.vip, action = start, status = 1, time = 6.600s
2010-06-04 09:20:49.812: [ RACG][3065984688] [23007][3065984688][ora.rac2.vip]: checkIf: Default gateway is not defined (host=rac2)
Interface eth4 checked failed (host=rac2)
checkIf: Default gateway is not defined (host=rac2)
Interface eth3 checked failed (host=rac2)
Invalid parameters, or failed to bring up VIP (host=rac2)
rac2:/oracle_crs/product/10.2/crs/log/rac2/racg #
rac2:/oracle_crs/product/10.2/crs/log/rac2/racg #
rac2:/oracle_crs/product/10.2/crs/log/rac2/racg #
rac2:/oracle_crs/product/10.2/crs/log/rac2/racg # route
Kernel IP routing table
Destination Gateway Genmask Flags Metric Ref Use Iface
192.168.1.0 * 255.255.255.0 U 0 0 0 eth4
10.10.10.0 * 255.255.255.0 U 0 0 0 eth3
link-local * 255.255.0.0 U 0 0 0 eth3
loopback * 255.0.0.0 U 0 0 0 lo
别的电脑使用了192.168。1.53这个ip地址,修改别的ip地址,然后启动监听。
rac2:/oracle_crs/product/10.2/crs/bin # ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE OFFLINE
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE OFFLINE
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
rac1:/oracle_crs/product/10.2/crs/bin # ./srvctl start listener -n rac1
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
rac1:ora.rac1.vip:IP:192.168.1.53 is already up in the network (host=rac1)
CRS-0215: Could not start resource 'ora.rac1.LISTENER_RAC1.lsnr'.
在ora.rac1.vip.log中也明确提示了192.168.1.53已经存在网络中。
rac1:/oracle_crs/product/10.2/crs/log/rac1/racg # tail -100 ora.rac1.vip.log |less
2010-06-04 10:03:44.563: [ RACG][3065222832] [15731][3065222832][ora.rac1.vip]: IP:192.168.1.53 is already up in the network (hos
t=rac1)
2010-06-04 10:03:44.567: [ RACG][3065222832] [15731][3065222832][ora.rac1.vip]: clsrcexecut: env ORACLE_CONFIG_HOME=/oracle_crs/p
roduct/10.2/crs
2010-06-04 10:03:44.567: [ RACG][3065222832] [15731][3065222832][ora.rac1.vip]: clsrcexecut: cmd = /oracle_crs/product/10.2/crs/b
in/racgeut -e _USR_ORA_DEBUG=0 54 /oracle_crs/product/10.2/crs/bin/racgvip start rac1
2010-06-04 10:03:44.567: [ RACG][3065222832] [15731][3065222832][ora.rac1.vip]: clsrcexecut: rc = 1, time = 22.120s
2010-06-04 10:03:44.824: [ RACG][3065222832] [15731][3065222832][ora.rac1.vip]: IP:192.168.1.53 is already up in the network (hos
t=rac1)
oracle@rac1:~> crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
rac1:/oracle_crs/product/10.2/crs/bin # ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE rac1
ora....l1.inst application ONLINE ONLINE rac1
ora....l2.inst application ONLINE ONLINE rac2
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@rac1:~> echo $ORACLE_HOME
/opt/oracle/product/10.2/db_1
oracle@rac1:~> echo $ORA_CRS_HOME
/oracle_crs/product/10.2/crs
oracle@rac1:~> echo $ORACLE_SID
orcl1
oracle@rac1:~> echo $ORA_ASM_HOME
/opt/oracle/product/10gR2/asm
oracle@rac1:~> export ORACLE_SID=+ASM1
oracle@rac1:~> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jun 4 11:03:23 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> show parameter asm_diskgroups
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string DATA, FLASHRECOVER
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22779291/viewspace-664359/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22779291/viewspace-664359/