{"id":2232,"date":"2021-04-03T16:45:57","date_gmt":"2021-04-03T14:45:57","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=2232"},"modified":"2021-04-16T19:31:24","modified_gmt":"2021-04-16T17:31:24","slug":"eliminar-un-nodo-del-rac","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/eliminar-un-nodo-del-rac\/","title":{"rendered":"Eliminar un nodo del rac"},"content":{"rendered":"<p>Hoy vamos a ver la manera de eliminar de manera limpia un nodo de un RAC .<br \/>\nSupondremos que queremos eliminar de  nuestro cluster el nododo que llamamos rac1, los pasos a llevar a cabo seran:<\/p>\n<h1>Eliminar del nodo las bases de datos corriendo <\/h1>\n<p>Supongamos que tenemos la BBDD<\/p>\n<pre>\r\nORACLE_BASE=\/u01\/app\/oracle\r\nORACLE_HOME=\/u01\/app\/oracle\/product\/12.1.0.2\/db\r\nORACLE_SID=TEST1\r\nDB_NAME=TEST\r\nINSTANCE_NAME=TEST1\r\nNODE_NAME=rac1\r\n<\/pre>\n<p>Para cada una de las bases de datos , la parariamos con : <\/p>\n<pre>\r\n srvctl stop instance  -db $DB_NAME -i $INSTANCE_NAME\r\n<\/pre>\n<p>Y posteriormente la eliminariamos con: <\/p>\n<p>rac1.pamplona.name:oracle (TEST:\/u01\/app\/19c\/grid) srvctl config database -db $DB_NAME<br \/>\nDatabase unique name: TEST<br \/>\nDatabase name:<br \/>\nOracle home: \/u01\/app\/oracle\/product\/12.1.0.2\/db<br \/>\nOracle user: oracle<br \/>\nSpfile: +DATA\/TEST\/PARAMETERFILE\/spfile.357.935866381<br \/>\nPassword file:<br \/>\nDomain:<br \/>\nStart options: open<br \/>\nStop options: immediate<br \/>\nDatabase role: PRIMARY<br \/>\nManagement policy: AUTOMATIC<br \/>\nServer pools:<br \/>\nDisk Groups: +DATA,+REDO,+FRA<br \/>\nMount point paths:<br \/>\nServices:<br \/>\nType: RAC<br \/>\nStart concurrency:<br \/>\nStop concurrency:<br \/>\nOSDBA group: dba<br \/>\nOSOPER group: osoper<br \/>\nDatabase instances: TEST1,TEST2<br \/>\nConfigured nodes: rac1,rac2<br \/>\nDatabase is administrator managed<\/p>\n<p>dbca -silent -deleteInstance -nodeList rac1 -gdbName  $DB_NAME  -instanceName  $INSTANCE_NAME -sysDBAUserName sys -sysDBAPassword syspass<\/p>\n<p>Tras esto comprobariamos que no quedan bases de datos en este nodo con <i> crsctl stat rs -t <\/I><\/p>\n<h1> Eliminams los recursos del cluster de ese  nodo  <\/h1>\n<p>Una vez hemos eliminado las bases de datos, eliminaremos los recursos del cluster.<br \/>\nEl primer paso es mover la mgtdb y para el proxy <\/p>\n<pre>\r\nsrvctl relocate mgmtdb -n rac2\r\nsrvctl stop asm -proxy -n wiractst01\r\n<\/pre>\n<p>Eliminamos el listener<\/p>\n<pre>\r\nsrvctl disable listener -l LISTENER -n rac1\r\nsrvctl stop listener -l LISTENER -n rac1\r\n<\/pre>\n<h1> Desinstalando los binarios del CRS <\/h1>\n<p>Con el entorno cargado el ASM procederemos a desinstalar los binarios del RAC , para este proposito usaremos el comando <i> deinstall<\/i> del $ORACLE_HOME deel nodo, este comando se encargara de hacernos una desinstalacion limpia borrandonos:<\/p>\n<ul>\n<li>Configuraciones\n<li> Binarios\n<li> Interfaces de red virtuales\n<\/ul>\n<pre>\r\n$ORACLE_HOME\/deinstall\/deinstall -local\r\n\r\nrac1.pamplona.name:oracle (+ASM1:\/u01\/app\/19c\/grid\/deinstall) $ORACLE_HOME\/deinstall\/deinstall -local\r\nChecking for required files and bootstrapping ...\r\nPlease wait ...\r\nLocation of logs \/u01\/app\/oraInventory\/logs\/\r\n\r\n############ ORACLE DECONFIG TOOL START ############\r\n######################### DECONFIG CHECK OPERATION START #########################\r\n## [START] Install check configuration ##\r\nChecking for existence of the Oracle home location \/u01\/app\/19c\/grid\r\nOracle Home type selected for deinstall is: Oracle Grid Infrastructure for a Cluster\r\nOracle Base selected for deinstall is: \/u01\/app\/oracle\r\nChecking for existence of central inventory location \/u01\/app\/oraInventory\r\nChecking for existence of the Oracle Grid Infrastructure home \/u01\/app\/19c\/grid\r\nThe following nodes are part of this cluster: rac1,rac2\r\nChecking for sufficient temp space availability on node(s) : 'rac1'\r\n## [END] Install check configuration ##\r\n\r\nTraces log file: \/u01\/app\/oraInventory\/logs\/crsdc_2021-03-23_09-16-26-PM.log\r\nNetwork Configuration check config START\r\nNetwork de-configuration trace file location: \/u01\/app\/oraInventory\/logs\/netdc_check9_09-16-27PM.log\r\nNetwork Configuration check config END\r\nAsm Check Configuration START\r\nASM de-configuration trace file location: \/u01\/app\/oraInventory\/logs\/asmcadc_check2021-03-23_09-16-27PM.log\r\nDatabase Check Configuration START\r\nDatabase de-configuration trace file location: \/u01\/app\/oraInventory\/logs\/databasedc_check2021-03-23_09-16-27PM.log\r\nOracle Grid Management database was found in this Grid Infrastructure home\r\nDatabase Check Configuration END\r\n######################### DECONFIG CHECK OPERATION END #########################\r\n\r\n####################### DECONFIG CHECK OPERATION SUMMARY #######################\r\nOracle Grid Infrastructure Home is: \/u01\/app\/19c\/grid\r\nThe following nodes are part of this cluster: rac1,rac2\r\nThe cluster node(s) on which the Oracle home deinstallation will be performed are:rac1\r\nOracle Home selected for deinstall is: \/u01\/app\/19c\/grid\r\nInventory Location where the Oracle home registered is: \/u01\/app\/oraInventory\r\nOption -local will not modify any ASM configuration.\r\nOracle Grid Management database was found in this Grid Infrastructure home\r\nOracle Grid Management database will be relocated to another node during deconfiguration of local node\r\nDo you want to continue (y - yes, n - no)? [n]: y\r\nA log of this session will be written to: '\/u01\/app\/oraInventory\/logs\/deinstall_deconfig2021-03-23_09-16-21-PM.out'\r\nAny error messages from this session will be written to: '\/u01\/app\/oraInventory\/logs\/deinstall_deconfig2021-03-23_09-16-21-PM.err'\r\n\r\n######################## DECONFIG CLEAN OPERATION START ########################\r\nDatabase de-configuration trace file location: \/u01\/app\/oraInventory\/logs\/databasedc_clean2021-03-23_09-16-27PM.log\r\nASM de-configuration trace file location: \/u01\/app\/oraInventory\/logs\/asmcadc_clean2021-03-23_09-16-27PM.log\r\nASM Clean Configuration END\r\n\r\nNetwork Configuration clean config START\r\nNetwork de-configuration trace file location: \/u01\/app\/oraInventory\/logs\/netdc_clean2021-03-23_09-16-27PM.log\r\nNetwork Configuration clean config END\r\nRun the following command as the root user or the administrator on node \"wiractst01\".\r\n\/u01\/app\/19c\/grid\/crs\/install\/rootcrs.sh -force  -deconfig -paramfile \"\/tmp\/deinstall2021-03-23_09-15-25PM\/response\/deinstall_OraGI19Home1.rsp\"\r\nPress Enter after you finish running the above commands\r\n<----------------------------------------\r\n<\/pre>\n<p>Ejecutamos el comando como root<\/p>\n<pre>\r\n[oracle@rac1~]$ sudo \/u01\/app\/19c\/grid\/crs\/install\/rootcrs.sh -force  -deconfig -paramfile \"\/tmp\/deinstall2021-03-23-15-25PM\/response\/deinstall_OraGI19Home1.rsp\"\r\nUsing configuration parameter file: \/tmp\/deinstall2021-03-23_09-15-25PM\/response\/deinstall_OraGI19Home1.rsp\r\nThe log of current session can be found at:\r\n  \/u01\/app\/oraInventory\/logs\/crsdeconfig_wiractst01_2021-03-23_09-19-35PM.log\r\nRedirecting to \/bin\/systemctl restart rsyslog.service\r\n2021\/04\/09 21:23:06 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node\r\n<\/pre>\n<p>Y continuamos el proceso dandole a [ ENTER ]<\/p>\n<pre>\r\n######################### DECONFIG CLEAN OPERATION END #########################\r\n####################### DECONFIG CLEAN OPERATION SUMMARY #######################\r\nLocal node configuration of Oracle Grid Management database was removed successfully\r\nOracle Clusterware is stopped and successfully de-configured on node \"rac1\"\r\nOracle Clusterware is stopped and de-configured successfully.\r\n#######################################################################\r\n############# ORACLE DECONFIG TOOL END #############\r\nUsing properties file \/tmp\/deinstall2021-03-23-15-25PM\/response\/deinstall_2021-03-23-16-21-PM.rsp\r\nLocation of logs \/u01\/app\/oraInventory\/logs\/\r\n############ ORACLE DEINSTALL TOOL START ############\r\n####################### DEINSTALL CHECK OPERATION SUMMARY #######################\r\nA log of this session will be written to: '\/u01\/app\/oraInventory\/logs\/deinstall_deconfig2021-03-23-16-21-PM.out'\r\nAny error messages from this session will be written to: '\/u01\/app\/oraInventory\/logs\/deinstall_deconfig2021-03-23-16-21-PM.err'\r\n######################## DEINSTALL CLEAN OPERATION START ########################\r\n## [START] Preparing for Deinstall ##\r\nSetting LOCAL_NODE to rac1\r\nSetting CLUSTER_NODES to rac1\r\nSetting CRS_HOME to true\r\nSetting oracle.installer.invPtrLoc to \/tmp\/deinstall2021-03-23-15-25PM\/oraInst.loc\r\nSetting oracle.installer.local to true\r\n## [END] Preparing for Deinstall ##\r\nSetting the force flag to false\r\nSetting the force flag to cleanup the Oracle Base\r\nOracle Universal Installer clean START\r\nDetach Oracle home '\/u01\/app\/19c\/grid' from the central inventory on the local node : Done\r\nDelete directory '\/u01\/app\/19c\/grid' on the local node : Done\r\nThe Oracle Base directory '\/u01\/app\/oracle' will not be removed on local node. The directory is in use by Oracle Home '\/u01\/app\/oracle\/product\/12.1.0.2\/db'.\r\nOracle Universal Installer cleanup was successful.\r\nOracle Universal Installer clean END\r\n## [START] Oracle install clean ##\r\n## [END] Oracle install clean ##\r\n######################### DEINSTALL CLEAN OPERATION END #########################\r\n\r\n####################### DEINSTALL CLEAN OPERATION SUMMARY #######################\r\nSuccessfully detached Oracle home '\/u01\/app\/19\/grid' from the central inventory on the local node.\r\nSuccessfully deleted directory '\/u01\/app\/19\/grid' on the local node.\r\nOracle Universal Installer cleanup was successful.\r\n\r\nReview the permissions and contents of '\/u01\/app\/oracle' on nodes(s) 'rac1'.\r\nIf there are no Oracle home(s) associated with '\/u01\/app\/oracle', manually delete '\/u01\/app\/oracle' and its contents.\r\nOracle deinstall tool successfully cleaned up temporary directories.\r\n#######################################################################\r\n############# ORACLE DEINSTALL TOOL END #############\r\n<\/pre>\n<p>Ahora, iremos a uno de los nodos que quedan y eliminaremos el nodo 1  <\/p>\n<pre>\r\n[root@rac2 ~]$ .oraenv\r\nORACLE_SID = [root] ? +ASM2\r\nORACLE_BASE environment variable is not being set since this\r\ninformation is not available for the current user ID root.\r\nYou can set ORACLE_BASE manually if it is required.\r\nResetting ORACLE_BASE to its previous value or ORACLE_HOME\r\nThe Oracle base has been set to \/u01\/app\/19c\/grid\r\n\r\n[root@rac2 ~]$  $ORACLE_HOME\/bin\/crsctl delete node -n  rac1\r\nCRS-4661: Node rac1 successfully deleted.\r\n<\/pre>\n<p>Comprobamos de nuevo como usuario oracle el numero de nodos <\/p>\n<pre>\r\nrac2:oracle (+ASM2:\/home\/oracle) olsnodes -s -t\r\nrac2  Active  Unpinned\r\n<\/pre>\n<p>Mas informacion en:<\/p>\n<ul>\n<li>  How to Add Node\/Instance or Remove Node\/Instance with Oracle Clusterware and RAC (Doc ID 1332451.1)\n<li>  https:\/\/oracledbwr.com\/step-by-step-deleting-node-in-oracle-rac-12c-release-1-environment\n<\/ul>\n<p>Mas entradas para dummies sobre RAC:<br \/>\n<a href=\"http:\/\/clemente.pamplona.name\/dba\/comandos-basicos-en-orace-rac\/\">Comandos basicos en Orace RAC<\/a><br \/>\n<a href=\"http:\/\/clemente.pamplona.name\/dba\/comandos-basicos-del-rac-ii\/\">Comandos basicos del RAC II<\/a><br \/>\n<a href=\"http:\/\/clemente.pamplona.name\/dba\/eliminar-un-nodo-del-rac\/\">Eliminar un nodo del rac<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hoy vamos a ver la manera de eliminar de manera limpia un nodo de un RAC . Supondremos que queremos eliminar de nuestro cluster el nododo que llamamos rac1, los pasos a llevar a cabo seran: Eliminar del nodo las &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/eliminar-un-nodo-del-rac\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[565,60,921,975,49],"tags":[683,1007,1008],"class_list":["post-2232","post","type-post","status-publish","format-standard","hentry","category-11g-en","category-12c","category-18c","category-19c","category-rac","tag-deinstall","tag-desinstalacion","tag-desinstalar"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=2232"}],"version-history":[{"count":16,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2232\/revisions"}],"predecessor-version":[{"id":2266,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/2232\/revisions\/2266"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=2232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=2232"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=2232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}