Recently We have built a 2 node RAC.  However after setting up everything, came to know that , we have configured wrong scan-name during the installation .  So we have used below method to update the scan name .

Steps for modifying the scan name in oracle RAC.

existing scan_name -> mumprd-scan

new scan_name      -> delprd-scan

1. Check the scan configuration [ as grid user ]



[oracle@DBATST01 bin]# srvctl config scan
SCAN name: mumprd-scan, Network: 1
Subnet IPv4: 192.20.209.0/255.255.255.0/cns192, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 192.20.209.165
SCAN VIP is enabled.
SCAN 2 IPv4 VIP: 192.20.209.164
SCAN VIP is enabled.
SCAN 3 IPv4 VIP: 192.20.209.163
SCAN VIP is enabled.


2. Stop scan and scan_listener resource [ as grid user ]



[grid@DBATST01 bin]$ srvctl stop scan


[grid@DBATST01 bin]$ srvctl stop scan_listener

3.Modify the scan-name: [ as root user ]


[root@DBATST01 ]#cd /gridapp/app/oracle/product/grid19c

[root@DBATST01 bin]# ./srvctl modify scan -n delprd-scan


[root@DBATST01 bin]#  ./srvctl modify scan_listener -u

Note – For updating scan port run below command: ( 1523 is the new port)

srvctl modify scan_listener -p 1523


4. Check whether new scan name is getting reflected or not: [ as grid user ]



[oracle@DBATST01 bin]# srvctl config scan
SCAN name: delprd-scan, Network: 1
Subnet IPv4: 192.20.209.0/255.255.255.0/cns192, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 192.20.209.171
SCAN VIP is enabled.
SCAN 2 IPv4 VIP: 192.20.209.172
SCAN VIP is enabled.
SCAN 3 IPv4 VIP: 192.20.209.170
SCAN VIP is enabled.

5. Start scan listener: [ as grid user ]



[oracle@DBATST01 bin]# srvctl start scan_listener
[oracle@DBATST01 bin]# srvctl start scan

6. cross check scan and scan_listener config : [ as grid user ]



[oracle@DBATST01 bin]# ./srvctl config scan_listener
SCAN Listeners for network 1:
Registration invited nodes: DBATST01,DBATST02
Registration invited subnets:
Endpoints: TCP:1522
SCAN Listener LISTENER_SCAN1 exists
SCAN Listener is enabled.
SCAN Listener LISTENER_SCAN2 exists
SCAN Listener is enabled.
SCAN Listener LISTENER_SCAN3 exists
SCAN Listener is enabled.


[oracle@DBATST01 bin]# ./srvctl config scan
SCAN name: delprd-scan, Network: 1
Subnet IPv4: 192.20.209.0/255.255.255.0/cns192, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 192.20.209.171
SCAN VIP is enabled.
SCAN 2 IPv4 VIP: 192.20.209.172
SCAN VIP is enabled.
SCAN 3 IPv4 VIP: 192.20.209.170
SCAN VIP is enabled.

Now we need to update the remote_listener parameter in pfile/spfile of the databases .

6. Update remote_listener and restart the database.



SQL> show parameter remote_listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_listener                      string       mumprd-scan:1522


alter system set remote_listener='delprd-scan:1522 ' scope=spfile sid='*';

srvctl stop database -d delprd
srvctl start database -d delprd