$lsnrctl status
LSNRCTL for Solaris: Version 10.2.0.5.0 - Production on 18-NOV-2010 00:14:07
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS p rotocol adapter error
TNS-00511: No listener
Solaris Error: 146: Connection refused
$crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE sa-db1
ora....B1.lsnr application 0/5 0/0 ONLINE ONLINE sa-db1
ora.sa-db1.gsd application 0/5 0/0 ONLINE ONLINE sa-db1
ora.sa-db1.ons application 0/3 0/0 ONLINE ONLINE sa-db1
ora.sa-db1.vip application 0/0 0/0 ONLINE ONLINE sa-db1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE sa-db2
ora....B2.lsnr application 0/5 0/0 ONLINE ONLINE sa-db2
ora.sa-db2.gsd application 0/5 0/0 ONLINE ONLINE sa-db2
ora.sa-db2.ons application 0/3 0/0 ONLINE ONLINE sa-db2
ora.sa-db2.vip application 0/0 0/0 ONLINE ONLINE sa-db2
ora.sadb.db application 0/0 0/1 ONLINE ONLINE sa-db2
ora....b1.inst application 0/5 0/0 ONLINE ONLINE sa-db1
ora....b2.inst application 0/5 0/0 ONLINE ONLINE sa-db2
sa-db1$ps -ef|grep tns
oracle 2024 1 0 Nov 15 ? 0:01 /oracle/app/oracle/product/10.2/bin/tnslsnr LISTENER_SA-DB1 -inherit
LSNRCTL for Solaris: Version 10.2.0.5.0 - Production on 18-NOV-2010 00:14:07
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS p rotocol adapter error
TNS-00511: No listener
Solaris Error: 146: Connection refused
$crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE sa-db1
ora....B1.lsnr application 0/5 0/0 ONLINE ONLINE sa-db1
ora.sa-db1.gsd application 0/5 0/0 ONLINE ONLINE sa-db1
ora.sa-db1.ons application 0/3 0/0 ONLINE ONLINE sa-db1
ora.sa-db1.vip application 0/0 0/0 ONLINE ONLINE sa-db1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE sa-db2
ora....B2.lsnr application 0/5 0/0 ONLINE ONLINE sa-db2
ora.sa-db2.gsd application 0/5 0/0 ONLINE ONLINE sa-db2
ora.sa-db2.ons application 0/3 0/0 ONLINE ONLINE sa-db2
ora.sa-db2.vip application 0/0 0/0 ONLINE ONLINE sa-db2
ora.sadb.db application 0/0 0/1 ONLINE ONLINE sa-db2
ora....b1.inst application 0/5 0/0 ONLINE ONLINE sa-db1
ora....b2.inst application 0/5 0/0 ONLINE ONLINE sa-db2
sa-db1$ps -ef|grep tns
oracle 2024 1 0 Nov 15 ? 0:01 /oracle/app/oracle/product/10.2/bin/tnslsnr LISTENER_SA-DB1 -inherit
oracle 2021 1326 0 00:15:14 pts/1 0:00 grep tns
然后lsnrctl status LISTENER 就可以看到正常。
问题解决,原因是出现在
cat /etc/hosts
#127.0.0.1 ywdb2 localhost.localdomain localhost
127.0.0.1 localhost.localdomain localhost
192.168.222.31 ywdb1
192.168.222.32 ywdb2
对于节点机器出现ip环路,无法解析