联系:手机/微信(+86 17813235971) QQ(107644445)
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
有客户因为归档日志量每天很大,为了不影响业务,需要配置一个单独的万兆网络来专门的传输归档日志到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
到这里,可以正常的访问两个库,监听已经配置完成,数据库之间也可以使用特定网络
netca增加的
请问listener_dg是哪一步加上去的呢?
验证网卡为万兆网卡
在11.2.0.2之前版本,直接使用如下命令增加网络和vip
参考文档How to Configure A Second Listener on a Separate Network in 11.2 Grid Infrastructure [ID 1063571.1]