在安装 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