11gR2 RAC 配置第二个监听（转载）

此文章是转载惜分飞的文章，觉得很好就收藏了一下，原文链接如下

http://www.xifenfei.com/4497.html

有客户因为归档日志量每天很大,为了不影响业务,需要配置一个单独的万兆网络来专门的传输归档日志到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

到这里,可以正常的访问两个库,监听已经配置完成,数据库之间也可以使用特定网络

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26175573/viewspace-775454/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26175573/viewspace-775454/