11G R2 RAC监听管理---增加监听2

11gRAC修改端口：       http://blog.csdn.net/bamuta/article/details/29863943 

11gRAC增加监听1：    http://blog.csdn.net/bamuta/article/details/29865023

11gRAC增加监听2：    http://blog.csdn.net/bamuta/article/details/30029437

10gRAC修改端口            http://blog.csdn.net/bamuta/article/details/30050833

增加监听2

          在增加监听时，执行srvctl命令后，endpoints_listener.ora和listener.ora是会自动修改的。

srvctl增加监听

[grid@node1 ~]$ srvctl add listener -l LSNR3-o /u01/grid/11.2.0/gridhome -p 1525

查看endpoints_listener.ora和listener.ora

[grid@node1 admin]$ moreendpoints_listener.ora

新增部分：

 

LSNR3_NODE1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip)(PORT=1525))(ADDRESS=(PROTOCOL=TCP

)(HOST=192.168.150.11)(PORT=1525)(IP=FIRST))))          # line added by Agent

 

[grid@node1 admin]$ more listener.ora

新增部分：

 

LSNR3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LSNR3))))          # l

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LSNR3=ON         # line added by Agent

 

此时启动listener后，便可以tnsping通。

 

[grid@node2 ~]$ srvctl start listener -lLSNR3

 

Tnsname配置

 

TAN5 =
 (DESCRIPTION =
   (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL =TCP)(HOST = 192.168.150.13)(PORT = 1525))
         (ADDRESS= (PROTOCOL = TCP)(HOST = 192.168.150.14)(PORT = 1525))
    )
   (CONNECT_DATA =
     (SERVICE_NAME = tan)
    )
  )

 

C:\Users\qingru.tan>tnsping tan5

 

TNS Ping Utility for 32-bit Windows:Version 11.2.0.3.0 - Production on 11-6月 -2014 09:30:59
 
Copyright (c) 1997, 2011, Oracle.  All rights reserved.
 
已使用的参数文件:
E:\app\qingru.tan\product\11.2.0\client_1\network\admin\sqlnet.ora
 
 
已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.150.13)(PORT = 1525)) (ADDRESS = (PRO
 =tan)))
OK (60 毫秒)

但是无法连接，需要注册到local_listener里。

SQL> conn system/oracle@tan5
ERROR:
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
 

 

修改local_listener

 SQL> Alter system setlocal_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.14)(PORT=1523))))','(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.14)(PORT=1524))))','(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.14)(PORT=1525))))'sid='tan2';

 
System altered.
 
SQL> Alter system setlocal_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.13)(PORT=1523))))','(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.13)(PORT=1524))))','(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.13)(PORT=1525))))'sid='tan1';
 
System altered.

 

连接测试：

SQL> conn system/oracle@tan5

已连接。