DBA Hub

📋Steps in this guide1/6

Steps for modifying the scan name in oracle RAC.

In this article, we have explained steps to modify scan name in oracle RAC, srvctl config scan_listener , srvctl config

oracle clusteringintermediate
by OracleDba
22 views
1

Overview

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 . existing scan_name -> mumprd-scan new scan_name -> delprd-scan 1. Check the scan configuration [ as grid user ]
2

Section 2

2. Stop scan and scan_listener resource [ as grid user ] 3.Modify the scan-name: [ as root user ]

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
[oracle@DBATST01 bin]# <span style="color: #800000;"><strong>srvctl config scan</strong></span>
SCAN name: <em><strong>mumprd-scan</strong></em>, 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.

[grid@DBATST01 bin]$ <span style="color: #800000;"><strong>srvctl stop scan</strong></span>


[grid@DBATST01 bin]$ <span style="color: #800000;"><strong>srvctl stop scan_listener

</strong></span>
3

Section 3

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

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
[root@DBATST01 ]#cd /gridapp/app/oracle/product/grid19c

[root@DBATST01 bin]# <span style="color: #800000;"><strong>./srvctl modify scan -n delprd-scan</strong></span>


[root@DBATST01 bin]#  <span style="color: #800000;"><strong>./srvctl modify scan_listener -u

</strong></span>

srvctl modify scan_listener -p 1523

srvctl modify scan_listener -p 1523
4

Section 4

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

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
[oracle@DBATST01 bin]# <span style="color: #800000;"><strong>srvctl config scan</strong></span>
SCAN name: <em><strong>delprd-scan</strong></em>, 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

Section 5

6. cross check scan and scan_listener config : [ as grid user ] Now we need to update the parameter in pfile/spfile of the databases . 6. Update remote_listener and restart the database.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
[oracle@DBATST01 bin]# srvctl start scan_listener
[oracle@DBATST01 bin]# srvctl start scan

[oracle@DBATST01 bin]# <span style="color: #800000;"><strong>./srvctl config scan_listener</strong></span>
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]#<span style="color: #800000;"><strong> ./srvctl config scan</strong></span>
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.
6

Section 6

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
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

Comments (0)

Please to add comments

No comments yet. Be the first to comment!