Oracle RAC下删除节点

左手的ㄟ右手 2022-09-30 07:31 261阅读 0赞

**1.测试环境：**

OS:Centos 6.8

Oralce:11.2.0.4

3节点RAC，主机名是rac1,rac2,rac3 现在需要删除rac3

3个节点实例均正常运行，在线删除节点

**2.节点确认**

登陆任一节点，执行

SQL> select thread\#,status,instance from v$thread;  
  
  
   THREAD\# STATUS  
\---------- ------  
INSTANCE  
\--------------------------------------------------------------------------------  
1 OPEN  
rac1  
  
  
2 OPEN  
rac2  
  
  
3 OPEN  
rac3  
  
说明3个节点，实例名是rac1,rac2,rac3

rac1:/u01/app/11.2.0/grid\_1/bin@rac1>./olsnodes -t -s  
rac1Active Unpinned  
rac2Active Unpinned  
rac3Active Unpinned

**3.在所有保留节点（rac1，rac2）上执行**

\[root@rac1 ~\]\# cd /u01/app/11.2.0/grid\_1/bin/  
\[root@rac1 bin\]\# ./crsctl unpin css -n rac3  
CRS-4667: Node rac3 successfully unpinned.

\[root@rac2 ~\]\# cd /u01/app/11.2.0/grid\_1/bin/  
\[root@rac2 bin\]\# ./crsctl unpin css -n rac3  
CRS-4667: Node rac3 successfully unpinned.

**4.使用dbca删除rac3实例**

注意这里需要在任一保留节点上删除rac3实例，也就是必须在rac1或rac2上执行

![Center][]

![Center 1][]

![Center 2][]

![Center 3][]

![Center 4][]

![Center 5][]

![Center 6][]

![Center 7][]

![Center 8][]

![Center 9][]

**5.验证rac3实例已被删除**

查看活动的实例：

SQL> select thread\#,status,instance from v$thread;  
  
  
   THREAD\# STATUS  
\---------- ------  
INSTANCE  
\--------------------------------------------------------------------------------  
1 OPEN  
rac1  
  
  
2 OPEN

rac2

//已经没有rac3

rac3:/home/oracle@rac3>ps -ef|grep ora\_  
oracle    7550 30915  0 14:17 pts/0    00:00:00 grep ora\_

//rac3的oracle进程已经消失

**查看库的配置**

rac1:/home/oracle@rac1>srvctl config database -d rac  
Database unique name: rac  
Database name: rac  
Oracle home: /u01/app/oracle/product/11.2.0/db\_1  
Oracle user: oracle  
Spfile: +DATA/rac/spfilerac.ora  
Domain:   
Start options: open  
Stop options: immediate  
Database role: PRIMARY  
Management policy: AUTOMATIC  
Server pools: rac  
Database instances: rac1,rac2  
Disk Groups: DATA,FRA\_ARC  
Mount point paths:   
Services:   
Type: RAC  
Database is administrator managed

**6.停止rac3节点的监听**

rac3:/home/oracle@rac3>srvctl config listener -a  
Name: LISTENER  
Network: 1, Owner: grid  
Home: <CRS home>  
  /u01/app/11.2.0/grid\_1 on node(s) rac3,rac1,rac2  
End points: TCP:1521

rac3:/home/oracle@rac3>srvctl disable listener -l listener -n rac3  
rac3:/home/oracle@rac3>srvctl stop listener -l listener -n rac3  
rac3:/home/oracle@rac3>lsnrctl status  
  
  
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 13-MAR-2017 14:22:50  
  
  
Copyright (c) 1991, 2013, Oracle.  All rights reserved.  
  
  
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))  
TNS-12541: TNS:no listener  
 TNS-12560: TNS:protocol adapter error  
  TNS-00511: No listener  
   Linux Error: 111: Connection refused

//rac3监听已停止，rac1和rac2监听还在

**7.在rac3节点使用oracle用户更新集群列表**

rac3:/home/oracle@rac3>/u01/app/oracle/product/11.2.0/db\_1/oui/bin/runInstaller -updateNodeList ORACLE\_HOME=$ORACLE\_HOME "CLUSTER\_NODES=\{rac3\}" -local  
Starting Oracle Universal Installer...  
  
  
Checking swap space: must be greater than 500 MB.   Actual 3502 MB    Passed  
The inventory pointer is located at /etc/oraInst.loc  
The inventory is located at /u01/app/oraInventory  
'UpdateNodeList' was successful.

8.删除rac3节点的库软件  
rac3:/home/oracle@rac3>$ORACLE\_HOME/deinstall/deinstall -local  
Checking for required files and bootstrapping ...  
Please wait ...  
Location of logs /u01/app/oraInventory/logs/  
  
  
\#\#\#\#\#\#\#\#\#\#\#\# ORACLE DEINSTALL & DECONFIG TOOL START \#\#\#\#\#\#\#\#\#\#\#\#  
  
  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CHECK OPERATION START \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\#\# \[START\] Install check configuration \#\#  
  
  
  
  
Checking for existence of the Oracle home location /u01/app/oracle/product/11.2.0/db\_1  
Oracle Home type selected for deinstall is: Oracle Real Application Cluster Database  
Oracle Base selected for deinstall is: /u01/app/oracle  
Checking for existence of central inventory location /u01/app/oraInventory  
Checking for existence of the Oracle Grid Infrastructure home /u01/app/11.2.0/grid\_1  
The following nodes are part of this cluster: rac3  
Checking for sufficient temp space availability on node(s) : 'rac3'  
  
  
\#\# \[END\] Install check configuration \#\#  
  
  
  
  
Network Configuration check config START  
  
  
Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc\_check2017-03-13\_02-25-52-PM.log  
  
  
Network Configuration check config END  
  
  
Database Check Configuration START  
  
  
Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc\_check2017-03-13\_02-25-57-PM.log  
  
  
Database Check Configuration END  
  
  
Enterprise Manager Configuration Assistant START  
  
  
EMCA de-configuration trace file location: /u01/app/oraInventory/logs/emcadc\_check2017-03-13\_02-26-01-PM.log   
  
  
Enterprise Manager Configuration Assistant END  
Oracle Configuration Manager check START  
OCM check log file location : /u01/app/oraInventory/logs//ocm\_check2384.log  
Oracle Configuration Manager check END  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CHECK OPERATION END \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
  
  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CHECK OPERATION SUMMARY \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
Oracle Grid Infrastructure Home is: /u01/app/11.2.0/grid\_1  
The cluster node(s) on which the Oracle home deinstallation will be performed are:rac3  
Since -local option has been specified, the Oracle home will be deinstalled only on the local node, 'rac3', and the global configuration will be removed.  
Oracle Home selected for deinstall is: /u01/app/oracle/product/11.2.0/db\_1  
Inventory Location where the Oracle home registered is: /u01/app/oraInventory  
The option -local will not modify any database configuration for this Oracle home.  
  
  
No Enterprise Manager configuration to be updated for any database(s)  
No Enterprise Manager ASM targets to update  
No Enterprise Manager listener targets to migrate  
Checking the config status for CCR  
Oracle Home exists with CCR directory, but CCR is not configured  
CCR check is finished  
Do you want to continue (y - yes, n - no)? \[n\]: y  
A log of this session will be written to: '/u01/app/oraInventory/logs/deinstall\_deconfig2017-03-13\_02-25-43-PM.out'  
Any error messages from this session will be written to: '/u01/app/oraInventory/logs/deinstall\_deconfig2017-03-13\_02-25-43-PM.err'  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CLEAN OPERATION START \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
  
  
Enterprise Manager Configuration Assistant START  
  
  
EMCA de-configuration trace file location: /u01/app/oraInventory/logs/emcadc\_clean2017-03-13\_02-26-01-PM.log   
  
  
Updating Enterprise Manager ASM targets (if any)  
Updating Enterprise Manager listener targets (if any)  
Enterprise Manager Configuration Assistant END  
Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc\_clean2017-03-13\_02-26-14-PM.log  
  
  
Network Configuration clean config START  
  
  
Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc\_clean2017-03-13\_02-26-14-PM.log  
  
  
De-configuring Local Net Service Names configuration file...  
Local Net Service Names configuration file de-configured successfully.  
  
  
De-configuring backup files...  
Backup files de-configured successfully.  
  
  
The network configuration has been cleaned up successfully.  
  
  
Network Configuration clean config END  
  
  
Oracle Configuration Manager clean START  
OCM clean log file location : /u01/app/oraInventory/logs//ocm\_clean2384.log  
Oracle Configuration Manager clean END  
Setting the force flag to false  
Setting the force flag to cleanup the Oracle Base  
Oracle Universal Installer clean START  
  
  
Detach Oracle home '/u01/app/oracle/product/11.2.0/db\_1' from the central inventory on the local node : Done  
  
  
Delete directory '/u01/app/oracle/product/11.2.0/db\_1' on the local node : Done  
  
  
Failed to delete the directory '/u01/app/oracle'. The directory is in use.  
Delete directory '/u01/app/oracle' on the local node : Failed <<<<  
  
  
Oracle Universal Installer cleanup completed with errors.  
  
  
Oracle Universal Installer clean END  
  
  
  
  
\#\# \[START\] Oracle install clean \#\#  
  
  
Clean install operation removing temporary directory '/tmp/deinstall2017-03-13\_02-25-14PM' on node 'rac3'  
  
  
\#\# \[END\] Oracle install clean \#\#  
  
  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CLEAN OPERATION END \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
  
  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CLEAN OPERATION SUMMARY \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
Cleaning the config for CCR  
As CCR is not configured, so skipping the cleaning of CCR configuration  
CCR clean is finished  
Successfully detached Oracle home '/u01/app/oracle/product/11.2.0/db\_1' from the central inventory on the local node.  
Successfully deleted directory '/u01/app/oracle/product/11.2.0/db\_1' on the local node.  
Failed to delete directory '/u01/app/oracle' on the local node.  
Oracle Universal Installer cleanup completed with errors.  
  
  
Oracle deinstall tool successfully cleaned up temporary directories.  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
  
  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\# ORACLE DEINSTALL & DECONFIG TOOL END \#\#\#\#\#\#\#\#\#\#\#\#\#

执行完后，rac3的$ORACLE\_HOME目录里的文件已被删除

**9.在任一保留的节点上停止rac3节点NodeApps**

rac1:/home/oracle@rac1>srvctl stop nodeapps -n rac3 -f  //发现rac3的ons和vip 已经停了

**10.在每个保留节点上执行**

rac1:/home/oracle@rac1>$ORACLE\_HOME/oui/bin/runInstaller -updateNodeList ORACLE\_HOME=$ORACLE\_HOME "CLUSTER\_NODES=\{rac1,rac2\}"  
Starting Oracle Universal Installer...  
  
  
Checking swap space: must be greater than 500 MB.   Actual 3194 MB    Passed  
The inventory pointer is located at /etc/oraInst.loc  
The inventory is located at /u01/app/oraInventory  
'UpdateNodeList' was successful.

rac2:/home/oracle@rac2>$ORACLE\_HOME/oui/bin/runInstaller -updateNodeList ORACLE\_HOME=$ORACLE\_HOME "CLUSTER\_NODES=\{rac1,rac2\}"  
Starting Oracle Universal Installer...  
  
  
Checking swap space: must be greater than 500 MB.   Actual 3159 MB    Passed  
The inventory pointer is located at /etc/oraInst.loc  
The inventory is located at /u01/app/oraInventory  
'UpdateNodeList' was successful.

**11.删除rac3节点的集群软件**

\[root@rac3 db\_1\]\# /u01/app/11.2.0/grid\_1/crs/install/rootcrs.pl -deconfig -force  
Using configuration parameter file: /u01/app/11.2.0/grid\_1/crs/install/crsconfig\_params  
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory  
Error occurred during initialization of VM  
java.lang.Error: Properties init: Could not determine current working directory.  
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory  
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac3'  
CRS-2677: Stop of 'ora.registry.acfs' on 'rac3' succeeded  
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory  
2017-03-13 14:37:29.128:   
CLSD:An error was encountered while attempting to open log file "UNKNOWN". Additional diagnostics: (:CLSD00157:)  
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac3'  
CRS-2673: Attempting to stop 'ora.crsd' on 'rac3'  
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac3'  
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac3'  
CRS-2673: Attempting to stop 'ora.FRA\_ARC.dg' on 'rac3'  
CRS-2673: Attempting to stop 'ora.OCR\_VOTING\_NEW.dg' on 'rac3'  
CRS-2673: Attempting to stop 'ora.ACFS.dg' on 'rac3'  
CRS-2673: Attempting to stop 'ora.oc4j' on 'rac3'  
CRS-2677: Stop of 'ora.FRA\_ARC.dg' on 'rac3' succeeded  
CRS-2677: Stop of 'ora.DATA.dg' on 'rac3' succeeded  
CRS-2677: Stop of 'ora.ACFS.dg' on 'rac3' succeeded  
CRS-2677: Stop of 'ora.OCR\_VOTING\_NEW.dg' on 'rac3' succeeded  
CRS-2673: Attempting to stop 'ora.asm' on 'rac3'  
CRS-2677: Stop of 'ora.asm' on 'rac3' succeeded  
CRS-2677: Stop of 'ora.oc4j' on 'rac3' succeeded  
CRS-2672: Attempting to start 'ora.oc4j' on 'rac2'  
CRS-2676: Start of 'ora.oc4j' on 'rac2' succeeded  
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac3' has completed  
CRS-2677: Stop of 'ora.crsd' on 'rac3' succeeded  
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac3'  
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac3'  
CRS-2673: Attempting to stop 'ora.evmd' on 'rac3'  
CRS-2673: Attempting to stop 'ora.asm' on 'rac3'  
CRS-2677: Stop of 'ora.evmd' on 'rac3' succeeded  
CRS-2677: Stop of 'ora.mdnsd' on 'rac3' succeeded  
CRS-2677: Stop of 'ora.ctssd' on 'rac3' succeeded  
CRS-2677: Stop of 'ora.asm' on 'rac3' succeeded  
CRS-2673: Attempting to stop 'ora.cluster\_interconnect.haip' on 'rac3'  
CRS-2677: Stop of 'ora.cluster\_interconnect.haip' on 'rac3' succeeded  
CRS-2673: Attempting to stop 'ora.cssd' on 'rac3'  
CRS-2677: Stop of 'ora.cssd' on 'rac3' succeeded  
CRS-2673: Attempting to stop 'ora.crf' on 'rac3'  
CRS-2677: Stop of 'ora.crf' on 'rac3' succeeded  
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac3'  
CRS-2677: Stop of 'ora.gipcd' on 'rac3' succeeded  
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac3'  
CRS-2677: Stop of 'ora.gpnpd' on 'rac3' succeeded  
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac3' has completed  
CRS-4133: Oracle High Availability Services has been stopped.  
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory  
chdir: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory  
Removing Trace File Analyzer  
Successfully deconfigured Oracle clusterware stack on this node

此时rac3的cluster 进程已被停止

\[root@rac3 ~\]\# su - grid  
\+ASM3:/home/grid@rac3>crs\_stat -t  
CRS-0184: Cannot communicate with the CRS daemon.

**12.删除rac3节点的vip**

如果上一步执行顺利的话，rac3节点的vip此时已被删除，在任一保留节点执行crs\_stat -t 验证一下

\+ASM1:/home/grid@rac1>crs\_stat -t  
Name           Type           Target    State     Host          
\------------------------------------------------------------  
ora.ACFS.dg    ora....up.type ONLINE    ONLINE    rac1          
ora.DATA.dg    ora....up.type ONLINE    ONLINE    rac1          
ora.FRA\_ARC.dg ora....up.type ONLINE    ONLINE    rac1          
ora....ER.lsnr ora....er.type ONLINE    ONLINE    rac1          
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac1          
ora....\_NEW.dg ora....up.type ONLINE    ONLINE    rac1          
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1          
ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac2          
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE                 
ora....network ora....rk.type ONLINE    ONLINE    rac1          
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac2          
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1          
ora.rac.db     ora....se.type ONLINE    ONLINE    rac1          
ora....SM1.asm application    ONLINE    ONLINE    rac1          
ora....C1.lsnr application    ONLINE    ONLINE    rac1          
ora.rac1.gsd   application    OFFLINE   OFFLINE                 
ora.rac1.ons   application    ONLINE    ONLINE    rac1          
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1          
ora....SM2.asm application    ONLINE    ONLINE    rac2          
ora....C2.lsnr application    ONLINE    ONLINE    rac2          
ora.rac2.gsd   application    OFFLINE   OFFLINE                 
ora.rac2.ons   application    ONLINE    ONLINE    rac2          
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2          
ora.rac3.vip   ora....t1.type OFFLINE   OFFLINE                 
ora....ry.acfs ora....fs.type ONLINE    ONLINE    rac1          
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac1

如果仍有rac3节点的vip 服务哎，执行如下:

rac1:/home/oracle@rac1>srvctl stop vip -i ora.rac3.vip -f

rac1:/home/oracle@rac1>srvctl remove vip -i ora.rac3.vip -f

\[root@rac1 ~\]\# crsctl delete resource ora.rac3.vip -f

**13.在任一保留的节点上删除rac3节点**

\[root@rac1 bin\]\# cd /u01/app/11.2.0/grid\_1/bin/  
\[root@rac1 bin\]\# ./crsctl delete node -n rac3  
CRS-4661: Node rac3 successfully deleted.  
\[root@rac1 bin\]\# ./olsnodes -t -s  
rac1Active Unpinned  
rac2Active Unpinned

**14.rac3节点使用grid 用户更新集群列表**

\+ASM3:/home/grid@rac3>$ORACLE\_HOME/oui/bin/runInstaller -updateNodeList ORACLE\_HOME=$ORACLE\_HOME "CLUSTER\_NODES=\{rac3\}" CRS=true -local  
Starting Oracle Universal Installer...  
  
  
Checking swap space: must be greater than 500 MB.   Actual 3988 MB    Passed  
The inventory pointer is located at /etc/oraInst.loc  
The inventory is located at /u01/app/oraInventory  
'UpdateNodeList' was successful.

**15.rac3 节点删除集群软件**

\+ASM3:/home/grid@rac3>$ORACLE\_HOME/deinstall/deinstall -local  
Checking for required files and bootstrapping ...  
Please wait ...  
Location of logs /tmp/deinstall2017-03-16\_02-13-37PM/logs/  
  
  
\#\#\#\#\#\#\#\#\#\#\#\# ORACLE DEINSTALL & DECONFIG TOOL START \#\#\#\#\#\#\#\#\#\#\#\#  
  
  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CHECK OPERATION START \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\#\# \[START\] Install check configuration \#\#  
  
  
  
  
Checking for existence of the Oracle home location /u01/app/11.2.0/grid\_1  
Oracle Home type selected for deinstall is: Oracle Grid Infrastructure for a Cluster  
Oracle Base selected for deinstall is: /u01/app/grid  
Checking for existence of central inventory location /u01/app/oraInventory  
Checking for existence of the Oracle Grid Infrastructure home   
The following nodes are part of this cluster: rac3  
Checking for sufficient temp space availability on node(s) : 'rac3'  
  
  
\#\# \[END\] Install check configuration \#\#  
  
  
Traces log file: /tmp/deinstall2017-03-16\_02-13-37PM/logs//crsdc.log  
Enter an address or the name of the virtual IP used on node "rac3"\[rac3-vip\]  
 >   
  
  
The following information can be collected by running "/sbin/ifconfig -a" on node "rac3"  
Enter the IP netmask of Virtual IP "192.168.180.11" on node "rac3"\[255.255.255.0\]  
 >   
  
  
Enter the network interface name on which the virtual IP address "192.168.180.11" is active  
 >   
  
  
Enter an address or the name of the virtual IP\[\]  
 >   
  
  
  
  
Network Configuration check config START  
  
  
Network de-configuration trace file location: /tmp/deinstall2017-03-16\_02-13-37PM/logs/netdc\_check2017-03-16\_02-14-56-PM.log  
  
  
Specify all RAC listeners (do not include SCAN listener) that are to be de-configured \[LISTENER,LISTENER\_SCAN1\]:  
  
  
Network Configuration check config END  
  
  
Asm Check Configuration START  
  
  
ASM de-configuration trace file location: /tmp/deinstall2017-03-16\_02-13-37PM/logs/asmcadc\_check2017-03-16\_02-15-00-PM.log  
  
  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CHECK OPERATION END \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
  
  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CHECK OPERATION SUMMARY \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
Oracle Grid Infrastructure Home is:   
The cluster node(s) on which the Oracle home deinstallation will be performed are:rac3  
Since -local option has been specified, the Oracle home will be deinstalled only on the local node, 'rac3', and the global configuration will be removed.  
Oracle Home selected for deinstall is: /u01/app/11.2.0/grid\_1  
Inventory Location where the Oracle home registered is: /u01/app/oraInventory  
Following RAC listener(s) will be de-configured: LISTENER,LISTENER\_SCAN1  
Option -local will not modify any ASM configuration.  
Do you want to continue (y - yes, n - no)? \[n\]:   
Exited from program.  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\# ORACLE DEINSTALL & DECONFIG TOOL END \#\#\#\#\#\#\#\#\#\#\#\#\#  
  
  
\+ASM3:/home/grid@rac3>$ORACLE\_HOME/deinstall/deinstall -local  
Checking for required files and bootstrapping ...  
Please wait ...  
Location of logs /tmp/deinstall2017-03-16\_02-15-44PM/logs/  
  
  
\#\#\#\#\#\#\#\#\#\#\#\# ORACLE DEINSTALL & DECONFIG TOOL START \#\#\#\#\#\#\#\#\#\#\#\#  
  
  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CHECK OPERATION START \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\#\# \[START\] Install check configuration \#\#  
  
  
  
  
Checking for existence of the Oracle home location /u01/app/11.2.0/grid\_1  
Oracle Home type selected for deinstall is: Oracle Grid Infrastructure for a Cluster  
Oracle Base selected for deinstall is: /u01/app/grid  
Checking for existence of central inventory location /u01/app/oraInventory  
Checking for existence of the Oracle Grid Infrastructure home   
The following nodes are part of this cluster: rac3  
Checking for sufficient temp space availability on node(s) : 'rac3'  
  
  
\#\# \[END\] Install check configuration \#\#  
  
  
Traces log file: /tmp/deinstall2017-03-16\_02-15-44PM/logs//crsdc.log  
Enter an address or the name of the virtual IP used on node "rac3"\[rac3-vip\]  
 >   
  
  
The following information can be collected by running "/sbin/ifconfig -a" on node "rac3"  
Enter the IP netmask of Virtual IP "192.168.180.11" on node "rac3"\[255.255.255.0\]  
 >   
  
  
Enter the network interface name on which the virtual IP address "192.168.180.11" is active  
 >   
  
  
Enter an address or the name of the virtual IP\[\]  
 >   
  
  
  
  
Network Configuration check config START  
  
  
Network de-configuration trace file location: /tmp/deinstall2017-03-16\_02-15-44PM/logs/netdc\_check2017-03-16\_02-16-13-PM.log  
  
  
Specify all RAC listeners (do not include SCAN listener) that are to be de-configured \[LISTENER,LISTENER\_SCAN1\]:  
  
  
Network Configuration check config END  
  
  
Asm Check Configuration START  
  
  
ASM de-configuration trace file location: /tmp/deinstall2017-03-16\_02-15-44PM/logs/asmcadc\_check2017-03-16\_02-16-18-PM.log  
  
  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CHECK OPERATION END \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
  
  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CHECK OPERATION SUMMARY \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
Oracle Grid Infrastructure Home is:   
The cluster node(s) on which the Oracle home deinstallation will be performed are:rac3  
Since -local option has been specified, the Oracle home will be deinstalled only on the local node, 'rac3', and the global configuration will be removed.  
Oracle Home selected for deinstall is: /u01/app/11.2.0/grid\_1  
Inventory Location where the Oracle home registered is: /u01/app/oraInventory  
Following RAC listener(s) will be de-configured: LISTENER,LISTENER\_SCAN1  
Option -local will not modify any ASM configuration.  
Do you want to continue (y - yes, n - no)? \[n\]: y  
A log of this session will be written to: '/tmp/deinstall2017-03-16\_02-15-44PM/logs/deinstall\_deconfig2017-03-16\_02-16-00-PM.out'  
Any error messages from this session will be written to: '/tmp/deinstall2017-03-16\_02-15-44PM/logs/deinstall\_deconfig2017-03-16\_02-16-00-PM.err'  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CLEAN OPERATION START \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
ASM de-configuration trace file location: /tmp/deinstall2017-03-16\_02-15-44PM/logs/asmcadc\_clean2017-03-16\_02-16-20-PM.log  
ASM Clean Configuration END  
  
  
Network Configuration clean config START  
  
  
Network de-configuration trace file location: /tmp/deinstall2017-03-16\_02-15-44PM/logs/netdc\_clean2017-03-16\_02-16-20-PM.log  
  
  
De-configuring RAC listener(s): LISTENER,LISTENER\_SCAN1  
  
  
De-configuring listener: LISTENER  
    Stopping listener on node "rac3": LISTENER  
    Warning: Failed to stop listener. Listener may not be running.  
Listener de-configured successfully.  
  
  
De-configuring listener: LISTENER\_SCAN1  
    Stopping listener on node "rac3": LISTENER\_SCAN1  
    Warning: Failed to stop listener. Listener may not be running.  
Listener de-configured successfully.  
  
  
De-configuring backup files...  
Backup files de-configured successfully.  
  
  
The network configuration has been cleaned up successfully.  
  
  
Network Configuration clean config END  
  
  
  
  
\---------------------------------------->  
  
  
The deconfig command below can be executed in parallel on all the remote nodes. Execute the command on  the local node after the execution completes on all the remote nodes.  
Remove the directory: /tmp/deinstall2017-03-16\_02-15-44PM on node:   
Setting the force flag to false  
Setting the force flag to cleanup the Oracle Base  
Oracle Universal Installer clean START  
  
  
Detach Oracle home '/u01/app/11.2.0/grid\_1' from the central inventory on the local node : Done  
  
  
Delete directory '/u01/app/11.2.0/grid\_1' on the local node : Done  
  
  
Delete directory '/u01/app/oraInventory' on the local node : Done  
  
  
Failed to delete the directory '/u01/app/grid/oradiag\_root/diag/clients/user\_root/host\_333714774\_80/metadata\_pv'. The directory is in use.  
Failed to delete the directory '/u01/app/grid/oradiag\_root/diag/clients/user\_root/host\_333714774\_80/incident'. The directory is in use.  
Failed to delete the directory '/u01/app/grid/oradiag\_root/diag/clients/user\_root/host\_333714774\_80/metadata\_dgif'. The directory is in use.  
Failed to delete the directory '/u01/app/grid/oradiag\_root/diag/clients/user\_root/host\_333714774\_80/cdump'. The directory is in use.  
Failed to delete the directory '/u01/app/grid/oradiag\_root/diag/clients/user\_root/host\_333714774\_80/stage'. The directory is in use.  
Failed to delete the directory '/u01/app/grid/oradiag\_root/diag/clients/user\_root/host\_333714774\_80/incpkg'. The directory is in use.  
Failed to delete the directory '/u01/app/grid/oradiag\_root/diag/clients/user\_root/host\_333714774\_80/sweep'. The directory is in use.  
The Oracle Base directory '/u01/app/grid' will not be removed on local node. The directory is not empty.  
  
  
Oracle Universal Installer cleanup was successful.  
  
  
Oracle Universal Installer clean END  
  
  
  
  
\#\# \[START\] Oracle install clean \#\#  
  
  
Clean install operation removing temporary directory '/tmp/deinstall2017-03-16\_02-15-44PM' on node 'rac3'  
  
  
\#\# \[END\] Oracle install clean \#\#  
  
  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CLEAN OPERATION END \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
  
  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CLEAN OPERATION SUMMARY \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
Following RAC listener(s) were de-configured successfully: LISTENER,LISTENER\_SCAN1  
Oracle Clusterware was already stopped and de-configured on node "rac3"  
Oracle Clusterware is stopped and de-configured successfully.  
Successfully detached Oracle home '/u01/app/11.2.0/grid\_1' from the central inventory on the local node.  
Successfully deleted directory '/u01/app/11.2.0/grid\_1' on the local node.  
Successfully deleted directory '/u01/app/oraInventory' on the local node.  
Oracle Universal Installer cleanup was successful.  
  
  
  
  
Run 'rm -rf /etc/oraInst.loc' as root on node(s) 'rac3' at the end of the session.  
  
  
Run 'rm -rf /opt/ORCLfmap' as root on node(s) 'rac3' at the end of the session.  
Run 'rm -rf /etc/oratab' as root on node(s) 'rac3' at the end of the session.  
Oracle deinstall tool successfully cleaned up temporary directories.  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
  
  
  
  
\#\#\#\#\#\#\#\#\#\#\#\#\# ORACLE DEINSTALL & DECONFIG TOOL END \#\#\#\#\#\#\#\#\#\#\#\#\#  
  
  
\+ASM3:/home/grid@rac3>

注意上面需要执行一些脚本，按提示执行就可以。

**16.保留节点使用grid用户更新集群列表**

\[root@rac1 ~\]\# su - grid  
\+ASM1:/home/grid@rac1>$ORACLE\_HOME/oui/bin/runInstaller -updateNodeList ORACLE\_HOME=$ORACLE\_HOME "CLUSTER\_NODES=\{rac1,rac2\}" CRS=true  
Starting Oracle Universal Installer...  
  
  
Checking swap space: must be greater than 500 MB.   Actual 3183 MB    Passed  
The inventory pointer is located at /etc/oraInst.loc  
The inventory is located at /u01/app/oraInventory  
'UpdateNodeList' was successful.

root@rac2 ~\]\# su - grid  
\+ASM2:/home/grid@rac2>$ORACLE\_HOME/oui/bin/runInstaller -updateNodeList ORACLE\_HOME=$ORACLE\_HOME "CLUSTER\_NODES=\{rac1,rac2\}" CRS=true  
Starting Oracle Universal Installer...  
  
  
Checking swap space: must be greater than 500 MB.   Actual 3156 MB    Passed  
The inventory pointer is located at /etc/oraInst.loc  
The inventory is located at /u01/app/oraInventory  
'UpdateNodeList' was successful.

**17.验证rac3节点被删除**

在任一保留的节点上执行

\+ASM1:/home/grid@rac1>cluvfy stage -post nodedel -n rac3  
  
  
Performing post-checks for node removal   
  
  
Checking CRS integrity...  
  
  
Clusterware version consistency passed  
  
  
CRS integrity check passed  
  
  
Node removal check passed  
  
  
Post-check for node removal was successful.

\+ASM1:/home/grid@rac1>crsctl stat res -t  
\--------------------------------------------------------------------------------  
NAME           TARGET  STATE        SERVER                   STATE\_DETAILS         
\--------------------------------------------------------------------------------  
Local Resources  
\--------------------------------------------------------------------------------  
ora.ACFS.dg  
               ONLINE  ONLINE       rac1                                           
               ONLINE  ONLINE       rac2                                           
ora.DATA.dg  
               ONLINE  ONLINE       rac1                                           
               ONLINE  ONLINE       rac2                                           
ora.FRA\_ARC.dg  
               ONLINE  ONLINE       rac1                                           
               ONLINE  ONLINE       rac2                                           
ora.LISTENER.lsnr  
               ONLINE  OFFLINE      rac1                                           
               ONLINE  OFFLINE      rac2                                           
ora.OCR\_VOTING\_NEW.dg  
               ONLINE  ONLINE       rac1                                           
               ONLINE  ONLINE       rac2                                           
ora.asm  
               ONLINE  ONLINE       rac1                     Started               
               ONLINE  ONLINE       rac2                     Started               
ora.gsd  
               OFFLINE OFFLINE      rac1                                           
               OFFLINE OFFLINE      rac2                                           
ora.net1.network  
               OFFLINE OFFLINE      rac1                                           
               OFFLINE OFFLINE      rac2                                           
ora.ons  
               OFFLINE OFFLINE      rac1                                           
               OFFLINE OFFLINE      rac2                                           
ora.registry.acfs  
               ONLINE  ONLINE       rac1                                           
               ONLINE  ONLINE       rac2                                           
\--------------------------------------------------------------------------------  
Cluster Resources  
\--------------------------------------------------------------------------------  
ora.LISTENER\_SCAN1.lsnr  
      1        OFFLINE OFFLINE                                                     
ora.cvu  
      1        OFFLINE OFFLINE                                                     
ora.oc4j  
      1        ONLINE  ONLINE       rac2                                           
ora.rac.db  
      1        ONLINE  ONLINE       rac1                     Open                  
      2        ONLINE  ONLINE       rac2                     Open                  
ora.rac1.vip  
      1        OFFLINE OFFLINE                                                     
ora.rac2.vip  
      1        OFFLINE OFFLINE                                                     
ora.rac3.vip  
      1        OFFLINE OFFLINE                                                     
ora.scan1.vip  
      1        OFFLINE OFFLINE                                                     
验证rac3节点被删除

查看活动的实例

SQL> select thread\#,status,instance from v$thread;  
  
  
   THREAD\# STATUS  
\---------- ------  
INSTANCE  
\--------------------------------------------------------------------------------  
1 OPEN  
rac1  
  
  
2 OPEN  
rac2  
  
  
  
  
SQL>

至此rac 集群下删除节点完成

[Center]: /images/20220708/3508b89dfa05470abb10b78131285ca9.png
[Center 1]: /images/20220708/76ab4117df2d4979acae1bb5aa3666e2.png
[Center 2]: /images/20220708/740e4813a64a4af687c4c88f3c5486eb.png
[Center 3]: /images/20220708/d3e073d045094d028b1a89bf6a5a296e.png
[Center 4]: /images/20220708/04f5864f4103456aa683c071c746080d.png
[Center 5]: /images/20220708/c6fb42bcc7bf49b69dcab26022196864.png
[Center 6]: /images/20220708/f6b6c2ba20af4d379f719d67539f6b19.png
[Center 7]: /images/20220708/302f57f52da443ac85fa64405a5f23f6.png
[Center 8]: /images/20220708/01e39a15e3994f898b6c781bbd83f159.png
[Center 9]: /images/20220708/19d86bf10c8348e1a165b782da196dd7.png

发表评论取消回复

表情：

评论列表（有 0 条评论，261人围观）

还没有评论，来说两句吧...

相关阅读

相关 Oracle RAC环境下的节点故障影响分析

在Oracle Real Application Cluster（RAC）环境中，每个节点都承担着数据库的部分功能。因此，如果某个节点发生故障，其可能对系统造成以下影响： 1

刺骨的言语ヽ痛彻心扉/ 2024年12月21日 22:51/ 0 赞/ 9 阅读

相关 Oracle RAC环境下，主节点故障问题：现象、原因及处理方法

在Oracle Real Application Cluster（RAC）环境中，如果遇到主节点（M Node）故障的问题，以下是可能出现的现象、原因以及处理方法：现象：

电玩女神/ 2024年12月19日 23:51/ 0 赞/ 14 阅读

相关 Oracle RAC环境下，主节点宕机后重启问题案例

在Oracle Real Application Cluster（RAC）环境中，如果主节点发生宕机并重新启动，可能会出现以下一些具体案例和问题： 1. **数据库初始化**

缺乏、安全感/ 2024年12月16日 03:48/ 0 赞/ 10 阅读

相关 Oracle RAC 主备切换实验（主库双节点RAC到单节点备库）

本实验环境如下：主库Oracle RAC双节点 node1 192.168.169.111 node2 192.168.169.222 备库为Oracle单节点

深碍√TFBOYSˉ_/ 2023年06月27日 03:08/ 0 赞/ 9 阅读

相关 Oracle RAC下删除节点

1.测试环境： OS:Centos 6.8 Oralce:11.2.0.4 3节点RAC，主机名是rac1,rac2,rac3 现在需要删除rac3 3个节点实例均正

左手的ㄟ右手/ 2022年09月30日 07:31/ 0 赞/ 262 阅读

相关 Oracle 11g rac 添加新节点测试

前期准备：操作系统设置 OS版本必须相同，检查内核参数，系统内存、CPU、文件系统大小、swap空间等。创建必要的用户及组用户及用户组UID及GID必须跟其他节点

﹏ヽ暗。殇╰゛Y/ 2022年09月27日 12:30/ 0 赞/ 18 阅读

相关 Oracle RAC环境下配置statspack

Statspack是Oracle 9i时代的产物，对于监控与分析数据库性能有着跨里程碑的意义，是AWR的前身。在Oracle 10g后AWR取代了statspack。尽

﹏ヽ暗。殇╰゛Y/ 2022年08月12日 14:29/ 0 赞/ 225 阅读

相关 oracle11g r2 rac环境删除节点步骤

oracle11g r2 rac环境删除节点步骤 1.移除数据库实例如果节点运行了service首先需要删除service 使用dbca图形化界面删除节点依

女爷i/ 2022年08月06日 15:05/ 0 赞/ 323 阅读

相关 Oracle Study之--Oracle 11g RAC添加节点错误

Oracle Study之--Oracle 11g RAC添加节点错误系统环境：操作系统：RedHat EL5 Cluster： Orac

秒速五厘米/ 2022年08月05日 02:51/ 0 赞/ 252 阅读

相关 oracle rac 12c新增节点

\rac新增加节点执行 ssh配置（grid用户和oracle都需要配置） su - grid cd $HOME mkdir .ssh chmod 700 .s

川长思鸟来/ 2022年06月17日 06:49/ 0 赞/ 317 阅读