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