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=(ADDRESS=(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)
)
)