在安装 Oracle RAC创建RAC 数据库的时候遇到的问题

 

在创建RAC 数据库的时候,因为之前创建了ASM实例,所以DBCA提示

Error when connecting to ASM instance on local node:io exception :The network adapter could not establish  the connection.
 
解决方法:
 
1、查看listener状态,
[oracle@node1 opt]$:lnsrctl status
状态为:
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 1-Apr-2012 23:30:37
 
Copyright (c) 1991, 2005, Oracle.  All rights reserved.
 
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
 
 
2、使用srvctl停止listener
[oracle@node1 opt]$:/opt/ora10g/product/10.2.0/crs_1/bin/srvctl stop listener -n node1
[oracle@node2 opt]$:/opt/ora10g/product/10.2.0/crs_1/bin/srvctl stop listener -n node2
其中 node1,node2为节点名
 
 
 
3、分别在两个节点启动listener
lsnrctl start
 
 
3、查看listener状态()
    lsnrctl status
 
 
4、使用srvctl启动listener
[oracle@node1 opt]$:/opt/ora10g/product/10.2.0/crs_1/bin/srvctl start listener -n node1
[oracle@node2 opt]$:/opt/ora10g/product/10.2.0/crs_1/bin/srvctl start listener -n node2
 
 
如果你碰到了这个错误:
 
/opt/ora10g/product/10.2.0/crs_1/jdk/jre//bin/java: error while loading shared libraries:  libpthread.so.0: cannot open shared object file: No such file or directory
 
可以按照如下方式解决:
 
===============================
 
修改vipca文件
 
[root@node2 opt]# vi /opt/ora10g/product/10.2.0/crs_1/bin/vipca
 
找到如下内容:
 
       Remove this workaround when the bug 3937317 is fixed
 
       arch=`uname -m`
 
       if [ "$arch" = "i686" -o "$arch" = "ia64" ]
 
       then
 
            LD_ASSUME_KERNEL=2.4.19
 
            export LD_ASSUME_KERNEL
 
       fi
 
       #End workaround
 
在fi后新添加一行:
 
unset LD_ASSUME_KERNEL
 
以及srvctl文件
 
[root@node2 opt]# vi /opt/ora10g/product/10.2.0/crs_1/bin/srvctl
 
找到如下内容:
 
LD_ASSUME_KERNEL=2.4.19
 
export LD_ASSUME_KERNEL
 
同样在其后新增加一行:
 
unset LD_ASSUME_KERNEL
 
保存退出,重新执行第4步,
使用srvctl启动listener
[oracle@node1 opt]$:/opt/ora10g/product/10.2.0/crs_1/bin/srvctl start listener -n node1
[oracle@node2 opt]$:/opt/ora10g/product/10.2.0/crs_1/bin/srvctl start listener -n node2