有客户因为归档日志量每天很大,为了不影响业务,需要配置一个单独的万兆网络来专门的传输归档日志到DG库,这里就涉及到在11G(11203 Linux) RAC中增加一个监听用来使用专门的网络.这里提供在主库配置第二个监听的整体操作过程,主要涉及配置解析,增加网络,增加vip,配置监听,配置listener_networks
网卡情况
[oracle@q9db01 admin]$ /sbin/ifconfig eth2
eth2 Link encap:Ethernet HWaddr 90:E2:BA:1E:14:34
inet addr:192.168.5.60 Bcast:192.168.5.255 Mask:255.255.255.0
inet6 addr: fe80::92e2:baff:fe1e:1434/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:3932094203 errors:0 dropped:0 overruns:0 frame:0
TX packets:176073749 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:5752649063554 (5.2 TiB) TX bytes:31298228144 (29.1 GiB)
[grid@q9db02 ~]$ /sbin/ifconfig eth2
eth2 Link encap:Ethernet HWaddr 90:E2:BA:1E:13:5C
inet addr:192.168.5.61 Bcast:192.168.5.255 Mask:255.255.255.0
inet6 addr: fe80::92e2:baff:fe1e:135c/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:22861938 errors:0 dropped:0 overruns:0 frame:0
TX packets:187447459 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:2603356463 (2.4 GiB) TX bytes:276672018723 (257.6 GiB)
配置hosts文件
#public dg ip 192.168.5.60 q9db01-dg 192.168.5.61 q9db02-dg 192.168.5.64 q9db01-dg-vip 192.168.5.65 q9db02-dg-vip
CRS中配置
--增加网络资源
[root@q9db01 ~]# srvctl add network -k 2 -S 192.168.5.0/255.255.255.0/eth2 -w static -v
--启动网络资源
[root@q9db01 ~]# crsctl start res ora.net2.network
--增加vip资源
[root@q9db01 ~]# srvctl add vip -n q9db01 -A 192.168.5.64/255.255.255.0 -k 2
[root@q9db01 ~]# srvctl add vip -n q9db02 -A 192.168.5.65/255.255.255.0 -k 2
--启动vip资源
[root@q9db01 ~]# srvctl start vip -i q9db01-dg-vip
[root@q9db01 ~]# srvctl start vip -i q9db02-dg-vip
--netca创建监听
[root@q9db01 ~]# su - grid
[grid@q9db01 ~]$ export DISPLAY=172.18.50.150:0.0
[grid@q9db01 ~]$ netca
------选择Subnet 2(选择网络192.168.5.60网段),选择非1521端口---------
--查看资源状态
[grid@q9db01 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE ONLINE q9db01
ONLINE ONLINE q9db02
ora.DATA.dg
ONLINE ONLINE q9db01
ONLINE ONLINE q9db02
ora.LISTENER.lsnr
ONLINE ONLINE q9db01
ONLINE ONLINE q9db02
ora.LISTENER_DG.lsnr
ONLINE ONLINE q9db01
ONLINE ONLINE q9db02
ora.OCR_VOTE.dg
ONLINE ONLINE q9db01
ONLINE ONLINE q9db02
ora.asm
ONLINE ONLINE q9db01 Started
ONLINE ONLINE q9db02 Started
ora.gsd
OFFLINE OFFLINE q9db01
OFFLINE OFFLINE q9db02
ora.net1.network
ONLINE ONLINE q9db01
ONLINE ONLINE q9db02
ora.net2.network
ONLINE ONLINE q9db01
ONLINE ONLINE q9db02
ora.ons
ONLINE ONLINE q9db01
ONLINE ONLINE q9db02
ora.registry.acfs
ONLINE ONLINE q9db01
ONLINE ONLINE q9db02
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE q9db01
ora.cvu
1 ONLINE ONLINE q9db01
ora.oc4j
1 ONLINE ONLINE q9db01
ora.q9db.db
1 ONLINE ONLINE q9db01 Open
2 ONLINE ONLINE q9db02 Open
ora.q9db01-dg-vip.vip
1 ONLINE ONLINE q9db01
ora.q9db01.vip
1 ONLINE ONLINE q9db01
ora.q9db02-dg-vip.vip
1 ONLINE ONLINE q9db02
ora.q9db02.vip
1 ONLINE ONLINE q9db02
ora.scan1.vip
1 ONLINE ONLINE q9db01
--查看监听状态
[grid@q9db01 ~]$ lsnrctl status listener_dg
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 19-JUN-2013 14:40:24
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_DG)))
STATUS of the LISTENER
------------------------
Alias LISTENER_DG
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 19-JUN-2013 14:38:43
Uptime 0 days 0 hr. 1 min. 42 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/q9db01/listener_dg/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_DG)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.5.64)(PORT=1522)))
The listener supports no services
The command completed successfully
配置listener_networks
--在RDBMS的tnsnames.ora中配置
Q9DB01_LOCAL_NET1 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = q9db01-vip )(PORT = 1521)))
Q9DB01_LOCAL_NET2 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = q9db01-dg-vip )(PORT = 1522)))
Q9DB02_LOCAL_NET1 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = q9db02-vip )(PORT = 1521)))
Q9DB02_LOCAL_NET2 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = q9db02-dg-vip )(PORT = 1522)))
Q9DB_REMOTE_NET2 =(DESCRIPTION_LIST =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = q9db01-dg-vip )
(PORT = 1522)))(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = q9db02-dg-vip )(PORT = 1522))))
--配置listener_networks
----节点1
SQL> ALTER SYSTEM SET listener_networks='((NAME=network1)(LOCAL_LISTENER=Q9DB01_LOCAL_NET1)
(REMOTE_LISTENER=q9dbscan:1521))','((NAME=network2)(LOCAL_LISTENER=Q9DB01_LOCAL_NET2)
(REMOTE_LISTENER=Q9DB_REMOTE_NET2))'SCOPE=BOTH SID='q9db1';
System altered.
----节点2
SQL> ALTER SYSTEM SET listener_networks='((NAME=network1)(LOCAL_LISTENER=Q9DB02_LOCAL_NET1)
(REMOTE_LISTENER=q9db-scan:1521))','((NAME=network2)(LOCAL_LISTENER=Q9DB02_LOCAL_NET2)
(REMOTE_LISTENER=Q9DB_REMOTE_NET2))'SCOPE=BOTH SID='q9db2';
System altered.
查看监听状态
--节点1 [grid@q9db01 ~]$ lsnrctl status listener_dg LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 19-JUN-2013 17:12:45 Copyright (c) 1991, 2011, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_DG))) STATUS of the LISTENER ------------------------ Alias LISTENER_DG Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production Start Date 19-JUN-2013 16:47:03 Uptime 0 days 0 hr. 25 min. 42 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/q9db01/listener_dg/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_DG))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.5.64)(PORT=1522))) Services Summary... Service "q9db" has 2 instance(s). Instance "q9db1", status READY, has 2 handler(s) for this service... Instance "q9db2", status READY, has 1 handler(s) for this service... The command completed successfully --节点2 [grid@q9db02 ~]$ lsnrctl status listener_dg LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 19-JUN-2013 17:12:02 Copyright (c) 1991, 2011, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_DG))) STATUS of the LISTENER ------------------------ Alias LISTENER_DG Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production Start Date 19-JUN-2013 16:52:24 Uptime 0 days 0 hr. 19 min. 37 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/q9db02/listener_dg/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_DG))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.5.65)(PORT=1522))) Services Summary... Service "q9db" has 2 instance(s). Instance "q9db1", status READY, has 1 handler(s) for this service... Instance "q9db2", status READY, has 2 handler(s) for this service... The command completed successfully
测试新监听
--RDBMS目录中tns配置
q9db1dg=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = q9db01-dg-vip)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = q9db1)
)
)
q9db2dg=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = q9db02-dg-vip)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = q9db2)
)
)
--验证结果
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SQL> conn test/test@q9db1dg
Connected.
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string q9db1
SQL> conn test/test@q9db2dg
Connected.
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string q9db2
到这里,可以正常的访问两个库,监听已经配置完成,数据库之间也可以使用特定网络
