Dans certains cas, il peut être nécessaire de gérer deux VIP SCAN sur un cluster Oracle RAC 12cR1.
La création de la deuxième VIP SCAN se fait de la manière qui suit.
Configuration initiale du cluster (une SCAN)
Noeud 1
ifconfig
1 | <strong>eth2</strong> Link encap:Ethernet HWaddr 08:00:27:09:9C:56 |
1 | <strong>inet addr:192.168.20.11 Bcast:192.168.20.255 Mask:255.255.255.0</strong> |
1 | inet6 addr: fe80::a00:27ff:fe09:9c56/64 Scope:Link |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
1 | RX packets:39204 errors:0 dropped:0 overruns:0 frame:0 |
1 | TX packets:77206 errors:0 dropped:0 overruns:0 carrier:0 |
1 | collisions:0 txqueuelen:1000 |
1 | RX bytes:14794613 (14.1 MiB) TX bytes:126633109 (120.7 MiB) |
1 | <strong>eth2:1</strong> Link encap:Ethernet HWaddr 08:00:27:09:9C:56 |
1 | <strong>inet addr:192.168.20.111 Bcast:192.168.20.255 Mask:255.255.255.0</strong> |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
1 | <strong>eth2:3</strong> Link encap:Ethernet HWaddr 08:00:27:09:9C:56 |
1 | <strong>inet addr:192.168.20.110 Bcast:192.168.20.255 Mask:255.255.255.0</strong> |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
1 | <strong>eth3</strong> Link encap:Ethernet HWaddr 08:00:27:64:2F:A9 |
1 | <strong>inet addr:192.168.30.11 Bcast:192.168.30.255 Mask:255.255.255.0</strong> |
1 | inet6 addr: fe80::a00:27ff:fe64:2fa9/64 Scope:Link |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
1 | RX packets:2030899 errors:0 dropped:0 overruns:0 frame:0 |
1 | TX packets:1754528 errors:0 dropped:0 overruns:0 carrier:0 |
1 | collisions:0 txqueuelen:1000 |
1 | RX bytes:1511998424 (1.4 GiB) TX bytes:1084570287 (1.0 GiB) |
1 | <strong>eth3:1</strong> Link encap:Ethernet HWaddr 08:00:27:64:2F:A9 |
1 | <strong>inet addr:169.254.77.49 Bcast:169.254.255.255 Mask:255.255.0.0</strong> |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
eth2:1 correspond à l’adresse VIP du noeud de cluster 1
eth2:2 correspond à l’adresse VIP SCAN du cluster
eth3:1 correspond à l’adresse SCAN broadcast du cluster sur le noeud de cluster 1
Noeud 2
1 | <strong>ifconfig </strong> |
1 | <strong>eth2</strong> Link encap:Ethernet HWaddr 08:00:27:D6:A0:27 |
1 | inet addr:192.168.20.12 Bcast:192.168.20.255 Mask:255.255.255.0 |
1 | inet6 addr: fe80::a00:27ff:fed6:a027/64 Scope:Link |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
1 | RX packets:82613 errors:0 dropped:0 overruns:0 frame:0 |
1 | TX packets:33663 errors:0 dropped:0 overruns:0 carrier:0 |
1 | collisions:0 txqueuelen:1000 |
1 | RX bytes:83655903 (79.7 MiB) TX bytes:19787515 (18.8 MiB) |
1 | <strong>eth2:1</strong> Link encap:Ethernet HWaddr 08:00:27:D6:A0:27 |
1 | <strong>inet addr:192.168.20.112 Bcast:192.168.20.255 Mask:255.255.255.0</strong> |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
1 | <strong>eth3</strong> Link encap:Ethernet HWaddr 08:00:27:89:9A:77 |
1 | inet addr:192.168.30.12 Bcast:192.168.30.255 Mask:255.255.255.0 |
1 | inet6 addr: fe80::a00:27ff:fe89:9a77/64 Scope:Link |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
1 | RX packets:1756109 errors:0 dropped:0 overruns:0 frame:0 |
1 | TX packets:2024779 errors:0 dropped:0 overruns:0 carrier:0 |
1 | collisions:0 txqueuelen:1000 |
1 | RX bytes:1083418768 (1.0 GiB) TX bytes:1703830236 (1.5 GiB) |
1 | <strong>eth3:1</strong> Link encap:Ethernet HWaddr 08:00:27:89:9A:77 |
1 | <strong>inet addr:169.254.127.150 Bcast:169.254.255.255 Mask:255.255.0.0</strong> |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
eth2:1 correspond à l’adresse VIP du noeud de cluster 2
eth3:1 correspond à l’adresse SCAN broadcast du cluster sur le noeud de cluster 2
Fichier /etc/hosts de chaque noeud
192.168.20.11 ora12cr1rac1 ora12cr1rac1.nice
192.168.20.12 ora12cr1rac2 ora12cr1rac2.nice
192.168.20.111 ora12cr1rac1-vip ora12cr1rac1-vip.nice
192.168.20.112 ora12cr1rac2-vip ora12cr1rac2-vip.nice
192.168.20.110 ora12ccls-scan
192.168.30.11 ora12cr1cf1
192.168.30.12 ora12cr1cf2
192.168.30.110 ora12cclsvlan2-scan
192.168.30.111 ora12cr1vlan2rac1-vip ora12cr1vlan2rac1-vip.nice
192.168.30.112 ora12cr1vlan2rac2-vip ora12cr1vlan2rac2-vip.nice
192.168.20.12 ora12cr1rac2 ora12cr1rac2.nice
192.168.20.111 ora12cr1rac1-vip ora12cr1rac1-vip.nice
192.168.20.112 ora12cr1rac2-vip ora12cr1rac2-vip.nice
192.168.20.110 ora12ccls-scan
192.168.30.11 ora12cr1cf1
192.168.30.12 ora12cr1cf2
192.168.30.110 ora12cclsvlan2-scan
192.168.30.111 ora12cr1vlan2rac1-vip ora12cr1vlan2rac1-vip.nice
192.168.30.112 ora12cr1vlan2rac2-vip ora12cr1vlan2rac2-vip.nice
Création du deuxième réseau SCAN
1 | <strong>su - root</strong> |
1 | <strong>export ORACLE_HOME=/oracle/grid</strong> |
1 | <strong>export PATH=$ORACLE_HOME/bin:$PATH</strong> |
1 | <strong>srvctl add network -netnum 2 -subnet 192.168.30.0/255.255.255.0</strong> |
1 | <strong>srvctl add vip -node ora12cr1rac1 -netnum 2 -address ora12cr1vlan2rac1-vip/255.255.255.0</strong> |
1 | <strong>srvctl add vip -node ora12cr1rac2 -netnum 2 -address ora12cr1vlan2rac2-vip/255.255.255.0</strong> |
1 | <strong>srvctl add scan -scanname ora12cclsvlan2-scan -netnum 2</strong> |
1 | <strong>srvctl start vip -node ora12cr1rac1 -netnum 2</strong> |
1 | <strong>srvctl start vip -node ora12cr1rac2 -netnum 2</strong> |
Afin de valider le bon fonctionnement de la nouvelle configuration, rebooter les noeuds du cluster
Etat du réseau après création du deuxième réseau SCAN
Noeud 1
1 | <strong>ifconfig</strong> |
1 | <strong>eth3</strong> Link encap:Ethernet HWaddr 08:00:27:64:2F:A9 |
1 | <strong>inet addr:192.168.30.11 Bcast:192.168.30.255 Mask:255.255.255.0</strong> |
1 | inet6 addr: fe80::a00:27ff:fe64:2fa9/64 Scope:Link |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
1 | RX packets:321774 errors:0 dropped:0 overruns:0 frame:0 |
1 | TX packets:262946 errors:0 dropped:0 overruns:0 carrier:0 |
1 | collisions:0 txqueuelen:1000 |
1 | RX bytes:250577987 (238.9 MiB) TX bytes:155204365 (148.0 MiB) |
1 | <strong>eth3:1</strong> Link encap:Ethernet HWaddr 08:00:27:64:2F:A9 |
1 | <strong>inet addr:169.254.77.49 Bcast:169.254.255.255 Mask:255.255.0.0</strong> |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
1 | <span style="color: #ff0000;"><strong>eth3:3</strong></span> Link encap:Ethernet HWaddr 08:00:27:64:2F:A9 |
1 | <strong>inet addr:192.168.30.111 Bcast:192.168.30.255 Mask:255.255.255.0</strong> |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
1 | <span style="color: #ff0000;"><strong>eth3:4</strong> </span> Link encap:Ethernet HWaddr 08:00:27:64:2F:A9 |
1 | <span style="color: #ff0000;"><strong>inet addr:192.168.30.110 Bcast:192.168.30.255 Mask:255.255.255.0</strong></span> |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
En rouge-gras l’ajout de la nouvelle VIP et de la nouvelle SCAN.
Noeud 2
1 | <strong>ifconfig</strong> |
1 | <strong>eth2</strong> Link encap:Ethernet HWaddr 08:00:27:D6:A0:27 |
1 | <strong>inet addr:192.168.20.12 Bcast:192.168.20.255 Mask:255.255.255.0</strong> |
1 | inet6 addr: fe80::a00:27ff:fed6:a027/64 Scope:Link |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
1 | RX packets:7162 errors:0 dropped:0 overruns:0 frame:0 |
1 | TX packets:6552 errors:0 dropped:0 overruns:0 carrier:0 |
1 | collisions:0 txqueuelen:1000 |
1 | RX bytes:1399489 (1.3 MiB) TX bytes:3855506 (3.6 MiB) |
1 | <strong>eth2:1</strong> Link encap:Ethernet HWaddr 08:00:27:D6:A0:27 |
1 | <strong>inet addr:192.168.20.112 Bcast:192.168.20.255 Mask:255.255.255.0</strong> |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
1 | <strong>eth2:2</strong> Link encap:Ethernet HWaddr 08:00:27:D6:A0:27 |
1 | <strong>inet addr:192.168.20.110 Bcast:192.168.20.255 Mask:255.255.255.0</strong> |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
1 | <strong>eth3</strong> Link encap:Ethernet HWaddr 08:00:27:89:9A:77 |
1 | <strong>inet addr:192.168.30.12 Bcast:192.168.30.255 Mask:255.255.255.0</strong> |
1 | inet6 addr: fe80::a00:27ff:fe89:9a77/64 Scope:Link |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
1 | RX packets:275025 errors:0 dropped:0 overruns:0 frame:0 |
1 | TX packets:334746 errors:0 dropped:0 overruns:0 carrier:0 |
1 | collisions:0 txqueuelen:1000 |
1 | RX bytes:163448505 (155.8 MiB) TX bytes:296578261 (282.8 MiB) |
1 | <strong>eth3:1</strong> Link encap:Ethernet HWaddr 08:00:27:89:9A:77 |
1 | <strong>inet addr:169.254.127.150 Bcast:169.254.255.255 Mask:255.255.0.0</strong> |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
1 | <span style="color: #ff0000;"><strong>eth3:2</strong></span> Link encap:Ethernet HWaddr 08:00:27:89:9A:77 |
1 | <span style="color: #ff0000;"><strong>inet addr:192.168.30.112 Bcast:192.168.30.255 Mask:255.255.255.0</strong></span> |
1 | UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
En rouge-gras, ajout de la nouvelle VIP
Statut des VIP déclarées sur le cluster RAC
1 | <strong>srvctl status vip -node ora12cr1rac1</strong> |
1 | VIP ora12cr1rac1-vip is enabled |
1 | VIP ora12cr1rac1-vip is running on node: ora12cr1rac1 |
1 | VIP ora12cr1vlan2rac1-vip is enabled |
1 | VIP ora12cr1vlan2rac1-vip is running on node: ora12cr1rac1 |
1 | <strong>srvctl status vip -node ora12cr1rac2</strong> |
1 | VIP ora12cr1rac2-vip is enabled |
1 | VIP ora12cr1rac2-vip is running on node: ora12cr1rac2 |
1 | VIP ora12cr1vlan2rac2-vip is enabled |
1 | VIP ora12cr1vlan2rac2-vip is running on node: ora12cr1rac2 |
Ajout du listener sur la nouvelle SCAN
1 | <strong>srvctl add scan_listener -netnum 2</strong> |
1 | <strong>srvctl start scan_listener -netnum 2</strong> |
1 | <strong>srvctl status scan_listener -netnum 1</strong> |
1 | SCAN Listener LISTENER_SCAN1 is enabled |
1 | SCAN listener LISTENER_SCAN1 is running on node ora12cr1rac1 |
1 | <strong>srvctl status scan_listener -netnum 2</strong> |
1 | SCAN Listener LISTENER_SCAN1_NET2 is enabled |
1 | SCAN listener LISTENER_SCAN1_NET2 is running on node ora12cr1rac2 |
Test des listeners SCAN
[
1 | grid@ora12cr1rac1 grid]$ <strong>lsnrctl status listener_scan1</strong> |
1 | LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 18-JAN-2017 22:40:34 |
1 | Copyright (c) 1991, 2014, Oracle. All rights reserved. |
1 | Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))) |
1 | STATUS of the LISTENER |
1 | ------------------------ |
1 | Alias LISTENER_SCAN1 |
1 | Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production |
1 | Start Date 17-JAN-2017 18:56:06 |
1 | Uptime 1 days 3 hr. 44 min. 27 sec |
1 | Trace Level off |
1 | Security ON: Local OS Authentication |
1 | SNMP OFF |
1 | Listener Parameter File /oracle/grid/network/admin/listener.ora |
1 | Listener Log File /oracle/base/diag/tnslsnr/ora12cr1rac1/listener_scan1/alert/log.xml |
1 | Listening Endpoints Summary... |
1 | (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1))) |
1 | (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.20.110)(PORT=1521))) |
1 | Services Summary... |
1 | Service "ACHRAC" has 1 instance(s). |
1 | Instance "ACHRAC_1", status READY, has 1 handler(s) for this service... |
1 | Service "ACHRACXDB" has 1 instance(s). |
1 | Instance "ACHRAC_1", status READY, has 1 handler(s) for this service... |
1 | Service "_mgmtdb" has 1 instance(s). |
1 | Instance "-MGMTDB", status BLOCKED, has 1 handler(s) for this service... |
1 | Service "pdbachrac1" has 1 instance(s). |
1 | Instance "ACHRAC_1", status READY, has 1 handler(s) for this service... |
1 | Service "pdbachrac2" has 1 instance(s). |
1 | Instance "ACHRAC_1", status READY, has 1 handler(s) for this service... |
1 | Service "pdbachrac3" has 1 instance(s). |
1 | Instance "ACHRAC_1", status READY, has 1 handler(s) for this service... |
1 | The command completed successfully |
Le listener_scan nouveau n’écoute pour le moment aucun service :
1 | [grid@ora12cr1rac2 ~]$ <strong>lsnrctl status listener_scan1_net2</strong> |
1 | LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 18-JAN-2017 22:44:00 |
1 | Copyright (c) 1991, 2014, Oracle. All rights reserved. |
1 | Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1_NET2))) |
1 | STATUS of the LISTENER |
1 | ------------------------ |
1 | Alias LISTENER_SCAN1_NET2 |
1 | Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production |
1 | Start Date 18-JAN-2017 22:37:15 |
1 | Uptime 0 days 0 hr. 6 min. 44 sec |
1 | Trace Level off |
1 | Security ON: Local OS Authentication |
1 | SNMP OFF |
1 | Listener Parameter File /oracle/grid/network/admin/listener.ora |
1 | Listener Log File /oracle/base/diag/tnslsnr/ora12cr1rac2/listener_scan1_net2/alert/log.xml |
1 | Listening Endpoints Summary... |
1 | (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1_NET2))) |
1 | (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.30.110)(PORT=1521))) |
1 | The listener supports no services |
1 | The command completed successfully |
Création d’une nouvelle base de données RAC
A l’aide de dbca nous créons une nouvelle base de données nommée VIP2RAC. Sans rien modifier des scripts de création de VIP2RAC, dbca fait pointer par défaut les instances sur le premier SCAN listener.
Modification du pointage SCAN des instances de VIP2RAC (nouvelle BDD)
1 | [oracle@ora12cr1rac1 database]$ <strong>export ORACLE_SID=VIP2RAC_2</strong> |
1 | [oracle@ora12cr1rac1 database]$ <strong>sqlplus /nolog</strong> |
1 | SQL*Plus: Release 12.1.0.2.0 Production on Thu Jan 19 07:46:12 2017 |
1 | Copyright (c) 1982, 2014, Oracle. All rights reserved. |
1 | SQL> <strong>connect / as sysdba</strong> |
1 | Connected. |
1 | SQL> <strong>show parameter listener</strong> |
1 | NAME TYPE VALUE |
1 | ------------------------------------ ----------- ------------------------------ |
1 | listener_networks string |
1 | local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST= |
1 | 192.168.20.111)(PORT=1521)) |
1 | remote_listener string ora12ccls-scan:1521 |
1 | SQL> <strong>alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.30.111)(PORT=1521))' scope=both; </strong> |
1 | System altered. |
1 | SQL> <strong>alter system register;</strong> |
1 | System altered. |
1 | SQL> <strong>alter system set remote_listener='ora12cclsvlan2-scan:1521' scope=both;</strong> |
1 | System altered. |
1 | SQL> <strong>alter system register;</strong> |
1 | System altered. |
1 | SQL> <strong>exit</strong> |
1 | Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production |
1 | With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, |
1 | Advanced Analytics and Real Application Testing options |
Vérification de l’état des SCAN listeners
1 | [grid@ora12cr1rac2 ~]$ <strong>lsnrctl status listener_scan1</strong> |
1 | LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 18-JAN-2017 07:51:41 |
1 | Copyright (c) 1991, 2014, Oracle. All rights reserved. |
1 | Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))) |
1 | STATUS of the LISTENER |
1 | ------------------------ |
1 | Alias LISTENER_SCAN1 |
1 | Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production |
1 | Start Date 18-JAN-2017 07:21:14 |
1 | Uptime 0 days 0 hr. 30 min. 27 sec |
1 | Trace Level off |
1 | Security ON: Local OS Authentication |
1 | SNMP OFF |
1 | Listener Parameter File /oracle/grid/network/admin/listener.ora |
1 | Listener Log File /oracle/base/diag/tnslsnr/ora12cr1rac2/listener_scan1/alert/log.xml |
1 | Listening Endpoints Summary... |
1 | (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1))) |
1 | (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.20.110)(PORT=1521))) |
1 | Services Summary... |
1 | Service "-MGMTDBXDB" has 1 instance(s). |
1 | Instance "-MGMTDB", status READY, has 1 handler(s) for this service... |
1 | Service "ACHRAC" has 2 instance(s). |
1 | Instance "ACHRAC_1", status READY, has 1 handler(s) for this service... |
1 | Instance "ACHRAC_2", status READY, has 1 handler(s) for this service... |
1 | Service "ACHRACXDB" has 2 instance(s). |
1 | Instance "ACHRAC_1", status READY, has 1 handler(s) for this service... |
1 | Instance "ACHRAC_2", status READY, has 1 handler(s) for this service... |
1 | Service "_mgmtdb" has 1 instance(s). |
1 | Instance "-MGMTDB", status READY, has 1 handler(s) for this service... |
1 | Service "ora12ccls" has 1 instance(s). |
1 | Instance "-MGMTDB", status READY, has 1 handler(s) for this service... |
1 | Service "pdbachrac1" has 2 instance(s). |
1 | Instance "ACHRAC_1", status READY, has 1 handler(s) for this service... |
1 | Instance "ACHRAC_2", status READY, has 1 handler(s) for this service... |
1 | Service "pdbachrac2" has 2 instance(s). |
1 | Instance "ACHRAC_1", status READY, has 1 handler(s) for this service... |
1 | Instance "ACHRAC_2", status READY, has 1 handler(s) for this service... |
1 | Service "pdbachrac3" has 2 instance(s). |
1 | Instance "ACHRAC_1", status READY, has 1 handler(s) for this service... |
1 | Instance "ACHRAC_2", status READY, has 1 handler(s) for this service... |
1 | The command completed successfully |
1 |
1 | [grid@ora12cr1rac1 ~]$<strong> lsnrctl status listener_scan1_net2</strong> |
1 | LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 18-JAN-2017 07:51:37 |
1 | Copyright (c) 1991, 2014, Oracle. All rights reserved. |
1 | Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1_NET2))) |
1 | STATUS of the LISTENER |
1 | ------------------------ |
1 | Alias LISTENER_SCAN1_NET2 |
1 | Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production |
1 | Start Date 18-JAN-2017 07:19:41 |
1 | Uptime 0 days 0 hr. 31 min. 56 sec |
1 | Trace Level off |
1 | Security ON: Local OS Authentication |
1 | SNMP OFF |
1 | Listener Parameter File /oracle/grid/network/admin/listener.ora |
1 | Listener Log File /oracle/base/diag/tnslsnr/ora12cr1rac1/listener_scan1_net2/alert/log.xml |
1 | Listening Endpoints Summary... |
1 | (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1_NET2))) |
1 | (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.30.110)(PORT=1521))) |
1 | Services Summary... |
1 | Service "VIP2RAC" has 2 instance(s). |
1 | Instance "VIP2RAC_1", status READY, has 1 handler(s) for this service... |
1 | Instance "VIP2RAC_2", status READY, has 1 handler(s) for this service... |
1 | Service "VIP2RACXDB" has 2 instance(s). |
1 | Instance "VIP2RAC_1", status READY, has 1 handler(s) for this service... |
1 | Instance "VIP2RAC_2", status READY, has 1 handler(s) for this service... |
1 | Service "pdbvip2rac" has 2 instance(s). |
1 | Instance "VIP2RAC_1", status READY, has 1 handler(s) for this service... |
1 | Instance "VIP2RAC_2", status READY, has 1 handler(s) for this service... |
1 | The command completed successfully |
Vérification des SCAN listeners et des SCAN au niveau du Grid Control
1 | [grid@ora12cr1rac1 ~]$ <strong>srvctl config scan_listener -netnum 1</strong> |
1 | SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521 |
1 | Registration invited nodes: |
1 | Registration invited subnets: |
1 | SCAN Listener is enabled. |
1 | SCAN Listener is individually enabled on nodes: |
1 | SCAN Listener is individually disabled on nodes: |
1 | [grid@ora12cr1rac1 ~]$ <strong>srvctl config scan_listener -netnum 2</strong> |
1 | SCAN Listener LISTENER_SCAN1_NET2 exists. Port: TCP:1521 |
1 | Registration invited nodes: |
1 | Registration invited subnets: |
1 | SCAN Listener is enabled. |
1 | SCAN Listener is individually enabled on nodes: |
1 | SCAN Listener is individually disabled on nodes: |
1 | [grid@ora12cr1rac1 ~]$ <strong>srvctl status scan_listener -netnum 1</strong> |
1 | SCAN Listener LISTENER_SCAN1 is enabled |
1 | SCAN listener LISTENER_SCAN1 is running on node ora12cr1rac2 |
1 | [grid@ora12cr1rac1 ~]$ <strong>srvctl status scan_listener -netnum 2</strong> |
1 | SCAN Listener LISTENER_SCAN1_NET2 is enabled |
1 | SCAN listener LISTENER_SCAN1_NET2 is running on node ora12cr1rac1 |
1 | [grid@ora12cr1rac1 ~]$ <strong>srvctl config scan -netnum 1</strong> |
1 | SCAN name: ora12ccls-scan, Network: 1 |
1 | Subnet IPv4: 192.168.20.0/255.255.255.0/eth2, static |
1 | Subnet IPv6: |
1 | SCAN 0 IPv4 VIP: 192.168.20.110 |
1 | SCAN VIP is enabled. |
1 | SCAN VIP is individually enabled on nodes: |
1 | SCAN VIP is individually disabled on nodes: |
1 | [grid@ora12cr1rac1 ~]$ <strong>srvctl config scan -netnum 2</strong> |
1 | SCAN name: ora12cclsvlan2-scan, Network: 2 |
1 | Subnet IPv4: 192.168.30.0/255.255.255.0/, static |
1 | Subnet IPv6: |
1 | SCAN 0 IPv4 VIP: 192.168.30.110 |
1 | SCAN VIP is enabled. |
1 | SCAN VIP is individually enabled on nodes: |
1 | SCAN VIP is individually disabled on nodes: |
1 | [grid@ora12cr1rac1 ~]$ <strong>srvctl status scan -netnum 1</strong> |
1 | SCAN VIP scan1 is enabled |
1 | SCAN VIP scan1 is running on node ora12cr1rac2 |
1 | [grid@ora12cr1rac1 ~]$ <strong>srvctl status scan -netnum 2</strong> |
1 | SCAN VIP scan1_net2 is enabled |
1 | SCAN VIP scan1_net2 is running on node ora12cr1rac1 |
1 |
A ce point, la configuration de la deuxième SCAN est réalisée et les instances de la nouvelle base de données RAC pointent bien sur la SCAN numéro 2