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

Start typing and press Enter to search