ELIMINAR NODO ORACLE RAC
Primero, se debe eliminar el nodo defectuoso del clúster, esto se realiza quitando el software RDBMS del inventario del nodo bueno.
[oracle@host01]$ cd /u01/app/product/12.2.0/grid/oui/bin
[oracle@host01]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={host01}" LOCAL_NODE=host01
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 10239 MB Passed
The inventory pointer is located at /etc/oraInst.loc
'UpdateNodeList' was successful.
[grid@host01]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={host01}" CRS=TRUE -silent
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 10239 MB Passed
The inventory pointer is located at /etc/oraInst.loc
'UpdateNodeList' was successful.
cd /u01/app/product/12.2.0/grid
[root@host01]$ crsctl delete node -n host02
CRS-4661: Node host02 successfully deleted.
[root@host01]$ srvctl config vip -node host02
[root@host01]$ ./srvctl stop vip -vip host02-vip.domain.local -force
[root@host01]$ ./srvctl remove vip -vip host02-vip.domain.local
Please confirm that you intend to remove the VIPs host02-vip.domain.local (y/[n]) y
[root@host01]$ ./srvctl remove instance -db base_de_datos -instance instancia_2
Remove instance from the database base_de_datos? (y/[n]) y
[oracle@host02]$ rm -rf /u01/app/oracle/product/12.1.0.2/
[root@host02 ~]# rm -rf /u01/grid/crs12.1.0.2/*
[root@host02 ~]# rm /var/tmp/.oracle/*
[oracle@host02]$ /tmp]$ rm -rf /tmp/*
[root@host02]# rm /etc/oracle/ocr*
[root@host02]# rm /etc/oracle/olr*
[root@host02]# rm -rf /pkg/oracle/app/oraInventory
[root@host02]# rm -rf /etc/oracle/scls_scr
AÑADIR NUEVO NODO ORACLE RAC
[grid@host01]$ cd $ORACLE_HOME/addnode
[grid@host01]$ nohup ./addnode.sh -ignoreSysPrereqs -ignorePrereq -skipPrereqs -silent "CLUSTER_NEW_NODES={host02}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={host02-vip.domain.local}" "CLUSTER_NEW_NODE_ROLES={HUB}" &
[root@host02]# cd $ORACLE_HOME/crs/install
[root@host02]# ./rootcrs.sh -verbose -deconfig -force
Using configuration parameter file: /u01/app/product/12.2.0/grid/crs/install/crsconfig_params
2018-08-15 07:12:03: mkpath (/u01/app/grid/crsdata/host02/crsconfig)
2018-08-15 07:12:03: Setting owner (grid:54322) and group (oinstall:54321) on file /u01/app/grid/crsdata/host02/crsconfig
2018-08-15 07:12:03: Setting permissions (0775) on file/dir /u01/app/grid/crsdata/host02/crsconfig
The log of current session can be found at:
/u01/app/grid/crsdata/host02/crsconfig/crsdeconfig_host02_2018-08-15_07-12-03AM.log
2018/08/15 07:12:16 CLSRSC-46: Error: '/u01/app/grid/crsdata/host02/crsconfig/srvmcfg1.log' does not exist
2018/08/15 07:12:16 CLSRSC-46: Error: '/u01/app/grid/crsdata/host02/crsconfig/srvmcfg1.log' does not exist
****Unable to retrieve Oracle Clusterware home.
Start Oracle Clusterware stack and try again.
2018/08/15 07:12:16 CLSRSC-180: An error occurred while executing the command '/u01/app/product/12.2.0/grid/bin/srvctl config nodeapps'
CRS-4047: No Oracle Clusterware components configured.
CRS-4000: Command Stop failed, or completed with errors.
2018/08/15 07:12:26 CLSRSC-463: The deconfiguration or downgrade script could not stop current Oracle Clusterware stack.
2018/08/15 07:15:21 CLSRSC-557: Oracle Clusterware stack on this node has been successfully deconfigured. There were some errors which can be ignored.
[root@host02]# cd $ORACLE_HOME/
[root@host02]# ./root.sh
Check /u01/app/product/12.2.0/grid/install/root_instancia_2_2018-08-15_07-16-39-608890060.log for the output of root script
[grid@host02]# crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE host02 STABLE
ONLINE ONLINE host01 STABLE
ora.DATA.dg
ONLINE ONLINE host02 STABLE
ONLINE ONLINE host01 STABLE
ora.FRA.dg
ONLINE ONLINE host02 STABLE
ONLINE ONLINE host01 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE host02 STABLE
ONLINE ONLINE host01 STABLE
ora.REDO01.dg
ONLINE ONLINE host02 STABLE
ONLINE ONLINE host01 STABLE
ora.REDO02.dg
ONLINE ONLINE host02 STABLE
ONLINE ONLINE host01 STABLE
ora.chad
ONLINE ONLINE host02 STABLE
ONLINE ONLINE host01 STABLE
ora.net1.network
ONLINE ONLINE host02 STABLE
ONLINE ONLINE host01 STABLE
ora.ons
ONLINE ONLINE host02 STABLE
ONLINE ONLINE host01 STABLE
ora.proxy_advm
OFFLINE OFFLINE host02 STABLE
OFFLINE OFFLINE host01 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE host02 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE host01 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE host01 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE host01 169.254.93.39 172.20
.17.131,STABLE
ora.asm
1 ONLINE ONLINE host02 Started,STABLE
2 ONLINE ONLINE host01 Started,STABLE
3 ONLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE host01 STABLE
ora.base_de_datos.db
2 ONLINE ONLINE host01 Open,HOME=/u01/app/o
racle/product/12.2.0
/db1,STABLE
ora.mgmtdb
1 ONLINE ONLINE host01 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE host01 STABLE
ora.scan1.vip
1 ONLINE ONLINE host02 STABLE
ora.scan2.vip
1 ONLINE ONLINE host01 STABLE
ora.scan3.vip
1 ONLINE ONLINE host01 STABLE
ora.host02.vip
1 ONLINE ONLINE host02 STABLE
ora.host01.vip
srvctl modify database -db base_de_datos -oraclehome "ruta_oracle_home"
srvctl config database -db base_de_datos
[oracle@host01]$ cd $ORACLE_HOME
[oracle@host01]$ srvctl add instance -db base_de_datos -instance instancia_2 -node host02
[oracle@host01]$ srvctl start instance -db inttegrio -instance inttegrio1
[oracle@host01]$ srvctl status database -d inttegrio
Instance instancia_2 is running on node host02
Instance instancia_1 is running on node host01
SQL> select inst_id,status from gv$instance;
INST_ID STATUS
---------- ------------
2 OPEN
1 OPEN
Excelente!
ResponderEliminar