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