{"id":1279,"date":"2018-01-07T10:42:02","date_gmt":"2018-01-07T02:42:02","guid":{"rendered":"http:\/\/www.821121.com\/?p=1279"},"modified":"2021-03-02T10:50:03","modified_gmt":"2021-03-02T02:50:03","slug":"oracle11g%e5%89%94%e9%99%a4%e8%8a%82%e7%82%b9%ef%bc%88%e4%b8%80%ef%bc%89","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1279","title":{"rendered":"Oracle11g\u5254\u9664\u8282\u70b9\uff08\u4e00\uff09"},"content":{"rendered":"
\u539f\u73af\u5883\uff1a 11.2.0.4\u96c6\u7fa43\u8282\u70b9   DB_NAME=racdb    \u5b9e\u4f8b\u540d racdb1\u3001racdbb2\u3001racdb3\n192.168.174.121  rac1\n192.168.174.122  rac2\n192.168.160.121 rac1priv\n192.168.160.122  rac2priv\n192.168.174.123  rac1vip\n192.168.174.124  rac2vip\n192.168.174.125 racscanip\n\n192.168.174.126  rac3\n192.168.174.127  rac3vip\n192.168.160.126  rac3priv<\/code><\/pre>\n
1.\u68c0\u67e5\u539f\u6709\u73af\u5883<\/h1>\n
crsctl stat res -t\nolsnodes -s -t\n\n[grid@rac1 ~]$ crsctl stat res -t\n--------------------------------------------------------------------------------\nNAME           TARGET  STATE        SERVER                   STATE_DETAILS       \n--------------------------------------------------------------------------------\nLocal Resources\n--------------------------------------------------------------------------------\nora.ARCH.dg\n               ONLINE  ONLINE       rac1                                         \n               ONLINE  ONLINE       rac2                                         \n               ONLINE  ONLINE       rac3                                         \nora.DATA.dg\n               ONLINE  ONLINE       rac1                                         \n               ONLINE  ONLINE       rac2                                         \n               ONLINE  ONLINE       rac3                                         \nora.LISTENER.lsnr\n               ONLINE  ONLINE       rac1                                         \n               ONLINE  ONLINE       rac2                                         \n               ONLINE  ONLINE       rac3                                         \nora.OCR.dg\n               ONLINE  ONLINE       rac1                                         \n               ONLINE  ONLINE       rac2                                         \n               ONLINE  ONLINE       rac3                                         \nora.asm\n               ONLINE  ONLINE       rac1                     Started             \n               ONLINE  ONLINE       rac2                     Started             \n               ONLINE  ONLINE       rac3                     Started             \nora.gsd\n               OFFLINE OFFLINE      rac1                                         \n               OFFLINE OFFLINE      rac2                                         \n               OFFLINE OFFLINE      rac3                                         \nora.net1.network\n               ONLINE  ONLINE       rac1                                         \n               ONLINE  ONLINE       rac2                                         \n               ONLINE  ONLINE       rac3                                         \nora.ons\n               ONLINE  ONLINE       rac1                                         \n               ONLINE  ONLINE       rac2                                         \n               ONLINE  ONLINE       rac3                                         \nora.registry.acfs\n               ONLINE  ONLINE       rac1                                         \n               ONLINE  ONLINE       rac2                                         \n               ONLINE  ONLINE       rac3                                         \n--------------------------------------------------------------------------------\nCluster Resources\n--------------------------------------------------------------------------------\nora.LISTENER_SCAN1.lsnr\n      1        ONLINE  ONLINE       rac1                                         \nora.cvu\n      1        ONLINE  ONLINE       rac1                                         \nora.oc4j\n      1        ONLINE  ONLINE       rac1                                         \nora.rac1.vip\n      1        ONLINE  ONLINE       rac1                                         \nora.rac2.vip\n      1        ONLINE  ONLINE       rac2                                         \nora.rac3.vip\n      1        ONLINE  ONLINE       rac3                                         \nora.racdb.db\n      1        ONLINE  ONLINE       rac1                     Open                \n      2        ONLINE  ONLINE       rac2                     Open                \n      3        ONLINE  ONLINE       rac3                     Open                \nora.scan1.vip\n      1        ONLINE  ONLINE       rac1            \n[grid@rac1 ~]$ olsnodes -s -t\nrac1    Active  Unpinned\nrac2    Active  Unpinned\nrac3    Active  Unpinned<\/code><\/pre>\n
2.\u624b\u5de5\u5907\u4efd OCR\uff08root\u7528\u6237\u4e0b\uff09<\/h1>\n
ocrconfig -manualbackup\nocrconfig -showbackup manual\n<\/code><\/pre>\n
3.DBCA \u5220\u9664\u6570\u636e\u5e93\u5b9e\u4f8b\uff08grid\u6709\u914d\u7f6eservice\u7684\u9700\u8981\u5148\u8c03\u6574service\u4fe1\u606f\uff09<\/h1>\n
3.1\u53ef\u4ee5\u5728\u53ef\u89c6\u5316\u754c\u9762\u64cd\u4f5c\uff0c\u4e5f\u53ef\u4ee5\u9759\u9ed8\u64cd\u4f5c<\/h2>\n
dbca -silent -deleteInstance [-nodeList node_name] -gdbName gdb_name -instanceName instance_name -sysDBAUserName sysdba -sysDBAPassword password\n\u5982\u4e0b\uff1a\n\u5728\u8282\u70b9 1 \u4e0a\u7528 Oracle \u7528\u6237\u6267\u884c\uff1a\ndbca -silent -deleteInstance -nodeList rac3 -gdbName racdb -instanceName racdb3 -sysDBAUserName sys -sysDBAPassword 123456\n\u8fc7\u7a0b\u5982\u4e0b\uff1a\n[oracle@rac1 ~]$ dbca -silent -deleteInstance -nodeList rac3 -gdbName racdb -instanceName racdb3 -sysDBAUserName sys -sysDBAPassword 123456\nDeleting instance\n1% complete\n2% complete\n6% complete\n13% complete\n20% complete\n26% complete\n33% complete\n40% complete\n46% complete\n53% complete\n60% complete\n66% complete\nCompleting instance management.\n100% complete\nLook at the log file "\/u01\/app\/oracle\/cfgtoollogs\/dbca\/racdb0.log" for further details<\/code><\/pre>\n
3.2\u786e\u8ba4 racdb3 \u5df2\u7ecf\u4ece CRS \u4e2d\u6e05\u9664\u3002\u6ce8\u610f\uff0c\u7528 oracle \u7528\u6237\u6267\u884c\uff0c\u8fd8\u8981\u6ce8\u610f oracle \u7528\u6237\u7684\u5c5e\u7ec4\u4fe1\u606f<\/h2>\n
srvctl config database -d racdb\n\n[oracle@rac1 ~]$ srvctl config database -d racdb\nDatabase unique name: racdb\nDatabase name: racdb\nOracle home: \/u01\/app\/oracle\/product\/11.2.0.4\/db_1\nOracle user: oracle\nSpfile: +DATA\/racdb\/spfileracdb.ora\nDomain: \nStart options: open\nStop options: immediate\nDatabase role: PRIMARY\nManagement policy: AUTOMATIC\nServer pools: racdb\nDatabase instances: racdb1,racdb2\nDisk Groups: DATA,ARCH,OCR\nMount point paths: \nServices: \nType: RAC\nDatabase is administrator managed\n<\/code><\/pre>\n
4.\u4ece RAC \u5c42\u9762\u5220\u9664\u8282\u70b9(Oracle \u8f6f\u4ef6)<\/h1>\n
4.1\u505c\u6b62\u8282\u70b9 3 \u7684 Listener<\/h2>\n
srvctl disable listener -l LISTENER -n rac3\nsrvctl stop listener -l LISTENER -n rac3\nsrvctl status listener -l listener<\/code><\/pre>\n
4.2\u5728\u8282\u70b9 3 \u7528 oracle \u7528\u6237\u66f4\u65b0 Inventory<\/h2>\n
\u9996\u5148\u9700\u8981\u4fdd\u8bc1\/etc\/oraInst.loc \u6587\u4ef6\u7684\u5185\u5bb9\u548c\u5176\u5b83\u8282\u70b9\u4e00\u81f4,\u5426\u5219\u6267\u884c\u4ee5\u4e0b updateNodeList \u547d\u4ee4\u65f6\u4f1a\u62a5\u9519\uff1a\n[root@rac3 ~]# cat \/etc\/oraInst.loc\ninventory_loc=\/u01\/app\/oraInventory\ninst_group=oinstall\n\noracle@rac3 bin]$ .\/runInstaller -updateNodeList\nORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0\/db_1 "CLUSTER_NODES=rac3"\nStarting Oracle Universal Installer...\nChecking swap space: must be greater than 500 MB. Actual 2047 MB Passed\nThe inventory pointer is located at \/etc\/oraInst.loc\nThe inventory is located at \/u01\/app\/oraInventory\n'UpdateNodeList' failed\n\n\u7136\u540e\u4ee5 oracle \u7528\u6237\u5728\u8282\u70b9 3 \u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\u66f4\u65b0\u8282\u70b9 3 \u7684 DB \u8f6f\u4ef6\uff1a\nsu - oracle\n$ORACLE_HOME\/oui\/bin\/runInstaller -updateNodeList ORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0.4\/db_1 "CLUSTER_NODES=rac3"\n\u8fc7\u7a0b\u5982\u4e0b\uff1a\n[oracle@rac3 bin]$ $ORACLE_HOME\/oui\/bin\/runInstaller -updateNodeList ORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0.4\/db_1 "CLUSTER_NODES=rac3"\nStarting Oracle Universal Installer...\n\nChecking swap space: must be greater than 500 MB.   Actual 2990 MB    Passed\nThe inventory pointer is located at \/etc\/oraInst.loc\nThe inventory is located at \/u01\/app\/oraInventory\n'UpdateNodeList' was successful.\n\n\u68c0\u67e5\uff1a\ncat \/u01\/app\/oraInventory\/ContentsXML\/inventory.xml\n\u8fc7\u7a0b\u5982\u4e0b\uff1a\n[oracle@rac3 bin]$ cat \/u01\/app\/oraInventory\/ContentsXML\/inventory.xml\n<?xml version="1.0" standalone="yes" ?>\n<!-- Copyright (c) 1999, 2013, Oracle and\/or its affiliates.\nAll rights reserved. -->\n<!-- Do not modify the contents of this file by hand. -->\n<INVENTORY>\n<VERSION_INFO>\n   <SAVED_WITH>11.2.0.4.0<\/SAVED_WITH>\n   <MINIMUM_VER>2.1.0.6.0<\/MINIMUM_VER>\n<\/VERSION_INFO>\n<HOME_LIST>\n<HOME NAME="Ora11g_gridinfrahome1" LOC="\/u01\/grid\/11.2.0.4" TYPE="O" IDX="1" CRS="true">\n   <NODE_LIST>\n      <NODE NAME="rac1"\/>\n      <NODE NAME="rac2"\/>\n      <NODE NAME="rac3"\/>\n   <\/NODE_LIST>\n<\/HOME>\n<HOME NAME="OraDb11g_home1" LOC="\/u01\/app\/oracle\/product\/11.2.0.4\/db_1" TYPE="O" IDX="2">\n   <NODE_LIST>\n      <NODE NAME="rac3"\/>\n   <\/NODE_LIST>\n<\/HOME>\n<\/HOME_LIST>\n<COMPOSITEHOME_LIST>\n<\/COMPOSITEHOME_LIST>\n<\/INVENTORY><\/code><\/pre>\n
4.3\u5220\u9664\u8282\u70b9 3 \u7684 ORACLE_HOME, \u7528 oracle \u7528\u6237\u6267\u884c deinstall \u547d\u4ee4<\/h2>\n
\u5728\u8282\u70b9 3 \u4ee5 Oracle \u7528\u6237\u6267\u884c\uff1a\n$ORACLE_HOME\/deinstall\/deinstall -local\n\u6267\u884c\u8fc7\u7a0b\u4e2d\u9700\u8981\u8f93\u5165 y\u3002\u6240\u4ee5\uff0c\u5343\u4e07\u4e0d\u8981\u6309\u56de\u8f66\u952e\n\n\u8fc7\u7a0b\u5982\u4e0b\uff1a\n[oracle@rac3 bin]$ $ORACLE_HOME\/deinstall\/deinstall -local\nChecking for required files and bootstrapping ...\nPlease wait ...\nLocation of logs \/u01\/app\/oraInventory\/logs\/\n\n############ ORACLE DEINSTALL & DECONFIG TOOL START ############\n\n######################### CHECK OPERATION START #########################\n## [START] Install check configuration ##\n\nChecking for existence of the Oracle home location \/u01\/app\/oracle\/product\/11.2.0.4\/db_1\nOracle Home type selected for deinstall is: Oracle Real Application Cluster Database\nOracle Base selected for deinstall is: \/u01\/app\/oracle\nChecking for existence of central inventory location \/u01\/app\/oraInventory\nChecking for existence of the Oracle Grid Infrastructure home \/u01\/grid\/11.2.0.4\nThe following nodes are part of this cluster: rac3\nChecking for sufficient temp space availability on node(s) : 'rac3'\n\n## [END] Install check configuration ##\n\nNetwork Configuration check config START\n\nNetwork de-configuration trace file location: \/u01\/app\/oraInventory\/logs\/netdc_check2021-01-04_10-33-46-AM.log\n\nNetwork Configuration check config END\n\nDatabase Check Configuration START\n\nDatabase de-configuration trace file location: \/u01\/app\/oraInventory\/logs\/databasedc_check2021-01-04_10-34-02-AM.log\n\nDatabase Check Configuration END\n\nEnterprise Manager Configuration Assistant START\n\nEMCA de-configuration trace file location: \/u01\/app\/oraInventory\/logs\/emcadc_check2021-01-04_10-34-13-AM.log \n\nEnterprise Manager Configuration Assistant END\nOracle Configuration Manager check START\nOCM check log file location : \/u01\/app\/oraInventory\/logs\/\/ocm_check3100.log\nOracle Configuration Manager check END\n\n######################### CHECK OPERATION END #########################\n\n####################### CHECK OPERATION SUMMARY #######################\nOracle Grid Infrastructure Home is: \/u01\/grid\/11.2.0.4\nThe cluster node(s) on which the Oracle home deinstallation will be performed are:rac3\nSince -local option has been specified, the Oracle home will be deinstalled only on the local node, 'rac3', and the global configuration will be removed.\nOracle Home selected for deinstall is: \/u01\/app\/oracle\/product\/11.2.0.4\/db_1\nInventory Location where the Oracle home registered is: \/u01\/app\/oraInventory\nThe option -local will not modify any database configuration for this Oracle home.\n\nNo Enterprise Manager configuration to be updated for any database(s)\nNo Enterprise Manager ASM targets to update\nNo Enterprise Manager listener targets to migrate\nChecking the config status for CCR\nOracle Home exists with CCR directory, but CCR is not configured\nCCR check is finished\nDo you want to continue (y - yes, n - no)? [n]: y\nA log of this session will be written to: '\/u01\/app\/oraInventory\/logs\/deinstall_deconfig2021-01-04_10-33-04-AM.out'\nAny error messages from this session will be written to: '\/u01\/app\/oraInventory\/logs\/deinstall_deconfig2021-01-04_10-33-04-AM.err'\n\n######################## CLEAN OPERATION START ########################\n\nEnterprise Manager Configuration Assistant START\n\nEMCA de-configuration trace file location: \/u01\/app\/oraInventory\/logs\/emcadc_clean2021-01-04_10-34-13-AM.log \n\nUpdating Enterprise Manager ASM targets (if any)\nUpdating Enterprise Manager listener targets (if any)\nEnterprise Manager Configuration Assistant END\nDatabase de-configuration trace file location: \/u01\/app\/oraInventory\/logs\/databasedc_clean2021-01-04_10-35-34-AM.log\n\nNetwork Configuration clean config START\n\nNetwork de-configuration trace file location: \/u01\/app\/oraInventory\/logs\/netdc_clean2021-01-04_10-35-34-AM.log\n\nDe-configuring Local Net Service Names configuration file...\nLocal Net Service Names configuration file de-configured successfully.\n\nDe-configuring backup files...\nBackup files de-configured successfully.\n\nThe network configuration has been cleaned up successfully.\n\nNetwork Configuration clean config END\n\nOracle Configuration Manager clean START\nOCM clean log file location : \/u01\/app\/oraInventory\/logs\/\/ocm_clean3100.log\nOracle Configuration Manager clean END\nSetting the force flag to false\nSetting the force flag to cleanup the Oracle Base\nOracle Universal Installer clean START\n\nDetach Oracle home '\/u01\/app\/oracle\/product\/11.2.0.4\/db_1' from the central inventory on the local node : Done\n\nDelete directory '\/u01\/app\/oracle\/product\/11.2.0.4\/db_1' on the local node : Done\n\nDelete directory '\/u01\/app\/oracle' on the local node : Done\n\nOracle Universal Installer cleanup was successful.\n\nOracle Universal Installer clean END\n\n## [START] Oracle install clean ##\n\nClean install operation removing temporary directory '\/tmp\/deinstall2021-01-04_10-27-40AM' on node 'rac3'\n\n## [END] Oracle install clean ##\n\n######################### CLEAN OPERATION END #########################\n\n####################### CLEAN OPERATION SUMMARY #######################\nCleaning the config for CCR\nAs CCR is not configured, so skipping the cleaning of CCR configuration\nCCR clean is finished\nSuccessfully detached Oracle home '\/u01\/app\/oracle\/product\/11.2.0.4\/db_1' from the central inventory on the local node.\nSuccessfully deleted directory '\/u01\/app\/oracle\/product\/11.2.0.4\/db_1' on the local node.\nSuccessfully deleted directory '\/u01\/app\/oracle' on the local node.\nOracle Universal Installer cleanup was successful.\n\nOracle deinstall tool successfully cleaned up temporary directories.\n#######################################################################\n\n############# ORACLE DEINSTALL & DECONFIG TOOL END #############<\/code><\/pre>\n
4.4\u5728\u8282\u70b9 1 \u7528 Oracle \u7528\u6237\u66f4\u65b0 inventory<\/h2>\n
\u8282\u70b9 1 \u4ee5 oracle \u7528\u6237\u6267\u884c\uff1a\nsu - oracle\n$ORACLE_HOME\/oui\/bin\/runInstaller -updateNodeList ORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0.4\/db_1 "CLUSTER_NODES=rac1,rac2"\n\u68c0\u67e5\uff1a\ncat \/u01\/app\/oraInventory\/ContentsXML\/inventory.xml\n\n\u8fc7\u7a0b\u5982\u4e0b\uff1a\n[oracle@rac1 ~]$ $ORACLE_HOME\/oui\/bin\/runInstaller -updateNodeList ORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0.4\/db_1 "CLUSTER_NODES=rac1,rac2"\nStarting Oracle Universal Installer...\n\nChecking swap space: must be greater than 500 MB.   Actual 4581 MB    Passed\nThe inventory pointer is located at \/etc\/oraInst.loc\nThe inventory is located at \/u01\/app\/oraInventory\n'UpdateNodeList' was successful.\n[oracle@rac1 ~]$ cat \/u01\/app\/oraInventory\/ContentsXML\/inventory.xml\n<?xml version="1.0" standalone="yes" ?>\n<!-- Copyright (c) 1999, 2013, Oracle and\/or its affiliates.\nAll rights reserved. -->\n<!-- Do not modify the contents of this file by hand. -->\n<INVENTORY>\n<VERSION_INFO>\n   <SAVED_WITH>11.2.0.4.0<\/SAVED_WITH>\n   <MINIMUM_VER>2.1.0.6.0<\/MINIMUM_VER>\n<\/VERSION_INFO>\n<HOME_LIST>\n<HOME NAME="Ora11g_gridinfrahome1" LOC="\/u01\/grid\/11.2.0.4" TYPE="O" IDX="1" CRS="true">\n   <NODE_LIST>\n      <NODE NAME="rac1"\/>\n      <NODE NAME="rac2"\/>\n      <NODE NAME="rac3"\/>\n   <\/NODE_LIST>\n<\/HOME>\n<HOME NAME="OraDb11g_home1" LOC="\/u01\/app\/oracle\/product\/11.2.0.4\/db_1" TYPE="O" IDX="2">\n   <NODE_LIST>\n      <NODE NAME="rac1"\/>\n      <NODE NAME="rac2"\/>\n   <\/NODE_LIST>\n<\/HOME>\n<\/HOME_LIST>\n<COMPOSITEHOME_LIST>\n<\/COMPOSITEHOME_LIST>\n<\/INVENTORY><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u539f\u73af\u5883\uff1a 11.2.0.4\u96c6\u7fa43\u8282\u70b9 DB_NAM<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1279","post","type-post","status-publish","format-standard","hentry","category-oracle-11g"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1279"}],"version-history":[{"count":2,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1279\/revisions"}],"predecessor-version":[{"id":1282,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1279\/revisions\/1282"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1279"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}