Friday, April 14, 2017

Change the SCAN Name and SubNet

========================================================================

Change the SCAN Name and Subnet

========================================================================

As a root run the below:
---------------------------------------------------------
mydrdb5.ea.com[MYPD3A]$ srvctl config scan
SCAN name: mydrdb-scan, Network: 1/10.30.206.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /mydrdb-scan/10.30.206.52

mydrdb5.ea.com[MYPD3A]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1523
---------------------------------------------------------


mydrdb5.ea.com[MYPD3A]$ srvctl stop scan_listener

mydrdb5.ea.com[MYPD3A]$ srvctl stop scan

mydrdb5.ea.com[MYPD3A]$
mydrdb5.ea.com[MYPD3A]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running

mydrdb5.ea.com[MYPD3A]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is not running
----------------------------------------------------------
$GRID_HOME/bin/crsctl modify type ora.scan_vip.type -attr "ATTRIBUTE=SCAN_NAME,DEFAULT_VALUE=mytestdb-scan"
$GRID_HOME/bin/crsctl modify resource ora.net1.network -attr "USR_ORA_SUBNET=10.30.207.0"
$GRID_HOME/bin/crsctl modify resource ora.net1.network -attr "USR_ORA_NETMASK=255.255.255.0"
$GRID_HOME/bin/srvctl modify scan_listener -u
$GRID_HOME/bin/srvctl start scan_listener

Before running this Make sure all entry from /etc/hosts for scan is removed and it should be working from DNS.
----------------------------------------------------------
mydrdb5.ea.com[MYPD3A]$ cd $GRID_HOME
mydrdb5.ea.com[MYPD3A]$ pwd
/opt/oracle/grid/11.2.0

mydrdb5.ea.com[MYPD3A]$ $GRID_HOME/bin/crsctl modify type ora.scan_vip.type -attr "ATTRIBUTE=SCAN_NAME,DEFAULT_VALUE=mytestdb-scan"
mydrdb5.ea.com[MYPD3A]$ $GRID_HOME/bin/crsctl modify resource ora.net1.network -attr "USR_ORA_SUBNET=10.30.207.0"
mydrdb5.ea.com[MYPD3A]$ $GRID_HOME/bin/crsctl modify resource ora.net1.network -attr "USR_ORA_NETMASK=255.255.255.0"
mydrdb5.ea.com[MYPD3A]$
mydrdb5.ea.com[MYPD3A]$ $GRID_HOME/bin/srvctl modify scan -n mytestdb-scan


mydrdb5.ea.com[MYPD3A]$ srvctl config scan
SCAN name: mytestdb-scan, Network: 1/10.30.207.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /mytestdb-scan/10.30.207.157
SCAN VIP name: scan2, IP: /mytestdb-scan/10.30.207.158
SCAN VIP name: scan3, IP: /mytestdb-scan/10.30.207.156

mydrdb5.ea.com[MYPD3A]$ srvctl modify scan_listener -u

mydrdb5.ea.com[MYPD3A]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1523
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1523
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1523
mydrdb5.ea.com[MYPD3A]$

mydrdb5.ea.com[MYPD3A]$ srvctl start scan
mydrdb5.ea.com[MYPD3A]$ srvctl start scan_listener
mydrdb5.ea.com[MYPD3A]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node mydrdb6
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node mydrdb5
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node mydrdb5
mydrdb5.ea.com[MYPD3A]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node mydrdb6
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node mydrdb5
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node mydrdb5

========================================================================

But in case subnet is not different then:
========================================================================
$GRID_HOME/bin/srvctl modify scan -n mydrdb-scan
$GRID_HOME/bin/srvctl modify scan_listener -u

It will do the same as above but for only same subnet.

mydrdb5.ea.com[MYPD3A]$ $GRID_HOME/bin/srvctl modify scan -n mydrdb-scan

mydrdb5.ea.com[MYPD3A]$ srvctl config scan
SCAN name: mydrdb-scan, Network: 1/10.30.206.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /mydrdb-scan/10.30.206.157
SCAN VIP name: scan2, IP: /mydrdb-scan/10.30.206.158
SCAN VIP name: scan3, IP: /mydrdb-scan/10.30.206.156

mydrdb5.ea.com[MYPD3A]$ srvctl modify scan_listener -u

mydrdb5.ea.com[MYPD3A]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1523
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1523
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1523


========================================================================

No comments:

Post a Comment

Convert snapshot standby database to Physical standby database: Dataguard 11gR2

Step 1 SQL> shutdown immediate; Step 2 SQL> startup nomount Step 3 SQL> alter database mount; Step 4 SQL>  ALTER DATABASE CONV...