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

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

二。增加监听

修改endpoints_listener.ora

--该操作需要两个节点都操作，该文件也可以不用手工修改，后面执行srvctl add后会自动修改.

 

[grid@node2 admin]$ moreendpoints_listener.ora

增加以下内容：

 

LSNR2_NODE2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node2-vip)(PORT=1524))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.12)(PORT=1524)
(IP=FIRST))))

修改listener.ora

--该操作需要两个节点都操作

 

[grid@node2 admin]$ more listener.ora

增加以下内容：

 

LSNR2_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LSNR2_SCAN3))))              # line added by Agent
LSNR2_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LSNR2_SCAN2))))              # line added by Agent
LSNR2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LSNR2))))          # line added by Agent
LSNR2_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LSNR2_SCAN1))))              # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LSNR2_SCAN1=ON           # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LSNR2=ON         # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LSNR2_SCAN2=ON           # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LSNR2_SCAN3=ON           # line added by Agent

[grid@node2 admin]$

修改local_listener

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))))'sid='tan2';

  

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))))'sid='tan1';

 

增加监听

 

[grid@node1 ~]$ srvctl add listener -lLSNR2 -o /u01/grid/11.2.0/gridhome -p 1524

 

[root@node1 ~]# srvctl config listener

Name: LISTENER
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1523
Name: LSNR2
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1524

[root@node1 ~]# srvctl start listener -lLSNR2

 

SQL> alter system register;

 

[grid@node1 admin]$ lsnrctl status lsnr2

 

LSNRCTL for Linux: Version 11.2.0.3.0 -Production on 10-JUN-2014 23:05:58
 
Copyright (c) 1991, 2011, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LSNR2)))
STATUS of the LISTENER
------------------------
Alias                     lsnr2
Version                   TNSLSNR for Linux: Version11.2.0.3.0 - Production
Start Date                10-JUN-2014 22:54:42
Uptime                    0 days 0 hr. 11 min. 20 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File  /u01/grid/11.2.0/gridhome/network/admin/listener.ora
Listener Log File        /u01/grid/11.2.0/gridbase/diag/tnslsnr/node1/lsnr2/alert/log.xml
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LSNR2)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.150.11)(PORT=1524)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.150.13)(PORT=1524)))
Services Summary...
Service "tan" has 1 instance(s).
 Instance "tan1", status READY, has 1 handler(s) for thisservice...
Service "tanXDB" has 1instance(s).
 Instance "tan1", status READY, has 1 handler(s) for thisservice...
The command completed successfully
[grid@node1 admin]$

 

以VIP方式相连：

 

TAN2 =

 (DESCRIPTION =

   (ADDRESS_LIST =

         (ADDRESS= (PROTOCOL = TCP)(HOST = 192.168.150.13)(PORT = 1524))

    (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.150.14)(PORT = 1524))

    )

   (CONNECT_DATA =

     (SERVICE_NAME = tan)

    )

  )

 

以scan ip 方式连接

[root@node2 ~]# srvctl stop scan_listener

 

--实验中scan_listener不能同时使用两个端口，直接创建不成功，必须删掉另1个才行，是否有其他方法让两个端口并存需要进一步求证。

 

[grid@node2 ~]$ srvctl removescan_listener     

Remove scan listener? (y/[n]) y

[grid@node2 ~]$ srvctl add scan_listener -l LSNR2 -p 1524

[grid@node2 ~]$ srvctl config scan_listener

SCAN Listener LSNR2_SCAN1 exists. Port:TCP:1524

SCAN Listener LSNR2_SCAN2 exists. Port:TCP:1524

SCAN Listener LSNR2_SCAN3 exists. Port:TCP:1524

[grid@node2 ~]$ srvctl start scan_listener

 

SQL> altersystem set remote_listener='scanip:1523','scanip:1524';

 

System altered.

 

 

TANX =

 (DESCRIPTION =

   (ADDRESS_LIST =

          (ADDRESS = (PROTOCOL =TCP)(HOST = 192.168.150.15)(PORT = 1524))

         (ADDRESS= (PROTOCOL = TCP)(HOST = 192.168.150.16)(PORT = 1524))

         (ADDRESS= (PROTOCOL = TCP)(HOST = 192.168.150.17)(PORT = 1524))

    )

   (CONNECT_DATA =

     (SERVICE_NAME = tan)

    )

  )