怎样修改 SCAN信息（来自于metalink）

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Goal

The goal of this document is to provide steps to update 11gR2 (11.2) Grid Infrastructure (CRS) Single Client Access Name (SCAN) setting if its not setup properly or if its got changed after setup.

The document doesn't apply when GNS is being used.

Solution

As per documentation "Oracle” Grid Infrastructure Installation Guide", Oracle strongly recommend to configure SCAN name in either DNS or GNS as /etc/hosts file can only resolve to one IP address.

1a. If you intend to use /etc/hosts for SCAN name resolution, please make sure the same single entry for SCAN name in /etc/hosts on all nodes.

1b. If you intend to use DNS for SCAN name resolution, please remove entries for SCAN name in /etc/hosts on all nodes, and make sure nslookup returns good result on all nodes, for example:

$ nslookup pay-scan.us.oracle.com
..

Name:   pay-scan.us.oracle.com
Address: 10.4.0.201
Name:   pay-scan.us.oracle.com
Address: 10.4.0.202
Name:   pay-scan.us.oracle.com
Address: 10.4.0.203

2. Once #1a or #1b is confirmed, as grid home owner (not root) please execute following to modify:

 

$ GRID_HOME=Directory_of_Your_GRID_Install
$ export GRID_HOME
$ $GRID_HOME/bin/srvctl stop scan_listener
$ $GRID_HOME/bin/srvctl stop scan

## as root execute next command
# $GRID_HOME/bin/srvctl modify scan -n pay-scan.us.oracle.com   

## If you intend to change SCAN name, for 11.2.0.1 as root execute next command; otherwise skip it
## if you modified SCAN name, make sure to update database init.ora parameter remote_listener as well.

# $GRID_HOME/bin/crsctl modify type ora.scan_vip.type -attr "ATTRIBUTE=SCAN_NAME,DEFAULT_VALUE=pay-scan.us.oracle.com"

$ $GRID_HOME/bin/srvctl modify scan_listener -u
$ $GRID_HOME/bin/srvctl start scan_listener

3. To confirm the change:

$ $GRID_HOME/bin/srvctl config scan
SCAN name: pay-scan.us.oracle.com, Network: 1/10.4.0.0/255.255.255.0/eth1
SCAN VIP name: scan1, IP: /10.4.0.201/120.0.0.201
SCAN VIP name: scan2, IP: /10.4.0.202/120.0.0.202
SCAN VIP name: scan3, IP: /10.4.0.203/120.0.0.203

$ $GRID_HOME/bin/srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521