Oracle database modifies the SCAN IP example of 11.2 RAC

In some cases, because it is the C/s architecture, from the previous stand-alone system to the current 11.2 of the RAC, if the client IP address to modify the workload is too large, but also unrealistic, generally recommended directly modify the scan IP address and before, so as to achieve direct business access scan IP implementation applications do not need to be individually configured. Here through a simple demo, to implement the process of modifying the scan IP (network segment unchanged), mainly the scan name for the Scan-xff IP address from 192.168.137.245 modified to 192.168.137.248


View current Scan IP information


[Root-www.111cn.net@xff1 ~]# Ping Xff-scan


PING xff-scan (192.168.137.245) bytes of data.


^c


---xff-scan ping statistics---


2 packets transmitted, 0 received, 100% packet loss, time 1738ms


[root-www.111cn.net@xff1 ~]# crsctl status res-t


--------------------------------------------------------------------------------


NAME TARGET State SERVER State_details


--------------------------------------------------------------------------------


Local Resources


--------------------------------------------------------------------------------


Ora. Data.dg


Online online xff1


Online online xff2


Ora. Listener.lsnr


Online online xff1


Online online xff2


Ora.asm


Online online xff1 started


Online online xff2 started


Ora.gsd


OFFLINE OFFLINE xff1


OFFLINE OFFLINE XFF2


Ora.net1.network


Online online xff1


Online online xff2


Ora.ons


Online online xff1


Online online xff2


--------------------------------------------------------------------------------


Cluster Resources


--------------------------------------------------------------------------------


Ora. Listener_scan1.lsnr


1 Online Online xff1


Ora.cvu


1 Online Online xff1


Ora.oc4j


1 Online Online xff1


Ora.scan1.vip


1 Online Online xff1


Ora.xff1.vip


1 Online Online xff1


Ora.xff2.vip


1 Online Online xff2


Ora.xffdb.db


1 Online Online xff1 Open


2 Online Online xff2 Open


[root-www.111cn.net@xff1 ~]# srvctl config scan


SCAN Name:xff-scan, Network:1/192.168.137.0/255.255.255.0/eth0


SCAN VIP name:scan1, IP:/xff-scan/192.168.137.245


Modify Scan IP


[root-www.111cn.net@xff1 ~]# Srvctl Stop Scan_listener


[root-www.111cn.net@xff1 ~]# srvctl Stop scan


[root-www.111cn.net@xff1 ~]# crsctl status res-t


--------------------------------------------------------------------------------


NAME TARGET State SERVER State_details


--------------------------------------------------------------------------------


Local Resources


--------------------------------------------------------------------------------


Ora. Data.dg


Online online xff1


Online online xff2


Ora. Listener.lsnr


Online online xff1


Online online xff2


Ora.asm


Online online xff1 started


Online online xff2 started


Ora.gsd


OFFLINE OFFLINE xff1


OFFLINE OFFLINE XFF2


Ora.net1.network


Online online xff1


Online online xff2


Ora.ons


Online online xff1


Online online xff2


--------------------------------------------------------------------------------


Cluster Resources


--------------------------------------------------------------------------------


Ora. Listener_scan1.lsnr


1 OFFLINE OFFLINE


Ora.cvu


1 Online Online xff1


Ora.oc4j


1 Online Online xff1


Ora.scan1.vip


1 OFFLINE OFFLINE


Ora.xff1.vip


1 Online Online xff1


Ora.xff2.vip


1 Online Online xff2


Ora.xffdb.db


1 Online Online xff1 Open


2 Online Online xff2 Open





--if DNS, pay attention to modify DNS scan IP information, if it is Hosts file note that multiple nodes need to be modified


[Root-www.111cn.net@xff1 ~]# Ping Xff-scan


PING xff-scan (192.168.137.248) bytes of data.


^c


---xff-scan ping statistics---


2 packets transmitted, 0 received, 100% packet loss, time 1738ms





[root-www.111cn.net@xff1 ~]# srvctl Modify Scan-n Xff-scan


[root-www.111cn.net@xff1 ~]# srvctl config scan


SCAN Name:xff-scan, Network:1/192.168.137.0/255.255.255.0/eth0


SCAN VIP name:scan1, IP:/xff-scan/192.168.137.248


[root-www.111cn.net@xff1 ~]# srvctl Start scan


[root-www.111cn.net@xff1 ~]# srvctl start Scan_listener


[root-www.111cn.net@xff1 ~]# crsctl status res-t


--------------------------------------------------------------------------------


NAME TARGET State SERVER State_details


--------------------------------------------------------------------------------


Local Resources


--------------------------------------------------------------------------------


Ora. Data.dg


Online online xff1


Online online xff2


Ora. Listener.lsnr


Online online xff1


Online online xff2


Ora.asm


Online online xff1 started


Online online xff2 started


Ora.gsd


OFFLINE OFFLINE xff1


OFFLINE OFFLINE XFF2


Ora.net1.network


Online online xff1


Online online xff2


Ora.ons


Online online xff1


Online online xff2


--------------------------------------------------------------------------------


Cluster Resources


--------------------------------------------------------------------------------


Ora. Listener_scan1.lsnr


1 Online Online xff2


Ora.cvu


1 Online Online xff1


Ora.oc4j


1 Online Online xff1


Ora.scan1.vip


1 Online Online xff2


Ora.xff1.vip


1 Online Online xff1


Ora.xff2.vip


1 Online Online xff2


Ora.xffdb.db


1 Online Online xff1 Open


2 Online Online xff2 Open


View the modified Scan listener status


xff2:/home/grid> lsnrctl Status Listener_scan1





Lsnrctl for linux:version 11.2.0.4.0-production on 12-mar-2016 17:02:32





Copyright (c) 1991, 2013, Oracle. All rights reserved.





Connecting to (description= address= (PROTOCOL=IPC) (Key=listener_scan1))


STATUS of the LISTENER


------------------------


Alias Listener_scan1


Version Tnslsnr for Linux:version 11.2.0.4.0-production


Start Date 12-mar-2016 16:59:05


Uptime 0 days 0 hr. 3 min sec


Trace level off


Security On:local OS Authentication


SNMP off


Listener Parameter File/u01/oracle/app/grid/network/admin/listener.ora


Listener Log File/u01/oracle/app/grid/log/diag/tnslsnr/xff2/listener_scan1/alert/log.xml


Listening Endpoints Summary ...


(Description= (address= (PROTOCOL=IPC) (Key=listener_scan1))


(Description= (address= (protocol=tcp) (host=192.168.137.248) (port=1521))


The listener supports no services


The command completed successfully





[Root-www.111cn.net@xff2 ~]# Su-oracle


Xff2:/home/oracle> Sqlplus/as SYSDBA





Sql*plus:release 11.2.0.4.0 Production on Sat Mar 12 17:01:11 2016





Copyright (c) 1982, 2013, Oracle. All rights reserved.








Connected to:


Oracle Database 11g Enterprise Edition release 11.2.0.4.0-64bit Production


With the partitioning, real application clusters, Automatic Storage Management, OLAP,


Data Mining and real application testing options





Sql> alter system register;





System altered.





Sql>/





System altered.





Sql> exit


Disconnected from Oracle Database 11g Enterprise Edition release 11.2.0.4.0-64bit Production


With the partitioning, real application clusters, Automatic Storage Management, OLAP,


Data Mining and real application testing options


Xff2:/home/oracle> exit


Logout


[Root-www.111cn.net@xff2 ~]# Su-grid


xff2:/home/grid> lsnrctl Status Listener_scan1





Lsnrctl for linux:version 11.2.0.4.0-production on 12-mar-2016 17:01:24





Copyright (c) 1991, 2013, Oracle. All rights reserved.





Connecting to (description= address= (PROTOCOL=IPC) (Key=listener_scan1))


STATUS of the LISTENER


------------------------


Alias Listener_scan1


Version Tnslsnr for Linux:version 11.2.0.4.0-production


Start Date 12-mar-2016 16:59:05


Uptime 0 days 0 hr. 2 min. sec


Trace level off


Security On:local OS Authentication


SNMP off


Listener Parameter File/u01/oracle/app/grid/network/admin/listener.ora


Listener Log File/u01/oracle/app/grid/log/diag/tnslsnr/xff2/listener_scan1/alert/log.xml


Listening Endpoints Summary ...


(Description= (address= (PROTOCOL=IPC) (Key=listener_scan1))


(Description= (address= (protocol=tcp) (host=192.168.137.248) (port=1521))


The listener supports no services


The command completed successfully


It is found that after modifying scan IP, Scan listener does not have the right or the dynamic registration information to monitor, even if the alter system register is executed manually;

To solve the problem of dynamic listening registration after modifying scan IP by restarting the database


[Root-www.111cn.net@xff2 ~]# Su-oracle


Xff2:/home/oracle> srvctl Stop database-d xffdb


xff2:/home/oracle> srvctl start database-d xffdb


Xff2:/home/oracle> exit


Logout


[Root-www.111cn.net@xff2 ~]# Su-grid


xff2:/home/grid> lsnrctl Status Listener_scan1





Lsnrctl for linux:version 11.2.0.4.0-production on 12-mar-2016 17:06:17





Copyright (c) 1991, 2013, Oracle. All rights reserved.





Connecting to (description= address= (PROTOCOL=IPC) (Key=listener_scan1))


STATUS of the LISTENER


------------------------


Alias Listener_scan1


Version Tnslsnr for Linux:version 11.2.0.4.0-production


Start Date 12-mar-2016 16:59:05


Uptime 0 days 0 hr. 7 min. sec


Trace level off


Security On:local OS Authentication


SNMP off


Listener Parameter File/u01/oracle/app/grid/network/admin/listener.ora


Listener Log File/u01/oracle/app/grid/log/diag/tnslsnr/xff2/listener_scan1/alert/log.xml


Listening Endpoints Summary ...


(Description= (address= (PROTOCOL=IPC) (Key=listener_scan1))


(Description= (address= (protocol=tcp) (host=192.168.137.248) (port=1521))


Services Summary ...


Service "Xffdb" has 2 instance (s).


Instance "xffdb1", Status READY, has 1 handler (s) for the This service ...


Instance "Xffdb2", Status READY, has 1 handler (s) for the This service ...


Service "Xffdbxdb" has 2 instance (s).


Instance "xffdb1", Status READY, has 1 handler (s) for the This service ...


Instance "Xffdb2", Status READY, has 1 handler (s) for the This service ...


The command completed successfully

The original text from: http://www.xifenfei.com/2016/03/Modify 11-2-rac--scan-ip.html