1.安装时执行VIPCA时报:
/home/oracle/product/10.2.0/crs_1/bin/vipca
/home/oracle/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
解决办法如下:
./oifcfg setif -global eth0/192.168.1.0:public
./oifcfg setif -global eth1/10.10.10.0:cluster_interconnect
./oifcfg getif
./oifcfg iflist
修改VIP脚本:
arch=`uname -m`
#End workaround
;;
这个是改过的内容, 把UNAME -A下面的几行给删除掉,到;;就可以了。
再次执行VIPCA恢复正常。
2.节点2磁盘组无法挂上。
报错:could not mount the diskgroup on remote node rac2 using connection service rac2:1521:+ASM2
TNS....
解决办法: 检查监听, 发现监听端口已被占用。
LSNRCTL> service
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
LSNRCTL> help
The following operations are available
An asterisk (*) denotes a modifier or extended command:
start stop status
services version reload
save_config trace spawn
change_password quit exit
set* show*
LSNRCTL> start
Starting /home/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /home/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/product/10.2.0/db_1/network/log/listener.log
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use
然后将进程杀掉再进行重启:
netstat -pan | grep 1521
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 192.168.1.132:1521 0.0.0.0:* LISTEN 21466/tnslsnr
tcp 0 0 192.168.1.32:1521 0.0.0.0:* LISTEN 21466/tnslsnr
rac2-> kill -9 21466
rac2-> netstat -pan | grep 1521
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
rac2-> netstat -pan | grep 1521
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
rac2-> lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 07-MAY-2012 17:33:44
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /home/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /home/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac2)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 07-MAY-2012 17:33:44
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac2)(PORT=1521)))
The listener supports no services
The command completed successfully
再进行挂载,还是报错。 解决办法:不要选择MOUNT ALL。 一个一个的挂就可以了。
验证:
select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
RECOVERYDEST MOUNTED
DG1 MOUNTED
/home/oracle/product/10.2.0/crs_1/bin/vipca
/home/oracle/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
解决办法如下:
./oifcfg setif -global eth0/192.168.1.0:public
./oifcfg setif -global eth1/10.10.10.0:cluster_interconnect
./oifcfg getif
./oifcfg iflist
修改VIP脚本:
arch=`uname -m`
#End workaround
;;
这个是改过的内容, 把UNAME -A下面的几行给删除掉,到;;就可以了。
再次执行VIPCA恢复正常。
2.节点2磁盘组无法挂上。
报错:could not mount the diskgroup on remote node rac2 using connection service rac2:1521:+ASM2
TNS....
解决办法: 检查监听, 发现监听端口已被占用。
LSNRCTL> service
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
LSNRCTL> help
The following operations are available
An asterisk (*) denotes a modifier or extended command:
start stop status
services version reload
save_config trace spawn
change_password quit exit
set* show*
LSNRCTL> start
Starting /home/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /home/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/product/10.2.0/db_1/network/log/listener.log
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use
然后将进程杀掉再进行重启:
netstat -pan | grep 1521
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 192.168.1.132:1521 0.0.0.0:* LISTEN 21466/tnslsnr
tcp 0 0 192.168.1.32:1521 0.0.0.0:* LISTEN 21466/tnslsnr
rac2-> kill -9 21466
rac2-> netstat -pan | grep 1521
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
rac2-> netstat -pan | grep 1521
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
rac2-> lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 07-MAY-2012 17:33:44
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /home/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /home/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac2)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 07-MAY-2012 17:33:44
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac2)(PORT=1521)))
The listener supports no services
The command completed successfully
再进行挂载,还是报错。 解决办法:不要选择MOUNT ALL。 一个一个的挂就可以了。
验证:
select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
RECOVERYDEST MOUNTED
DG1 MOUNTED
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22740983/viewspace-734639/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22740983/viewspace-734639/