RAC hosts没有配置导致TNS

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

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/0019f925e741cf45b206b38f6c6f614b.html