Oracle 11g modify RAC SCAN IP

Oracle 11g modifies the rac scan ip address in 11gR2 and introduces the SCAN (Single Client Access Name) feature. The advantage of this feature is that between the database and the Client, A virtual service layer is added, that is, the scan ip address and scan ip listener. on the client side, you only need to configure the tns information of the scan ip address and connect to the backend cluster database through the scan ip listener. In this way, no matter whether or not the cluster database has added or deleted nodes, it will not affect the client. When a client application accesses the database using the SCAN ip address, the scan listener forwards the connection to the local listener.

RAC = (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = SCAN) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = RAC ))) client shocould connect to the SCAN name-> scan listener, scan listener will redirect the connection (sometimes beneath) to the node VIP, and all succeeding procedures are same with the previous versions. www.2cto.com
The ip information related to the SCAN ip address is initialized when the SCAN resource is created. Without GNS: any changes to SCAN in DNS and/etc/hosts will not be automatically synchronized to Clusterware, but will be manually updated. The following describes how to modify the scan ip Address:
Lab environment: Version: Clusterware: 11.2.0.2database: 11.2.0.1 old scan ip10.250.7.210 new scan ip10.250.7.14110.250.7.14210.250.7.143
1. view the status information of the scan ip Address:
Grid @ rac1:/home/grid> srvctl config scanSCAN name: scan, network: 1/10. 250.7.0/255.255.255.0/eth0SCAN VIP name: scan1, IP:/scan/10.250.7.210grid @ rac1:/home/grid> 2 stop scan_listener, scan application grid @ rac1: /home/grid> srvctl stop scan_listenergrid @ rac1:/home/grid> srvctl stop scan
3 confirm scan_listener, scan status grid @ rac1:/home/grid> srvctl status scan_listenerSCAN listener LISTENER_SCAN1 enabled SCAN listener LISTENER_SCAN1 not running grid @ rac1: /home/grid> srvctl status scanSCAN VIP scan1 enabled www.2cto.com scan vip scan1 not running grid @ rac1:/home/grid> crs_stat-t | grep scan ora. scan1.vip ora .... ip. type OFFLINE grid @ rac1:/home/grid> grid @ rac1:/home/grid> grid @ rac1:/home/grid> crs_stat-t | grep lsnrora .... ER. lsnr ora .... er. type ONLINE rac1 ora .... n1.lsnr ora .... er. type OFFLINE ora .... c1.lsnr application ONLINE rac1 ora .... c2.lsnr application ONLINE rac2
4. modify the scan ip address 10.250.7.141 scan10.250.7.142 scan10.250.7.143 scangrid @ rac1:/home/grid> srvctl modify scan-h on all nodes to modify the SCAN name. Usage: srvctl modify scan-n <scan_name> domain name-defined SCAN name-h output usage grid users do not have permission to change the scan ip address, and must use the root permission grid @ rac1: /home/grid> srvctl modify scan-n scan PRCS-1034: Unable to modify single client access name scanPRCR-1071: unable to register or update resource type ora. scan_vip.typeCRS-0245: User does not have enough privilege to perform. the operation [root @ rac1 ~] #/Opt/11202/11 .2.0/grid/bin/srvctl modify scan-n scan
5. Confirm the change: www.2cto.com [root @ rac1 ~] #/Opt/11202/11 .2.0/grid/bin/srvctl config scanSCAN name: scan, network: 1/10. 250.7.0/255.255.255.0/eth0SCAN VIP name: scan1, IP:/scan/10.250.7.141 <=== only one scan ip address resolves scan ip addresses for/etc/hosts files, because Server Load balancer cannot be used for training, only one ip address can be used for scanning. 6. Restart scan. scan_listenergrid @ rac1:/home/grid> srvctl start scangrid @ rac1:/home/grid> srvctl start scan_listener
7. Check the status of scan and scan_listener.ora: grid @ rac1:/home/grid> crs_stat-t | grep scanora. scan1.vip ora .... ip. type ONLINE rac2 grid @ rac1:/home/grid> crs_stat-t | grep lsnrora .... ER. lsnr ora .... er. type ONLINE rac1 ora .... n1.lsnr ora .... er. type ONLINE rac2 ora .... c1.lsnr application ONLINE rac1 ora .... c2.lsnr application ONLINE rac2 ping test www.2cto.com grid @ rac1:/home/grid> pi Ng 10.250.7.141PING 10.250.7.141 (10.250.7.141) 56 (84) bytes of data.64 bytes from 10.250.7.141: icmp_seq = 1 ttl = 64 time = 1.52 ms64 bytes from 10.250.7.141: icmp_seq = 2 ttl = 64 time = 0.226 ms --- 10.250.7.141 ping statistics --- 2 packets transmitted, 2 received, 0% packet loss, time 1000 msrtt min/avg/max/mdev = 0.226/0.873/1.520/0.647 msgrid @ rac1:/home/grid> ping 10.250.7.142PING 10.250.7.142 (10.250.7.1 42) 56 (84) bytes of data. Unlike modifying the private ip address and vip address, modifying the scan ip address does not need to stop the database instance, asm or restarting the crs, which is relatively simple! Author: newhappy2008