Wednesday, 14 March 2012

Changing an IP address SCAN listener and VIP in Oracle 11G


This is a quick and dirty way to modify the SCAN listener, Public IP and Virtual IP for an Oracle 11G
database

This change was carried out on Linux OS but is applicable to most *nix
As Grid owner
 . oraenv
/oifcfg getif 
crsctl stat res -t
srvctl stop instance -d testdb -i testdb1
srvctl stop instance -d testdb -i testdb2

* If CRS is on ASM disks shutdown CRS first as root on both nodes -- crsctl stop crs

srvctl stop asm -n plrac2 -f
crsctl stat res -t
srvctl disable database -d testdb
srvctl disable nodeapps


Modify /etc/hosts
ifdown eth0
modify ip address: vi /etc/sysconfig/network-scripts/ifcfg-eth0
ifup eth0
confirm changes: ifconfig -a

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

SCAN Listener:

AS grid owner
$ ./srvctl stop scan_listener
$ ./srvctl stop scan
$ ./srvctl config scan

$ ./srvctl remove scan_listener -f

$ exit
exit
#./srvctl remove scan -f
#./srvctl add scan -n plrac_cluster
#./srvctl config scan

#su oracle
$ ./srvctl add scan_listener -p 1521
$ ./srvctl config scan

===============================================================================
As root
srvctl modify nodeapps -n plrac1 -A plrac1/255.255.255.0
srvctl modify nodeapps -n plrac2 -A plrac2/255.255.255.0
./srvctl config scan

verify the changes:
 srvctl config nodeapps -a
./srvctl config scan



as root:
srvctl enable nodeapps
srvctl enable database -d testdb



as grid owner:
srvctl start vip -n plrac1
srvctl start vip -n plrac2

srvctl start instance -d testdb -n plrac1
srvctl start instance -d testdb -n plrac2

No comments:

Post a Comment