rac hosts没有配置导致tns-12541: tns:no listener
tns-12541: tns:no listener
这次错误我总结一下有三种情况
1. 本地监听程序没有开起来
2. 服务器网络到客户端网络不通
3. hosts里面配置问题
[oracle@his1 admin]$ tnsping crds3db2 客户端tnsping提示程序无监听
tns ping utility for linux: version 11.2.0.2.0 - production on 28-may-2014 11:11:57
copyright (c) 1997, 2010, oracle. all rights reserved.
used parameter files:
used tnsnames adapter to resolve the alias
attempting to contact (description = (address = (protocol = tcp)(host = 192.168.20.8)(port = 1521)) (connect_data = (server = dedicated) (service_name = crds3db)))
tns-12541: tns:no listener
到oracle用户查看监听状态为正常，但是有一个节点1ip没有注册到节点2监听上面
[oracle@his1 ~]$ lsnrctl status
lsnrctl for linux: version 11.2.0.2.0 - production on 28-may-2014 10:56:09
copyright (c) 1991, 2010, oracle. all rights reserved.
connecting to (address=(protocol=tcp)(host=)(port=1521))
status of the listener
------------------------
alias listener
version tnslsnr for linux: version 11.2.0.2.0 - production
start date 28-may-2014 10:09:10
uptime 0 days 0 hr. 46 min. 59 sec
trace level off
security on: local os authentication
snmp off
listener parameter file /app/grid/product/11.2.0/grid/network/admin/listener.ora
listener log file /app/grid/grid_base/diag/tnslsnr/his1/listener/alert/log.xml
listening endpoints summary...
(description=(address=(protocol=ipc)(key=listener)))
(description=(address=(protocol=tcp)(host=127.0.0.1)(port=1521)))
(description=(address=(protocol=tcp)(host=192.168.20.6)(port=1521)))
services summary...
service +asm has 1 instance(s).
instance +asm1, status ready, has 1 handler(s) for this service...
service crds3db has 1 instance(s).
instance crds3db1, status ready, has 1 handler(s) for this service...
the command completed successfully
[root@his1 admin]# vi /etc/hosts
把里面删除his1 因为两个计算名冲突导致监听只注册到127.0.0.1
# do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 his1 localhost.localdomain localhost
#::1 localhost6.localdomain6 localhost6
192.168.20.1 his1
192.168.20.2 his2
192.168.20.5 his-scan
192.168.20.6 his1-vip
192.168.20.7 his2-vip
192.168.20.15 hisdg
10.0.0.1 his1-priv
10.0.0.2 his2-priv
[grid@his2 ~]$ lsnrctl status
lsnrctl for linux: version 11.2.0.2.0 - production on 28-may-2014 11:18:14
copyright (c) 1991, 2010, oracle. all rights reserved.
connecting to (description=(address=(protocol=ipc)(key=listener)))
status of the listener
------------------------
alias listener
version tnslsnr for linux: version 11.2.0.2.0 - production
start date 28-may-2014 11:06:52
uptime 0 days 0 hr. 11 min. 22 sec
trace level off
security on: local os authentication
snmp off
listener parameter file /app/grid/product/11.2.0/grid/network/admin/listener.ora
listener log file /app/grid/grid_base/diag/tnslsnr/his2/listener/alert/log.xml
listening endpoints summary...
(description=(address=(protocol=ipc)(key=listener)))
(description=(address=(protocol=tcp)(host=192.168.20.2)(port=1521)))
(description=(address=(protocol=tcp)(host=192.168.20.7)(port=1521)))
services summary...
service +asm has 1 instance(s).
instance +asm2, status ready, has 1 handler(s) for this service...
service crds3db has 1 instance(s).
instance crds3db2, status ready, has 1 handler(s) for this service...
the command completed successfully
c:\users\oracle>tnsping crds3db
tns ping utility for 32-bit windows: version 11.2.0.1.0 - production on 28-5月 -
2014 11:32:16
copyright (c) 1997, 2010, oracle. all rights reserved.
已使用的参数文件:
d:\app\mxq\product\11.2.0\dbhome_1\network\admin\sqlnet.ora