Oracle – RAC – Créer une deuxième VIP SCAN sur un RAC

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

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&gt; <strong>connect / as sysdba</strong>


1
 Connected.


1
 SQL&gt; <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&gt; <strong>alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.30.111)(PORT=1521))' scope=both; </strong>

1
System altered.

1
SQL&gt; <strong>alter system register;</strong>

1
System altered.

1
SQL&gt; <strong>alter system set remote_listener='ora12cclsvlan2-scan:1521' scope=both;</strong>

1
System altered.

1
SQL&gt; <strong>alter system register;</strong>

1
System altered.

1
SQL&gt; <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

Author: alexandra