INTRODUCTION
What is scan name for Oracle database?
Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments that provides a single name for clients to access any Oracle Database running in a cluster. SCAN is an automatic load balancing tool that uses a relatively primitive least-recently-loaded algorithm.
Original Name -> TST1-SCAN New name -> PROD1-SCAN
Step 1 : Display the current configuration as the oracle/grid user
$ export GRID_HOME=/u01/app/12.2/grid
$GRID_HOME/bin/srvctl config scan
SCAN name: TST1-SCAN, Network: 1
Subnet IPv4: 192.168.17.0/255.255.255.0/enp192, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 192.168.17.207
SCAN VIP is enabled.
SCAN 2 IPv4 VIP: 192.168.17.208
SCAN VIP is enabled.
SCAN 3 IPv4 VIP: 192.168.17.209
SCAN VIP is enabled.
Step 2 : Turn off the SCAN and SCAN listeners as GRID USER
$ export GRID_HOME=/u01/app/12.2/grid $GRID_HOME/bin/srvctl stop scan_listener $GRID_HOME/bin/srvctl stop scan
Step 3 : Modify the scan-name as root user
$ export GRID_HOME=/u01/app/12.2/grid $ $GRID_HOME/bin/srvctl modify scan -n PROD1-SCAN
Step 4 : Turn on the SCAN and SCAN listeners as GRID USER
$ export GRID_HOME=/u01/app/12.2/grid $GRID_HOME/bin/srvctl start scan_listener $GRID_HOME/bin/srvctl start scan
Step 5 : Check whether new scan name is getting reflected as grid user
$ export GRID_HOME=/u01/app/12.2/grid $GRID_HOME/bin/srvctl config scan SCAN name: PROD1-SCAN, Network: 1 Subnet IPv4: 192.168.17.0/255.255.255.0/enp192, static Subnet IPv6: SCAN 1 IPv4 VIP: 192.168.17.207 SCAN VIP is enabled. SCAN 2 IPv4 VIP: 192.168.17.208 SCAN VIP is enabled. SCAN 3 IPv4 VIP: 192.168.17.209 SCAN VIP is enabled.
Recommended Posts