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)
)
)