联系：QQ(5163721)
标题：Oracle 12.1 RAC 系列 – 配置第二个网络和相应的SCAN2
作者：Lunar©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]
在配置ADG或者使用oracle 的集群管理应用的HA时（比如OGG），我们可能希望使用不同的网络，以避免ADG传输日志等对主生产网络的造成影响。
从11.2开始，我们可以使用crs管理多个网络资源（缺省只有network1），但是SCAN只能在多个网络中的一个上活动（缺省是network1，后续可以指定到不同网络上）。
然后，我们通常会配置专门为ADG传输日志的network2网络，但是在配置连接串时，只能使用vip（因为SCAN通常给主生产上的network1使用）。
.
从12.1开始，我们可以配置多个网络上的多个SCAN，比如我们配置ADG时，在network2上配置SCAN2。
具体配置如下：
–检查网卡接口对应的IP地址：
[root@rac1 ~]# ifconfig | egrep 'eth0' -A 1 | grep 'inet ' | cut -d : -f2 | cut -d ' ' -f1 192.168.56.61 192.168.56.63 [root@rac1 ~]# ifconfig | egrep 'eth2' -A 1 | grep 'inet ' | cut -d : -f2 | cut -d ' ' -f1 192.168.209.61 [root@rac1 ~]# [root@rac2 ~]# ifconfig | egrep 'eth0' -A 1 | grep 'inet ' | cut -d : -f2 | cut -d ' ' -f1 192.168.56.62 192.168.56.64 192.168.56.65 [root@rac2 ~]# ifconfig | egrep 'eth2' -A 1 | grep 'inet ' | cut -d : -f2 | cut -d ' ' -f1 192.168.209.62 [root@rac2 ~]#
–添加新的public网络
[grid@rac1 ~]$ oifcfg getif eth0 192.168.56.0 global public eth1 192.168.60.0 global cluster_interconnect [grid@rac1 ~]$ [grid@rac1 ~]$ oifcfg setif -global eth2/192.168.209.0:public [grid@rac1 ~]$ oifcfg getif eth0 192.168.56.0 global public eth1 192.168.60.0 global cluster_interconnect eth2 192.168.209.0 global public [grid@rac1 ~]$
–检查网络定义，缺省只有一个网络定义：network1
[grid@rac1 ~]$ srvctl config network Network 1 exists Subnet IPv4: 192.168.56.0/255.255.255.0/eth0, static Subnet IPv6: Ping Targets: Network is enabled Network is individually enabled on nodes: Network is individually disabled on nodes: [grid@rac1 ~]$
–添加新的网络集群资源（a new network cluster resource）
[root@rac1 ~]# ipcalc -bnm 192.168.209.61 255.255.255.0 NETMASK=255.255.255.0 BROADCAST=192.168.209.255 NETWORK=192.168.209.0 [root@rac1 ~]# [root@rac1 ~]# srvctl add network -netnum 2 -subnet 192.168.209.0/255.255.255.0/eth2 [root@rac1 ~]# [root@rac1 ~]# srvctl config network Network 1 exists Subnet IPv4: 192.168.56.0/255.255.255.0/eth0, static Subnet IPv6: Ping Targets: Network is enabled Network is individually enabled on nodes: Network is individually disabled on nodes: Network 2 exists Subnet IPv4: 192.168.209.0/255.255.255.0/eth2, static Subnet IPv6: Ping Targets: Network is enabled Network is individually enabled on nodes: Network is individually disabled on nodes: [root@rac1 ~]#
这时集群的网络资源中已经配置了两个网络（包括新增加的网络），如果使用“crsctl status res -t”查看，可以看到：
[root@rac1 ~]# crsctl status res -t |grep -A 2 network
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net2.network
OFFLINE OFFLINE rac1 STABLE
OFFLINE OFFLINE rac2 STABLE
[root@rac1 ~]#
–添加vip
[root@rac1 ~]# srvctl add vip -node rac1 -netnum 2 -address rac1-adg-vip/255.255.255.0/eth2
[root@rac1 ~]# srvctl add vip -node rac2 -netnum 2 -address rac2-adg-vip/255.255.255.0/eth2
[root@rac1 ~]# srvctl config vip -n rac1
VIP exists: network number 1, hosting node rac1
VIP Name: rac1-vip
VIP IPv4 Address: 192.168.56.63
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
VIP exists: network number 2, hosting node rac1
VIP Name: rac1-adg-vip
VIP IPv4 Address: 192.168.209.63
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
[root@rac1 ~]# srvctl config vip -n rac2
VIP exists: network number 1, hosting node rac2
VIP Name: rac2-vip
VIP IPv4 Address: 192.168.56.64
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
VIP exists: network number 2, hosting node rac2
VIP Name: rac2-adg-vip
VIP IPv4 Address: 192.168.209.64
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
[root@rac1 ~]# crsctl status res -t |grep -A 2 network
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net2.network
OFFLINE OFFLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
[root@rac1 ~]# crsctl status res -t |grep -A 2 vip
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac1_2.vip
1 OFFLINE OFFLINE STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.rac2_2.vip
1 OFFLINE OFFLINE STABLE
ora.scan1.vip
1 ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
[root@rac1 ~]#
–启动vip，查看vip资源
[root@rac1 ~]# su - grid
[grid@rac1 ~]$ srvctl start vip -vip rac1-adg-vip
[grid@rac1 ~]$ srvctl start vip -vip rac2-adg-vip
[grid@rac1 ~]$ srvctl status vip -n rac1
VIP rac1-vip is enabled
VIP rac1-vip is running on node: rac1
VIP rac1-adg-vip is enabled
VIP rac1-adg-vip is running on node: rac1
[grid@rac1 ~]$ srvctl status vip -n rac2
VIP rac2-vip is enabled
VIP rac2-vip is running on node: rac2
VIP rac2-adg-vip is enabled
VIP rac2-adg-vip is running on node: rac2
[grid@rac1 ~]$
[grid@rac1 ~]$ crsctl status res -t |grep -A 2 network
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net2.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
[grid@rac1 ~]$ crsctl status res -t |grep -A 2 vip
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac1_2.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.rac2_2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
[grid@rac1 ~]$
–检查新创建的vip是否运行了：
[grid@rac1 ~]$ /sbin/ifconfig eth2:1
eth2:1 Link encap:Ethernet HWaddr 08:00:27:17:79:3C
inet addr:192.168.209.63 Bcast:192.168.209.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
[grid@rac1 ~]$
[root@rac2 ~]# /sbin/ifconfig eth2:1
eth2:1 Link encap:Ethernet HWaddr 08:00:27:74:C7:94
inet addr:192.168.209.64 Bcast:192.168.209.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
[root@rac2 ~]#
–添加网络2上的监听：
[grid@rac1 ~]$ srvctl add listener -listener LISTENER_ADG -netnum 2 -endpoints "TCP:1522"
[grid@rac1 ~]$ crsctl status res -t |grep -A 2 LISTENER
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER_ADG.lsnr
OFFLINE OFFLINE rac1 STABLE
OFFLINE OFFLINE rac2 STABLE
--
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.MGMTLSNR
[grid@rac1 ~]$
在network2上配置SCAN:
[root@rac1 ~]# srvctl add scan -scanname racadg-scan -netnum 2
[root@rac1 ~]# srvctl config scan -netnum 2
SCAN name: racadg-scan, Network: 2
Subnet IPv4: 192.168.209.0/255.255.255.0/eth2, static
Subnet IPv6:
SCAN 0 IPv4 VIP: 192.168.209.65
SCAN VIP is enabled.
SCAN VIP is individually enabled on nodes:
SCAN VIP is individually disabled on nodes:
[root@rac1 ~]# srvctl status scan -netnum 2
SCAN VIP scan1_net2 is enabled
SCAN VIP scan1_net2 is not running
[root@rac1 ~]# crsctl status res -t |grep -A 2 LISTENER
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER_ADG.lsnr
OFFLINE OFFLINE rac1 STABLE
OFFLINE OFFLINE rac2 STABLE
--
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.MGMTLSNR
[root@rac1 ~]# crsctl status res -t |grep -A 1 SCAN
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
[root@rac1 ~]#
–启动network2上的监听
[grid@rac1 ~]$ srvctl start listener -listener LISTENER_ADG
[grid@rac1 ~]$ srvctl status listener -listener LISTENER_ADG
Listener LISTENER_ADG is enabled
Listener LISTENER_ADG is running on node(s): rac1,rac2
[grid@rac1 ~]$ srvctl status listener -listener LISTENER
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac1,rac2
[grid@rac1 ~]$
[grid@rac1 ~]$ crsctl status res -t |grep -A 2 LISTENER
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER_ADG.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.MGMTLSNR
[grid@rac1 ~]$ crsctl status res -t |grep -A 2 SCAN
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.MGMTLSNR
[grid@rac1 ~]$
–在network2上启动SCAN
[root@rac1 ~]# srvctl start scan -netnum 2
[root@rac1 ~]# srvctl config scan -netnum 2
SCAN name: racadg-scan, Network: 2
Subnet IPv4: 192.168.209.0/255.255.255.0/eth2, static
Subnet IPv6:
SCAN 0 IPv4 VIP: 192.168.209.65
SCAN VIP is enabled.
SCAN VIP is individually enabled on nodes:
SCAN VIP is individually disabled on nodes:
[root@rac1 ~]# srvctl status scan -netnum 2
SCAN VIP scan1_net2 is enabled
SCAN VIP scan1_net2 is running on node rac1
[root@rac1 ~]# crsctl status res -t |grep -A 2 LISTENER
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER_ADG.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.MGMTLSNR
[root@rac1 ~]# crsctl status res -t |grep -A 2 SCAN
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.MGMTLSNR
[root@rac1 ~]#
–在network2上添加SCAN LISTENER
[grid@rac1 ~]$ srvctl add scan_listener -netnum 2 -listener racadg-scanlsnr -endpoints "TCP:1522"
[grid@rac1 ~]$ srvctl start scan_listener -netnum 2
[grid@rac1 ~]$ srvctl status scan_listener -netnum 2
SCAN Listener RACADG-SCANLSNR_SCAN1_NET2 is enabled
SCAN listener RACADG-SCANLSNR_SCAN1_NET2 is running on node rac1
[grid@rac1 ~]$ srvctl config scan_listener -netnum 2
SCAN Listener RACADG-SCANLSNR_SCAN1_NET2 exists. Port: TCP:1522
Registration invited nodes:
Registration invited subnets:
SCAN Listener is enabled.
SCAN Listener is individually enabled on nodes:
SCAN Listener is individually disabled on nodes:
[grid@rac1 ~]$ crsctl status res -t |grep -A 2 LISTENER
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER_ADG.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.MGMTLSNR
[grid@rac1 ~]$ crsctl status res -t |grep -A 2 SCAN
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.MGMTLSNR
--
ora.RACADG-SCANLSNR_SCAN1_NET2.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.cvu
[grid@rac1 ~]$
–检查监听状态
[grid@rac1 ~]$ netstat -an |grep 1521|grep LISTEN tcp 0 0 169.254.242.79:1521 0.0.0.0:* LISTEN tcp 0 0 192.168.60.61:1521 0.0.0.0:* LISTEN -----rac1-priv tcp 0 0 192.168.56.63:1521 0.0.0.0:* LISTEN -----rac1-vip tcp 0 0 192.168.56.61:1521 0.0.0.0:* LISTEN -----rac1 [grid@rac1 ~]$ netstat -an |grep 1522|grep LISTEN tcp 0 0 192.168.209.65:1522 0.0.0.0:* LISTEN -----rac-scan tcp 0 0 192.168.209.63:1522 0.0.0.0:* LISTEN -----rac1-adg-vip [grid@rac1 ~]$ lsnrctl status LISTENER LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 16-FEB-2016 21:41:54 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production Start Date 16-FEB-2016 17:59:39 Uptime 0 days 3 hr. 42 min. 14 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/12.1.0.2/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.61)(PORT=1521))) -----rac1 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.63)(PORT=1521))) -----rac1-vip (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=rac1)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.1.0.2/dbhome_1/admin/lunar/xdb_wallet))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "lunar" has 1 instance(s). Instance "lunar1", status READY, has 1 handler(s) for this service... Service "lunarXDB" has 1 instance(s). Instance "lunar1", status READY, has 1 handler(s) for this service... The command completed successfully [grid@rac1 ~]$ [grid@rac1 ~]$ lsnrctl status LISTENER_ADG LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 16-FEB-2016 21:41:59 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_ADG))) STATUS of the LISTENER ------------------------ Alias LISTENER_ADG Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production Start Date 16-FEB-2016 21:13:48 Uptime 0 days 0 hr. 28 min. 11 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/12.1.0.2/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener_adg/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_ADG))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.209.63)(PORT=1522))) The listener supports no services The command completed successfully [grid@rac1 ~]$
配置ORACLE数据库实例支持多个网络：
LUNARRAC1_LOCAL_NET1 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))) LUNARRAC1_LOCAL_NET2 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-adg-vip)(PORT = 1522))) LUNARRAC2_LOCAL_NET1 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))) LUNARRAC2_LOCAL_NET2 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-adg-vip)(PORT = 1522))) LUNARRAC_REMOTE_NET1 =(DESCRIPTION_LIST =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521)))) LUNARRAC_REMOTE_NET2 =(DESCRIPTION_LIST =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = racadg-scan)(PORT = 1522)))) [oracle@rac1 admin]$ ss SQL*Plus: Release 12.1.0.2.0 Production on Thu Feb 18 21:58:50 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options SYS@lunar1> SYS@lunar1>alter system set listener_networks='((NAME=network1)(LOCAL_LISTENER=LUNARRAC1_LOCAL_NET1)(REMOTE_LISTENER=LUNARRAC_REMOTE_NET1))','((NAME=network2)(LOCAL_LISTENER=LUNARRAC1_LOCAL_NET2)(REMOTE_LISTENER=LUNARRAC_REMOTE_NET2))' sid='lunar1'; System altered. Elapsed: 00:00:00.36 SYS@lunar1>alter system set listener_networks='((NAME=network1)(LOCAL_LISTENER=LUNARRAC2_LOCAL_NET1)(REMOTE_LISTENER=LUNARRAC_REMOTE_NET1))','((NAME=network2)(LOCAL_LISTENER=LUNARRAC2_LOCAL_NET2)(REMOTE_LISTENER=LUNARRAC_REMOTE_NET2))' sid='lunar2'; System altered. Elapsed: 00:00:00.19 SYS@lunar1>alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521))))' sid='lunar1'; System altered. Elapsed: 00:00:00.03 SYS@lunar1>alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip)(PORT=1521))))' sid='lunar2'; System altered. Elapsed: 00:00:00.80 SYS@lunar1>
配置客户端连接串
—检查数据库是否可以登录：
[oracle@lunarrac ~]$ ss SQL*Plus: Release 12.1.0.2.0 Production on Fri Feb 19 08:57:30 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options SYS@lunar1>conn sys/oracle@//lunarrac-scan:1521/lunar as sysdba Connected. SYS@//lunarrac-scan:1521/lunar>conn sys/oracle@//lunaradg-scan:1522/lunar as sysdba Connected. SYS@//lunaradg-scan:1522/lunar>conn system/oracle@//lunarrac-scan:1521/lunar Connected. SYSTEM@//lunarrac-scan:1521/lunar>conn system/oracle@//lunaradg-scan:1522/lunar Connected. SYSTEM@//lunaradg-scan:1522/lunar>conn sys/oracle@lunarrac.vip as sysdba Connected. SYS@lunarrac.vip>conn sys/oracle@lunarrac.scanip as sysdba Connected. SYS@lunarrac.scanip>conn sys/oracle@lunaradg.vip as sysdba Connected. SYS@lunaradg.vip>conn sys/oracle@lunaradg.scanip as sysdba Connected. SYS@lunaradg.scanip>conn sys/oracle@rac1adg as sysdba Connected. SYS@rac1adg>conn sys/oracle@rac2adg as sysdba Connected. SYS@rac2adg>conn sys/oracle@racadg.vip as sysdba Connected. SYS@racadg.vip>conn sys/oracle@racadg.scanip as sysdba Connected. SYS@racadg.scanip>conn sys/oracle@rac1 as sysdba Connected. SYS@rac1>conn sys/oracle@rac2 as sysdba Connected. SYS@rac2>conn sys/oracle@racdb.vip as sysdba Connected. SYS@racdb.vip>conn sys/oracle@racdb.scanip as sysdba Connected. SYS@racdb.scanip>
至此已经全部完成。
Oracle 12.1 RAC 系列：
Oracle 12.1 RAC 系列-安装新主机，识别老存储和恢复数据库
Oracle 12.1 RAC 系列 – 配置第二个网络和相应的SCAN2
