RAC 监听配置问题

matt_deepblue

vmware+redhat 5.1+rac 10.2.0.4


节点1监听动态注册RACDB,ASM服务正常，节点2监听动态注册服务失败，并在listener_rac2.log报：
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
将节点2监听配置为静态注册并重启，节点2监听注册RACDB,ASM服务正常，但是用
sqlplus "[email=sys/sys@RACDB2]sys/sys@RACDB2[/email] as sysdba"连接时提示连接到空闲实例。
将节点2 listener.ora修改：
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521)(IP = FIRST))
改为
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)(IP = FIRST))
重启DB,节点2监听动态注册正常，请问为什么？


192.168.1.100  rac1
192.168.1.101  rac2
192.168.1.200  rac1-vip
192.168.1.201  rac2-vip
192.168.2.100  rac1-priv
192.168.2.101  rac2-priv
LISTENER_RAC1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

LISTENER_RAC2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

Maclean Liu(刘相兵

"节点2监听动态注册服务失败，并在listener_rac2.log报：
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor"


你有设置local_listener 吗？

matt_deepblue

2个节点均无设置，都是安装的默认设置。

Maclean Liu(刘相兵

LISTENER_RAC2 不是默认监听名  不设置local_listener ， 是无法正确动态注册的。

matt_deepblue

没有配置local_listener ，现在是可以动态注册的。

[oracle@rac2 ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 22-JUN-2012 14:37:01

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_RAC2
Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date                22-JUN-2012 14:27:12
Uptime                    0 days 0 hr. 9 min. 48 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/ora10g/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /opt/ora10g/product/10.2.0/db_1/network/log/listener_rac2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.201)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "+ASM" has 2 instance(s).
  Instance "+ASM2", status UNKNOWN, has 1 handler(s) for this service...
  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "RACDB" has 2 instance(s).
  Instance "RACDB2", status UNKNOWN, has 1 handler(s) for this service...
  Instance "RACDB2", status READY, has 1 handler(s) for this service...
Service "RACDBXDB" has 1 instance(s).
  Instance "RACDB2", status READY, has 1 handler(s) for this service...
Service "RACDB_XPT" has 1 instance(s).
  Instance "RACDB2", status READY, has 1 handler(s) for this service...
The command completed successfully

Maclean Liu(刘相兵

使用127.0.0.1 是由问题 的， 建议你使用netca 或者netmgr 重新配置该LISTENER

matt_deepblue

好的，我再看看，多谢啦