0) Realizar un backup (Más vale prevenir que llorar) |
|
|
|
|
|
|
|
|
|
|
Realizar un
mksysb de cada una de las LPARS's |
|
|
|
Realizar un
backup full de la base de datos Oracle |
|
|
|
|
|
|
|
|
|
|
1)
Desactivación del HAS y CRS en el rebote de los servidores AIX |
|
|
|
Desactivamos
el arranque automatico de CRS y HAS en BDRAC0 y BDRAC1 |
|
|
|
|
|
|
|
|
|
|
su - root |
|
|
|
|
|
|
cd
/u01/app/11.2.0/grid/bin |
|
|
|
|
|
./crsctl
disable has |
|
|
|
|
|
./crsctl
disable crs |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2)
Paramos los servicios asociados a la base de datos a excepción de los
servicios asociados a la pila del CRS |
|
|
|
|
|
|
|
The
database and nodeapps (on all nodes) are stopped. |
|
|
|
|
|
|
|
|
|
|
su - oracle |
|
|
|
|
|
|
srvctl
stop database -d BDRAC |
|
|
|
|
srvctl
stop nodeapps -n bdrac0 |
|
|
|
|
srvctl
stop nodeapps -n bdrac1 |
|
|
|
|
|
|
|
|
|
|
|
3)
Cambiamos la IP publica en el OCR (La Subnet Id asociada a la IP Publica) |
|
|
Previamente
realizamos un backup del ocr |
|
|
|
|
su - root |
|
|
|
|
|
|
cd
/u01/app/11.2.0/grid/bin |
|
|
|
|
|
|
|
|
|
|
|
El
backup lo realizamos en los 2 servidores AIX por precaución. |
|
|
|
|
|
|
|
|
|
|
./ocrconfig
-showbackup |
|
|
|
|
|
./ocrconfig
-export /u01/backup/data/backup_20131013.ocr |
|
|
|
|
|
|
|
|
|
|
Obtenemos
información de la configuracion |
|
|
|
|
su - root |
|
|
|
|
|
|
cd
/u01/app/11.2.0/grid/bin |
|
|
|
|
oifcfg
getif |
|
|
|
|
|
./srvctl
config network |
|
|
|
|
|
./srvctl
config nodeapps -a |
|
|
|
|
|
|
|
|
|
|
|
|
Procedemos
a realizar el cambio (Primero eliminamos
la antigua y luego la añadimos la nueva) |
|
|
|
|
|
|
|
|
|
oifcfg delif
-global en0/10.200.0.0 |
|
|
|
|
oifcfg setif
-global en0/10.200.20.0:public |
|
|
|
|
|
|
|
|
|
|
|
Para
cambiar la SubnetId |
|
|
|
|
|
|
|
|
|
|
|
|
su - root |
|
|
|
|
|
|
srvctl
modify network -S 10.200.20.0/255.255.252.0/en0 |
|
|
|
|
|
|
|
|
|
|
Modificar
el listener del ASM de bdrac0 (Conexión del ASM) |
|
|
|
vi
/u01/app/11.2.0/grid/network/admin/endpoints_listener.ora | Por 10.200.20.40 |
|
|
Modificar
el listener del ASM de bdrac1 (Conexión del ASM) |
|
|
|
vi
/u01/app/11.2.0/grid/network/admin/endpoints_listener.ora |
Por 10.200.20.50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4)
Modify the VIP address BDRAC0 |
|
|
|
|
|
|
|
|
|
|
srvctl stop
instance -d BDRAC -n bdrac0 |
|
|
|
|
srvctl stop
vip -n bdrac0 -f |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
su - root |
|
|
|
|
|
|
cd
/u01/app/11.2.0/grid/bin |
|
|
|
|
|
srvctl
modify nodeapps -n bdrac0 -A bdrac0-vip/255.255.252.0/en0 |
|
|
|
./crsctl
stat res ora.bdrac0.vip -p |
|
|
|
|
./srvctl
config nodeapps -n bdrac0 |
|
|
|
|
|
|
|
|
|
|
|
srvctl start
vip -n bdrac0 |
|
|
|
|
|
srvctl start
instance -d BDRAC -n bdrac0 |
|
|
|
|
|
|
|
|
|
|
|
5)
Modify the VIP address BDRAC1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
srvctl stop
instance -d BDRAC -n bdrac1 |
|
|
|
|
srvctl stop
vip -n bdrac1 -f |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
su - root |
|
|
|
|
|
|
cd
/u01/app/11.2.0/grid/bin |
|
|
|
|
|
srvctl
modify nodeapps -n bdrac1 -A bdrac1-vip/255.255.252.0/en0 |
|
|
|
./crsctl
stat res ora.bdrac1.vip -p |
|
|
|
|
./srvctl
config nodeapps -n bdrac1 |
|
|
|
|
|
|
|
|
|
|
|
srvctl start
vip -n bdrac1 |
|
|
|
|
|
srvctl start
instance -d BDRAC -n bdrac1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
6)
Modificamos el parametro local_listener a nivel de spfile |
|
|
|
|
|
|
|
|
|
|
Modificar
el Local Listener a nivel de Oracle |
|
|
|
|
su - oracle |
|
|
|
|
|
|
sqlplus
"/ as sysdba" |
|
|
|
|
|
alter system
set
local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.200.20.41)(PORT=1521))))'
sid='BDRAC1' scope=BOTH; |
alter system
set
local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.200.20.51)(PORT=1521))))'
sid='BDRAC2' scope=BOTH; |
alter system
register; |
|
|
|
|
|
|
|
|
|
|
|
|
7)
Actualización en el DNS de los registros asociados a la IP'S del cambio |
|
|
|
|
|
|
|
|
|
Actualizar
en el DNS los registros asociados a las IP's Publicas de ambos nodos - Las
IP's VIP de ambos nodos - Las IP's de SCAN |
|
|
|
|
|
|
|
|
8)
Modicamos las IP's de SCAN a nivel de Oracle |
|
|
|
|
|
|
|
|
|
|
su - root |
|
|
|
|
|
|
cd
/u01/app/11.2.0/grid/bin |
|
|
|
|
|
|
|
|
|
|
|
|
Verificar
con que 3 ip's resuelve el registro de DNS del SCAN |
|
|
|
nslookup
bdrac-cl-scan.lacafetera.com |
|
|
|
|
|
|
|
|
|
|
|
./srvctl
config scan |
|
|
|
|
|
|
|
|
|
|
|
|
Paramos
el SCAN Listener y el SCAN |
|
|
|
|
|
|
|
|
|
|
|
./srvctl
stop scan_listener |
|
|
|
|
|
./srvctl
stop scan |
|
|
|
|
|
./srvctl
status scan |
|
|
|
|
|
./srvctl
status scan_listener |
|
|
|
|
|
|
|
|
|
|
|
|
Actualizamos
el SCAN |
|
|
|
|
|
|
|
|
|
|
|
|
./srvctl
modify scan -n bdrac-cl-scan.lacafetera.com |
|
|
|
./srvctl
config scan |
|
|
|
|
|
./srvctl
start scan |
|
|
|
|
|
./srvctl
start scan_listener |
|
|
|
|
|
./srvctl
modify scan_listener -u |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9)
Paramos el CRS en BDRAC0 |
|
|
|
|
|
|
|
|
|
|
|
su - root |
|
|
|
|
|
|
cd
/u01/app/11.2.0/grid/bin |
|
|
|
|
|
./crsctl
stop crs |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10)
Paramos el CRS en BDRAC1 |
|
|
|
|
|
|
|
|
|
|
|
su - root |
|
|
|
|
|
|
cd
/u01/app/11.2.0/grid/bin |
|
|
|
|
|
./crsctl
stop crs |
|
|
|
|
|
|
|
|
|
|
|
|
11)
Realizamos el cambio de forma estatica de las IP's en las LPAR's |
|
|
|
|
|
|
|
|
|
|
Actualizar
el fichero en el /etc/hosts la IP Publica
bdrac0 (En ambos servidores aix
) |
|
|
|
Actualizar
el fichero en el /etc/hosts la IP
VIP bdrac0-vip (En ambos servidores
aix) |
|
|
|
Actualizar
el fichero en el /etc/hosts la IP Publica
bdrac1 (En ambos servidores aix
) |
|
|
|
Actualizar
el fichero en el /etc/hosts la IP
VIP bdrac1-vip (En ambos servidores
aix) |
|
|
|
Hacer el
cambio de IP Publica a nivel de Sistema Operativo en el nodo bdrac0 | smitty mktcpip (Con el asistente) |
|
Hacer el
cambio de IP Publica a nivel de Sistema Operativo en el nodo bdrac1 |
smitty mktcpip (Con el asistente) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Si
lo queremos realizar con linea de comando la LPAR |
|
|
|
|
|
|
|
|
|
|
mktcpip
-h'bdrac0' -a'10.200.20.40' -m'255.255.252.0' -i'en0' -g'10.200.20.5' |
|
|
mktcpip
-h'bdrac1' -a'10.200.20.50' -m'255.255.252.0' -i'en0' -g'10.200.20.5' |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12)
Restart de las 2 LPAR's BDRAC0 y BDRAC1 |
|
|
|
|
|
|
|
|
|
|
Activamos el
arranque automatico de CRS y HAS en BDRAC0 y BDRAC1 |
|
|
|
|
|
|
|
|
|
|
su - root |
|
|
|
|
|
|
cd
/u01/app/11.2.0/grid/bin |
|
|
|
|
|
./crsctl
enable has |
|
|
|
|
|
./crsctl
enable crs |
|
|
|
|
|
|
|
|
|
|
|
|
Rebotamos
bdrac0 y bdrac1 Shutdown -Fr now |
|
|
|
|
|