11G R2 RAC监听管理---修改端口

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

概述：

         机器配置了3个scan ip，但是未配置DNS。本文操作操作将默认的1521端口修改后1523

[root@node1 ~]# more /etc/hosts

127.0.0.1  localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomainlocalhost6 localhost6.localdomain6
 
 
192.168.150.11  node1
192.168.150.12  node2
 
 
192.168.150.13  node1-vip
192.168.150.14  node2-vip
 
 
172.168.146.101 node1-priv
172.168.146.102 node2-priv
 
192.168.150.15  scanip
192.168.150.16  scanip
192.168.150.17  scanip
[root@node1 ~]#

 

11g R2的监听是在grid用户下，

[root@node1 ~]# ps -ef|grep tnslsnr

grid     2983     1  0 17:39 ?       00:00:00/u01/grid/11.2.0/gridhome/bin/tnslsnr LISTENER_SCAN2 -inherit
grid     2985     1  0 17:39 ?        00:00:00/u01/grid/11.2.0/gridhome/bin/tnslsnr LISTENER_SCAN3 -inherit
root    16715 15220  3 18:06 pts/2    00:00:00 grep tnslsnr
grid    31381     1  0 18:04 ?        00:00:00/u01/grid/11.2.0/gridhome/bin/tnslsnr LISTENER –inherit

[root@node2 ~]# ps -ef|grep tnslsnr

root      859 29261  0 18:07 pts/2    00:00:00 grep tnslsnr
grid    15854     1  0 17:45 ?        00:00:00 /u01/grid/11.2.0/gridhome/bin/tnslsnrLISTENER_SCAN1 -inherit
grid    30648     1  0 17:56 ?        00:00:00/u01/grid/11.2.0/gridhome/bin/tnslsnr LISTENER –inherit
 

一.   修改默认监听端口：

修改endpoints_listener.ora

可以是Grid用户下netca，图形化界面修改。也可以手工修改。

 

Gridhome/network/admin手工修改：

[grid@node1 admin]$ more endpoints_listener.ora

LISTENER_NODE1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip)(PORT=1523))(ADDRESS=(PROTOCOL=
TCP)(HOST=192.168.150.11)(PORT=1523)(IP=FIRST))))               # line added by Agent

[grid@node2 admin]# more endpoints_listener.ora

STENER_NODE2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node2-vip)(PORT=1523))(ADDR

LISTENER_NODE2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node2-vip)(PORT=1523))(ADDRESS=(PROTOCOL=

TCP)(HOST=192.168.150.12)(PORT=1523)(IP=FIRST))))               # line added by Agent

修改local_listener和remote_listener

 

SQL> show parameter local_listener                  

 

NAME                                 TYPE        VALUE

----------------------------------------------- ------------------------------

local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD

                                                DRESS=(PROTOCOL=TCP)(HOST=192.

                                                 168.150.14)(PORT=1521))))

 

SQL> Altersystem setlocal_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.14)(PORT=1523))))'sid='tan2';

Alter system setlocal_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150.13)(PORT=1521))))'sid='tan1';

 

SQL> show parameter remote_listener

 

NAME                                 TYPE        VALUE

----------------------------------------------- ------------------------------

remote_listener                      string      scanip:1521

SQL> alter system setremote_listener='scanip:1523';

 

SQL> altersystem register;

 

System altered.

 

重启监听：

#Srvctl stop listener

#Srvctl start listener

 

[root@node2 ~]# srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s):node2,node1

 

使用VIP连接

此时使用vip便可以访问集群

 TAN =

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

使用scan IP 连接

但是scan ip 目前还不能连接，需要做以下修改：

[root@node2 ~]# srvctl status scan_listener

SCAN Listener LISTENER_SCAN1 is enabled

SCAN listener LISTENER_SCAN1 is running onnode node2

SCAN Listener LISTENER_SCAN2 is enabled

SCAN listener LISTENER_SCAN2 is running onnode node1

SCAN Listener LISTENER_SCAN3 is enabled

SCAN listener LISTENER_SCAN3 is running onnode node1

[root@node2 ~]# srvctl config scan_listener

SCAN Listener LISTENER_SCAN1 exists. Port:TCP:1521

SCAN Listener LISTENER_SCAN2 exists. Port:TCP:1521

SCAN Listener LISTENER_SCAN3 exists. Port:TCP:1521

[root@node2 ~]# srvctlmodify scan_listener -p 1523

[root@node2 ~]# srvctl configscan_listener       

SCAN Listener LISTENER_SCAN1 exists. Port:TCP:1523

SCAN Listener LISTENER_SCAN2 exists. Port:TCP:1523

SCAN Listener LISTENER_SCAN3 exists. Port:TCP:1523

 

[root@node1 ~]#srvctl stop scan_listener

[root@node1 ~]# srvctlstart scan_listener

 

现在可以使用scan ip进行连接（本例中并未配DNS服务器，所以直接使用了SCAN IP）

TAN =
 (DESCRIPTION =
   (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL =TCP)(HOST = 192.168.150.15)(PORT = 1523))
         (ADDRESS= (PROTOCOL = TCP)(HOST = 192.168.150.16)(PORT = 1523))
         (ADDRESS= (PROTOCOL = TCP)(HOST = 192.168.150.17)(PORT = 1523))
    )
   (CONNECT_DATA =
     (SERVICE_NAME = tan)
    )
  )