Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- dba:rac_add_second_ip [2013/12/17 12:26] – [Ein neues VIP und ein neues Netzwerk einem RAC Cluster ONLINE hinzufügen] gpipperr
+++ dba:rac_add_second_ip [2013/12/18 08:10] (aktuell) – [Umsetzung] gpipperr
@@ Zeile 43: / Zeile 43: @@
 |Host 1 |racdb01|192.162.178.220|
 |Host 2 |racdb01|192.162.178.222|
-|PL Lan Host 1  |racdb01-GPI|192.162.183.220|
+|GPI Lan Host 1  |racdb01-GPI|192.162.183.220|
-|PL  Lan Host 2  |racdb02-PL|192.162.183.222|
+|GPI  Lan Host 2  |racdb02-PL|192.162.183.222|
-|VIP PL  Lan Host 1  |racdb01-GPI-vip |192.162.183.224|
+|VIP GPI  Lan Host 1  |racdb01-GPI-vip |192.162.183.224|
-|VIP PL Lan Host 2  |racdb02-GPI-vip |192.162.183.226|
+|VIP GPI Lan Host 2  |racdb02-GPI-vip |192.162.183.226|
@@ Zeile 77: / Zeile 77: @@
 </code>
-Da sich das Routing beim Aktivieren einer Netzwerkarte ändert kann ein Lösung sein "Policy Routing" einzuetzen.
+Da sich das Routing beim Aktivieren einer Netzwerkarte ändert, ist ein Lösung "Policy Routing" einzuetzen.
 Policy Routing With Linux Details:
@@ Zeile 89: / Zeile 89: @@
 <code bash>
-set ORALCE_HOME=/opt/11.2.0.3/GRID
+set ORALCE_HOME=/u01/app/11.2.0.4/grid
 cd %ORACLE_HOME/bin
@@ Zeile 208: / Zeile 208: @@
 /etc/iproute2/rt_tables:
- plvlan
+ gpivlan
 /etc/sysconfig/network-scripts/route-bond3:
-default via 192.162.183.254 dev bond3 table plvlan
+default via 192.162.183.254 dev bond3 table gpivlan
@@ Zeile 220: / Zeile 220: @@
 from 192.162.183.224 lookup plvlan
 from 192.162.183.226 lookup plvlan
-from all to 192.162.183.220 lookup plvlan
+from all to 192.162.183.220 lookup gpivlan
-from all to 192.162.183.224 lookup plvlan
+from all to 192.162.183.224 lookup gpivlan
@@ Zeile 247: / Zeile 247: @@
 <code bash>
-set ORALCE_HOME=/opt/11.2.0.3/GRID
+set ORALCE_HOME=/u01/app/11.2.0.4/grid
 cd %ORACLE_HOME/bin
@@ Zeile 292: / Zeile 292: @@
 <code bash>
-set ORALCE_HOME=/opt/11.2.0.3/GRID
+set ORALCE_HOME=/u01/app/11.2.0.4/grid
 %ORACLE_HOME/bin/cluvfy comp nodecon -n racdb01,racdb02  -verbose
 </code>
@@ Zeile 301: / Zeile 301: @@
 <code bash>
-set ORALCE_HOME=/opt/11.2.0.3/GRID
+set ORALCE_HOME=/u01/app/11.2.0.4/grid
 cd %ORACLE_HOME/bin
@@ Zeile 313: / Zeile 313: @@
 <code bash>
-set ORALCE_HOME=/opt/11.2.0.3/GRID
+set ORALCE_HOME=/u01/app/11.2.0.4/grid
 cd %ORACLE_HOME/bin
@@ Zeile 336: / Zeile 336: @@
 ==Neue Vips überprüfen==
 **User root , auf 1 Knoten für das ganze Cluster**
+VIP is zu diesem Zeitpunkt noch offline, bis der Listener die Resource anfordert und es online genommen wird.
 <code bash>
@@ Zeile 351: / Zeile 353: @@
 <code bash>
 #Als user Oracle GRID
-set ORALCE_HOME=/opt/11.2.0.3/GRID
+set ORALCE_HOME=/u01/app/11.2.0.4/grid
 %ORACLE_HOME/bin/netca &
-# the create LISTENER_PL ; Check carefully that you use network 2
+# the create LISTENER_GPI ; Check carefully that you use network 2
 </code>
@@ Zeile 361: / Zeile 363: @@
 <code bash>
-./srvctl add listener -l LISTENER_PL -s -p 1521 -k 2
+./srvctl add listener -l LISTENER_GPI -s -p 1521 -k 2
 </code>
@@ Zeile 379: / Zeile 381: @@
 vi $TNS_ADMIN/tnsnames.ora
-#add entry local listner listener_net2_racdb01_pl
+#add entry local listner listener_net2_racdb01_GPI
-listener_net2_racdb01_pl=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=racdb01-GPI-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.162.183.224)(PORT=1521)(IP=FIRST))))
+listener_net2_racdb01_GPI=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=racdb01-GPI-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.162.183.224)(PORT=1521)(IP=FIRST))))
-#add entry local listner listener_net2_racdb02_pl
+#add entry local listner listener_net2_racdb02_GPI
-listener_net2_racdb02_pl=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=racdb02-GPI-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.162.183.226)(PORT=1521)(IP=FIRST))))
+listener_net2_racdb02_GPI=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=racdb02-GPI-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.162.183.226)(PORT=1521)(IP=FIRST))))
@@ Zeile 400: / Zeile 402: @@
 show parameter listner
-alter system set LISTENER_NETWORKS='((NAME=network2)(LOCAL_LISTENER=listener_net2_racdb01_pl)(REMOTE_LISTENER=listener_net2_racdb02_pl))' sid='GPIDB1'
+alter system set LISTENER_NETWORKS='((NAME=network2)(LOCAL_LISTENER=listener_net2_racdb01_GPI)(REMOTE_LISTENER=listener_net2_racdb02_GPI))' sid='GPIDB1'
-alter system set LISTENER_NETWORKS='((NAME=network2)(LOCAL_LISTENER=listener_net2_racdb02_pl)(REMOTE_LISTENER=listener_net2_racdb01_pl))' sid='GPIDB2';
+alter system set LISTENER_NETWORKS='((NAME=network2)(LOCAL_LISTENER=listener_net2_racdb02_GPI)(REMOTE_LISTENER=listener_net2_racdb01_GPI))' sid='GPIDB2';
 </code>
@@ Zeile 424: / Zeile 426: @@
 vi $TNS_ADMIN/tnsnames.ora
-tnsping new_pl_db
+tnsping new_GPI_db
-sqlplus system@new_pl_db
+sqlplus system@new_GPI_db
 </code>