Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

How to Modifying SCAN Configuration in Oracle 11g Release 2 RAC

Rename SCAN

The original name was "ol6-112-scan" and I want to rename it to "ol6-112-scan2". Check the new name is configured in the DNS.
$ nslookup ol6-112-scan2
Server:  192.168.0.4
Address: 192.168.0.4#53

Name: ol6-112-scan2.localdomain
Address: 192.168.0.117
Name: ol6-112-scan2.localdomain
Address: 192.168.0.116
Name: ol6-112-scan2.localdomain
Address: 192.168.0.115

$
Display the current configuration using the following command as the oracle/grid user.
$ export GRID_HOME=/u01/app/11.2.0.3/grid
$ $GRID_HOME/bin/srvctl config scan 
SCAN name: ol6-112-scan, Network: 1/192.168.0.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /ol6-112-scan/192.168.0.115
SCAN VIP name: scan2, IP: /ol6-112-scan/192.168.0.116
SCAN VIP name: scan3, IP: /ol6-112-scan/192.168.0.117
$
Turn off the SCAN and SCAN listeners using the following commands as the oracle/grid user.
$ export GRID_HOME=/u01/app/11.2.0.3/grid
$ $GRID_HOME/bin/srvctl stop scan_listener 
$ $GRID_HOME/bin/srvctl stop scan
Modify the SCAN name using the following commands as the root user.
# export GRID_HOME=/u01/app/11.2.0.3/grid
# $GRID_HOME/bin/srvctl modify scan -n ol6-112-scan2   
# $GRID_HOME/bin/crsctl modify type ora.scan_vip.type -attr "ATTRIBUTE=SCAN_NAME,DEFAULT_VALUE=ol6-112-scan2"
Turn on the SCAN and SCAN listeners again using the following commands as the oracle/grid user.
$ $GRID_HOME/bin/srvctl modify scan_listener -u 
$ $GRID_HOME/bin/srvctl start scan_listener
Display the changed configuration.
$ $GRID_HOME/bin/srvctl config scan 
SCAN name: ol6-112-scan2, Network: 1/192.168.0.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /ol6-112-scan2/192.168.0.115
SCAN VIP name: scan2, IP: /ol6-112-scan2/192.168.0.116
SCAN VIP name: scan3, IP: /ol6-112-scan2/192.168.0.117
$


Remember to edit any service definitions that related to the deleted node.

Comments

Popular posts from this blog

Oracle DBMS SCHEDULER Examples

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

How to Enable/Disable autovacuum on PostgreSQL