Gunther Oracle APEX und Datenbank Wiki

Benutzer-Werkzeuge

Webseiten-Werkzeuge

Zuletzt angesehen:
dba:rac_add_second_ip

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen RevisionVorhergehende Überarbeitung
dba:rac_add_second_ip [2013/12/18 07:18] – [Umsetzung] gpipperrdba:rac_add_second_ip [2013/12/18 08:10] (aktuell) – [Umsetzung] gpipperr
Zeile 357: Zeile 357:
  
  
-# the create LISTENER_PL ; Check carefully that you use network 2+# the create LISTENER_GPI ; Check carefully that you use network 2
  
 </code> </code>
Zeile 363: Zeile 363:
  
 <code bash> <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> </code>
  
Zeile 381: Zeile 381:
 vi $TNS_ADMIN/tnsnames.ora 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 402: Zeile 402:
 show parameter listner 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> </code>
Zeile 426: Zeile 426:
 vi $TNS_ADMIN/tnsnames.ora vi $TNS_ADMIN/tnsnames.ora
  
-tnsping new_pl_db+tnsping new_GPI_db
  
-sqlplus system@new_pl_db+sqlplus system@new_GPI_db
  
 </code> </code>
dba/rac_add_second_ip.txt · Zuletzt geändert: 2013/12/18 08:10 von gpipperr