oracle 11gr2 \u5220\u9664\u8282\u70b9\u6700\u4f73\u5b9e\u8df5<\/p>\n
OS\u4fe1\u606f:
\n[grid@11grac1 ~]$ uname -a
\nLinux 11grac1 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST 2012 i686 i686 i386 GNU\/Linux
\nDB\u4fe1\u606f:
\nSQL> select * from v$version where rownum<5;<\/p>\n
BANNER
\n------------------------------------------------------------------------<\/p>\n
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
\nPL\/SQL Release 11.2.0.1.0 - Production
\nCORE 11.2.0.1.0 Production
\nTNS for Linux: Version 11.2.0.1.0 - Production<\/p>\n
\u67e5\u770b\u5f53\u524d\u8d44\u6e90\u72b6\u6001
\n[grid@11grac1 ~]$ crs_stat -t
\nName Type Target State Host
\n------------------------------------------------------------
\nora....SM1.asm application ONLINE ONLINE 11grac1
\nora....C1.lsnr application ONLINE ONLINE 11grac1
\nora....ac1.gsd application ONLINE ONLINE 11grac1
\nora....ac1.ons application ONLINE ONLINE 11grac1
\nora....ac1.vip ora....t1.type ONLINE ONLINE 11grac1
\nora....SM2.asm application ONLINE ONLINE 11grac2
\nora....C2.lsnr application ONLINE ONLINE 11grac2
\nora....ac2.gsd application ONLINE ONLINE 11grac2
\nora....ac2.ons application ONLINE ONLINE 11grac2
\nora....ac2.vip ora....t1.type ONLINE ONLINE 11grac2
\nora.DATA.dg ora....up.type ONLINE ONLINE 11grac1
\nora....ER.lsnr ora....er.type ONLINE ONLINE 11grac1
\nora....N1.lsnr ora....er.type ONLINE ONLINE 11grac1
\nora.asm ora.asm.type ONLINE ONLINE 11grac1
\nora.eons ora.eons.type ONLINE ONLINE 11grac1
\nora.gsd ora.gsd.type ONLINE ONLINE 11grac1
\nora....network ora....rk.type ONLINE ONLINE 11grac1
\nora.oc4j ora.oc4j.type ONLINE ONLINE 11grac1
\nora.ons ora.ons.type ONLINE ONLINE 11grac1
\nora.racdb.db ora....se.type ONLINE ONLINE 11grac1
\nora.scan1.vip ora....ip.type ONLINE ONLINE 11grac1
\n[grid@11grac1 ~]$ srvctl status database -d racdb
\nInstance racdb1 is running on node 11grac1
\nInstance racdb2 is running on node 11grac2<\/p>\n
\u5199\u5165\u6d4b\u8bd5\u6570\u636e
\n[oracle@11grac1 ~]$ sqlplus \/nolog<\/p>\n
SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 29 10:02:08 2012<\/p>\n
Copyright (c) 1982, 2009, Oracle. All rights reserved.<\/p>\n
SQL> conn \/as sysdba
\nConnected.
\nSQL> sho user
\nUSER is \"SYS\"
\nSQL> create table test (id number,name varchar2(10));<\/p>\n
Table created.
\nSQL> insert into test values (1,'yallonking');<\/p>\n
1 row created.<\/p>\n
SQL> commit;<\/p>\n
Commit complete.<\/p>\n
SQL> select * from test;<\/p>\n
ID NAME
\n---------- ----------
\n1 yallonking<\/p>\n
\u5220\u9664\u8282\u70b9\u5b9e\u4f8b\uff08\u53ef\u7528DBCA\uff0c\u4e5f\u53ef\u7528\u540e\u8fb9\u7684\u547d\u4ee4\u9759\u9ed8\u5220\u9664\uff09
\n\u8fd0\u884cdbca,\u6839\u636e\u5411\u5bfc\u5220\u9664\u76f8\u5173\u4fe1\u606f
\ninstance management-> delete an instance-> \u8f93\u5165sysdba\u7528\u6237\u7684\u8d26\u6237\u548c\u5bc6\u7801-> \u9009\u5b9a\u5220\u9664\u7684\u8282\u70b9\u5b9e\u4f8b
\n[oracle@11grac1 ~]$ export DISPLAY=192.168.137.1:0.0
\n[oracle@11grac1 ~]$ dbca<\/p>\n
\u67e5\u770b\u6570\u636e\u5e93\u72b6\u6001
\n[grid@11grac1 ~]$ srvctl status database -d racdb
\nInstance racdb1 is running on node 11grac1
\n[grid@11grac1 ~]$ crsctl check cluster -all
\n**************************************************************
\n11grac1:
\nCRS-4537: Cluster Ready Services is online
\nCRS-4529: Cluster Synchronization Services is online
\nCRS-4533: Event Manager is online
\n**************************************************************
\n11grac2:
\nCRS-4537: Cluster Ready Services is online
\nCRS-4529: Cluster Synchronization Services is online
\nCRS-4533: Event Manager is online
\n**************************************************************
\n[grid@11grac1 ~]$<\/p>\n
\u5220\u9664EM
\n[oracle@11grac1 ~]$ emca -deconfig dbcontrol db -repos drop -cluster<\/p>\n
STARTED EMCA at Aug 29, 2012 10:29:12 AM
\nEM Configuration Assistant, Version 11.2.0.0.2 Production
\nCopyright (c) 2003, 2005, Oracle. All rights reserved.<\/p>\n
Enter the following information:
\nDatabase unique name: racdb
\nService name: racdb
\nListener port number: 1521
\nListener ORACLE_HOME [ \/u01\/11.2.0\/grid ]:
\nPassword for SYS user:
\nPassword for SYSMAN user:
\nDo you wish to continue? [yes(Y)\/no(N)]: y
\nAug 29, 2012 10:29:35 AM oracle.sysman.emcp.EMConfig perform
\nINFO: This operation is being logged at \/u01\/app\/oracle\/cfgtoollogs\/emca\/racdb\/emca_2012_08_29_10_29_11.log.
\nAug 29, 2012 10:29:36 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
\nWARNING: EM is not configured for this database. No EM-specific actions can be performed.
\nAug 29, 2012 10:29:45 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
\nWARNING: Error initializing SQL connection. SQL operations cannot be performed
\nAug 29, 2012 10:29:45 AM oracle.sysman.emcp.EMReposConfig invoke
\nINFO: Dropping the EM repository (this may take a while) ...
\nAug 29, 2012 10:43:38 AM oracle.sysman.emcp.EMReposConfig invoke
\nINFO: Repository successfully dropped
\nEnterprise Manager configuration completed successfully
\nFINISHED EMCA at Aug 29, 2012 10:43:38 AM
\n[oracle@11grac1 ~]$<\/p>\n
\u5907\u4efdOCR
\n[root@11grac1 ~]# \/u01\/11.2.0\/grid\/bin\/ocrconfig -manualbackup<\/p>\n
11grac1 2012\/08\/29 10:47:33 \/u01\/11.2.0\/grid\/cdata\/racscan\/backup_20120829_104733.ocr
\n[root@11grac1 ~]#<\/p>\n
\u5220\u9664\u5b9e\u4f8b\uff08\u9759\u9ed8\u72b6\u6001\u4e0b\uff09
\n[oracle@11grac1 ~]$ dbca -silent -deleteinstance -nodelist 11grac2 -gdbname racdb -instancename racdb2 -sysdbausername sys -sysdbapassword oracle
\nLook at the log file \"\/u01\/app\/oracle\/cfgtoollogs\/dbca\/racdb.log\" for further details.<\/p>\n
\u67e5\u770b\u6570\u636e\u5e93\u914d\u7f6e\u4fe1\u606f
\n[oracle@11grac1 ~]$ srvctl config database -d racdb
\nDatabase unique name: racdb
\nDatabase name: racdb
\nOracle home: \/u01\/app\/oracle\/product\/11.2.0\/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
\nDisk Groups: DATA
\nServices:
\nDatabase is administrator managed<\/p>\n
\u67e5\u770b\u6570\u636e\u5e93\u5b9e\u4f8b\u548credo\u60c5\u51b5
\n[oracle@11grac1 ~]$ sqlplus \/nolog<\/p>\n
SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 29 10:51:31 2012<\/p>\n
Copyright (c) 1982, 2009, Oracle. All rights reserved.<\/p>\n
SQL> conn \/as sysdba
\nConnected.
\nSQL> select inst_id,instance_name from gv$instance;<\/p>\n
INST_ID INSTANCE_NAME
\n---------- ----------------
\n1 racdb1<\/p>\n
SQL> select group#,thread# from v$log;<\/p>\n
GROUP# THREAD#
\n---------- ----------
\n1 1
\n2 1<\/p>\n
\u67e5\u770b\u8282\u70b9\u76d1\u542c\u914d\u7f6e\u4fe1\u606f
\n[oracle@11grac2 ~]$ srvctl config listener -a
\nName: LISTENER
\nNetwork: 1, Owner: grid
\nHome:
\n\/u01\/11.2.0\/grid on node(s) 11grac2,11grac1
\nEnd points: TCP:1521<\/p>\n
\u66f4\u65b0oracle inventory
\n[oracle@11grac2 db_1]$ \/u01\/app\/oracle\/product\/11.2.0\/db_1\/oui\/bin\/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME \"CLUSTER_NODES={11grac2}\" -local
\nStarting Oracle Universal Installer...<\/p>\n
Checking swap space: must be greater than 500 MB. Actual 4094 MB Passed
\nThe inventory pointer is located at \/etc\/oraInst.loc
\nThe inventory is located at \/u01\/app\/oraInventory
\n'UpdateNodeList' was successful.<\/p>\n
\u5220\u9664oracle\u8f6f\u4ef6
\n[oracle@11grac2 db_1]$ cd $ORACLE_HOME\/deinstall
\n[oracle@11grac2 deinstall]$ .\/deinstall -local
\nChecking for required files and bootstrapping ...
\nPlease wait ...<\/p>\n
\u66f4\u65b0oracle inventory
\n[oracle@11grac1 ~]$ $ORACLE_HOME\/oui\/bin\/runInstaller -updatenodelist ORACLE_HOME=$ORACLE_HOME \"CLUSTER_NODES={11grac1}\"
\nStarting Oracle Universal Installer...<\/p>\n
Checking swap space: must be greater than 500 MB. Actual 3854 MB Passed
\nThe inventory pointer is located at \/etc\/oraInst.loc
\nThe inventory is located at \/u01\/app\/oraInventory
\n'UpdateNodeList' was successful.<\/p>\n
\u67e5\u770b\u8282\u70b9\u72b6\u6001
\n[root@11grac1 ~]# \/u01\/11.2.0\/grid\/bin\/olsnodes -s -t
\n11grac1 Active Unpinned
\n11grac2 Active Unpinned<\/p>\n
\u7981\u7528\u8282\u70b9cluster
\n[root@11grac2 ~]# cd \/u01\/11.2.0\/grid\/crs\/install\/
\n[root@11grac2 install]# .\/rootcrs.pl -deconfig -force
\n2012-08-29 11:06:54: Parsing the host name
\n2012-08-29 11:06:54: Checking for super user privileges
\n2012-08-29 11:06:54: User has super user privileges
\nUsing configuration parameter file: .\/crsconfig_params
\nVIP exists.:11grac1
\nVIP exists.: \/11grac1-vip\/192.168.137.163\/255.255.255.0\/eth0
\nVIP exists.:11grac2
\nVIP exists.: \/11grac2-vip\/192.168.137.164\/255.255.255.0\/eth0
\nGSD exists.
\nONS daemon exists. Local port 6100, remote port 6200
\neONS daemon exists. Multicast port 18611, multicast IP address 234.228.184.247, listening port 2016
\nADVM\/ACFS is not supported on oraclelinux-release-5-8.0.2<\/p>\n
ACFS-9201: Not Supported
\nCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on '11grac2'
\nCRS-2673: Attempting to stop 'ora.crsd' on '11grac2'
\nCRS-2790: Starting shutdown of Cluster Ready Services-managed resources on '11grac2'
\nCRS-2673: Attempting to stop 'ora.DATA.dg' on '11grac2'
\nCRS-2677: Stop of 'ora.DATA.dg' on '11grac2' succeeded
\nCRS-2673: Attempting to stop 'ora.asm' on '11grac2'
\nCRS-2677: Stop of 'ora.asm' on '11grac2' succeeded
\nCRS-2792: Shutdown of Cluster Ready Services-managed resources on '11grac2' has completed
\nCRS-2677: Stop of 'ora.crsd' on '11grac2' succeeded
\nCRS-2673: Attempting to stop 'ora.mdnsd' on '11grac2'
\nCRS-2673: Attempting to stop 'ora.gpnpd' on '11grac2'
\nCRS-2673: Attempting to stop 'ora.cssdmonitor' on '11grac2'
\nCRS-2673: Attempting to stop 'ora.ctssd' on '11grac2'
\nCRS-2673: Attempting to stop 'ora.evmd' on '11grac2'
\nCRS-2673: Attempting to stop 'ora.asm' on '11grac2'
\nCRS-2677: Stop of 'ora.cssdmonitor' on '11grac2' succeeded
\nCRS-2677: Stop of 'ora.mdnsd' on '11grac2' succeeded
\nCRS-2677: Stop of 'ora.gpnpd' on '11grac2' succeeded
\nCRS-2677: Stop of 'ora.evmd' on '11grac2' succeeded
\nCRS-2677: Stop of 'ora.ctssd' on '11grac2' succeeded
\nCRS-2675: Stop of 'ora.asm' on '11grac2' failed
\nCRS-2679: Attempting to clean 'ora.asm' on '11grac2'
\nORA-01089: immediate shutdown in progress - no operations are permitted
\nProcess ID: 0
\nSession ID: 0 Serial number: 0<\/p>\n
CRS-2681: Clean of 'ora.asm' on '11grac2' succeeded
\nCRS-2673: Attempting to stop 'ora.cssd' on '11grac2'
\nCRS-2677: Stop of 'ora.cssd' on '11grac2' succeeded
\nCRS-2673: Attempting to stop 'ora.diskmon' on '11grac2'
\nCRS-2673: Attempting to stop 'ora.gipcd' on '11grac2'
\nCRS-2677: Stop of 'ora.gipcd' on '11grac2' succeeded
\nCRS-2677: Stop of 'ora.diskmon' on '11grac2' succeeded
\nCRS-2793: Shutdown of Oracle High Availability Services-managed resources on '11grac2' has completed
\nCRS-4133: Oracle High Availability Services has been stopped.
\nSuccessfully deconfigured Oracle clusterware stack on this node
\n[root@11grac2 install]#<\/p>\n
\u67e5\u770b\u8282\u70b9\u72b6\u6001
\n[grid@11grac1 ~]$ olsnodes -s -t
\n11grac1 Active Unpinned
\n11grac2 Inactive Unpinned<\/p>\n
\u5220\u9664\u8282\u70b9
\n[root@11grac1 ~]# \/u01\/11.2.0\/grid\/bin\/crsctl delete node -n 11grac2
\nCRS-4661: Node 11grac2 successfully deleted.<\/p>\n
\u67e5\u770b\u8282\u70b9\u72b6\u6001
\n[root@11grac1 ~]# \/u01\/11.2.0\/grid\/bin\/olsnodes -s -t
\n11grac1 Active Unpinned<\/p>\n
\u66f4\u65b0oracle inventory
\n[grid@11grac2 bin]$ pwd
\n\/u01\/11.2.0\/grid\/oui\/bin
\n[grid@11grac2 bin]$ .\/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME \"CLUSTER_NODES={11grac2}\" CRS=TRUE -local
\nStarting Oracle Universal Installer...<\/p>\n
Checking swap space: must be greater than 500 MB. Actual 4094 MB Passed
\nThe inventory pointer is located at \/etc\/oraInst.loc
\nThe inventory is located at \/u01\/app\/oraInventory
\n'UpdateNodeList' was successful.<\/p>\n
\u5220\u9664GI\u8f6f\u4ef6
\n[grid@11grac2 deinstall]$ pwd
\n\/u01\/11.2.0\/grid\/deinstall
\n[grid@11grac2 deinstall]$ .\/deinstall -local
\nChecking for required files and bootstrapping ...
\nPlease wait ...<\/p>\n
\u5220\u9664\u76f8\u5173\u76ee\u5f55
\n[root@11grac2 install]# rm -rf \/etc\/oraInst.loc
\n[root@11grac2 install]# rm -rf \/opt\/ORCLfmap\/
\n[root@11grac2 install]# rm -rf \/u01<\/p>\n
\u66f4\u65b0oracle inventory
\n[grid@11grac1 bin]$ pwd
\n\/u01\/11.2.0\/grid\/oui\/bin
\n[grid@11grac1 bin]$ .\/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME \"CLUSTER_NODES={11grac1}\" CRS=TRUE
\nStarting Oracle Universal Installer...<\/p>\n
Checking swap space: must be greater than 500 MB. Actual 3826 MB Passed
\nThe inventory pointer is located at \/etc\/oraInst.loc
\nThe inventory is located at \/u01\/app\/oraInventory
\n'UpdateNodeList' was successful.<\/p>\n
\u5220\u9664\u540e\u7684\u9a8c\u8bc1
\n[grid@11grac1 bin]$ cluvfy stage -post nodedel -n 11grac2 -verbose<\/p>\n
Performing post-checks for node removal<\/p>\n
Checking CRS integrity...
\nThe Oracle clusterware is healthy on node \"11grac1\"<\/p>\n
CRS integrity check passed<\/p>\n
Result:
\nNode removal check passed<\/p>\n
Post-check for node removal was successful.<\/p>\n
\u67e5\u770b\u8282\u70b9\u8d44\u6e90\u4fe1\u606f
\n[grid@11grac1 ~]$ crsctl check cluster -all
\n**************************************************************
\n11grac1:
\nCRS-4537: Cluster Ready Services is online
\nCRS-4529: Cluster Synchronization Services is online
\nCRS-4533: Event Manager is online
\n**************************************************************<\/p>\n
[grid@11grac1 ~]$ crs_stat -t
\nName Type Target State Host
\n------------------------------------------------------------
\nora....SM1.asm application ONLINE ONLINE 11grac1
\nora....C1.lsnr application ONLINE ONLINE 11grac1
\nora....ac1.gsd application ONLINE ONLINE 11grac1
\nora....ac1.ons application ONLINE ONLINE 11grac1
\nora....ac1.vip ora....t1.type ONLINE ONLINE 11grac1
\nora.DATA.dg ora....up.type ONLINE ONLINE 11grac1
\nora....ER.lsnr ora....er.type ONLINE ONLINE 11grac1
\nora....N1.lsnr ora....er.type ONLINE ONLINE 11grac1
\nora.asm ora.asm.type ONLINE ONLINE 11grac1
\nora.eons ora.eons.type ONLINE ONLINE 11grac1
\nora.gsd ora.gsd.type ONLINE ONLINE 11grac1
\nora....network ora....rk.type ONLINE ONLINE 11grac1
\nora.oc4j ora.oc4j.type ONLINE ONLINE 11grac1
\nora.ons ora.ons.type ONLINE ONLINE 11grac1
\nora.racdb.db ora....se.type ONLINE ONLINE 11grac1
\nora.scan1.vip ora....ip.type ONLINE ONLINE 11grac1
\n[grid@11grac1 ~]$<\/p>\n
\u9a8c\u8bc1\u6d4b\u8bd5\u6570\u636e
\nMicrosoft Windows [\u7248\u672c 6.1.7600]
\n\u7248\u6743\u6240\u6709 (c) 2009 Microsoft Corporation\u3002\u4fdd\u7559\u6240\u6709\u6743\u5229\u3002<\/p>\n
C:\\Users\\YallonKing>sqlplus \/nolog<\/p>\n
SQL*Plus: Release 11.2.0.1.0 Production on \u661f\u671f\u4e09 8\u6708 29 12:29:43 2012<\/p>\n
Copyright (c) 1982, 2010, Oracle. All rights reserved.<\/p>\n
SQL> conn sys\/oracle@racdb_11g as sysdba
\n\u5df2\u8fde\u63a5\u3002<\/p>\n
SQL> select instance_name from gv$instance;<\/p>\n
INSTANCE_NAME
\n--------------------------------
\nracdb1<\/p>\n
SQL> select * from test;<\/p>\n
ID NAME
\n---------- --------------------
\n1 yallonking<\/p>\n
\u5269\u4e0b\u7684\u5c31\u662f\u5220\u9664\u88ab\u5220\u9664\u8282\u70b9\u7684GI\u548cORACLE\u76f8\u5173\u6587\u4ef6\u3001\u7528\u6237\u3001\u7ec4\u3001\u88f8\u8bbe\u5907\u3001\u7f51\u7edc\u8bbe\u7f6e\u7b49\u4fe1\u606f\u3002<\/p>\n
\u81f3\u6b64\uff0cOK\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
oracle 11gr2 \u5220\u9664\u8282\u70b9\u6700\u4f73\u5b9e\u8df5 OS\u4fe1\u606f: [grid@11grac1 ~]$ uname -a […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[35],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/295"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=295"}],"version-history":[{"count":11,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/295\/revisions"}],"predecessor-version":[{"id":498,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/295\/revisions\/498"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=295"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}