oracle11g r2 rac环境删除节点步骤

女爷i 2022-08-06 15:05 261阅读 0赞

oracle11g r2 rac环境删除节点步骤  
1.移除数据库实例  
如果节点运行了service首先需要删除service  
使用dbca图形化界面删除节点  
依次选择 Real Application Clusters -- > Instance Management --- > Delete Instance.Accept the alert windows to delete the   
也可以使用静默方式删除实例(在其他节点执行)  
dbca -silent -deleteInstance \[-nodeList node\_name\] -gdbName gdb\_name  
\-instanceName instance\_name -sysDBAUserName sysdba -sysDBAPassword password  
node\_name  是删除节点名  
gdb\_name   是全局数据库名  
instance   是删除的实例名  
sysdba     是拥有sysdba权限的oracle用户名称  
passwd     是sysdba用户的密码  
rac1-> dbca -silent -deleteInstance -nodeList rac3 -gdbName orcl -instanceName orcl3 -sysDBAUserName sys -sysDBAPassword oracle  
Deleting instance  
1% complete  
2% complete  
6% complete  
13% complete  
20% complete  
26% complete  
33% complete  
40% complete  
46% complete  
53% complete  
60% complete  
66% complete  
Completing instance management.  
100% complete  
Look at the log file "/oracle/app/oracle/cfgtoollogs/dbca/orcl.log" for further details.  
  
  
确认删除实例节点的thread是否disable 如果不是执行disable  
ALTER DATABASE DISABLE THREAD 3;  
确认实例从ocr中移除  
srvctl config database -d db\_unique\_name  
\[root@rac1 ~\]\# su - grid  
rac1->  srvctl config database -d orcl  
Database unique name: orcl  
Database name: orcl  
Oracle home: /oracle/app/oracle/product/11.2.0/db\_1  
Oracle user: oracle  
Spfile: +DATADG/orcl/spfileorcl.ora  
Domain:   
Start options: open  
Stop options: immediate  
Database role: PRIMARY  
Management policy: AUTOMATIC  
Server pools: orcl  
Database instances: orcl1,orcl2  
Disk Groups: DATADG  
Mount point paths:   
Services:   
Type: RAC  
Database is administrator managed  
rac1->   
2.卸载节点数据库软件  
步骤1禁用和停止监听  
$ srvctl disable listener -l listener\_name -n name\_of\_node\_to\_delete  
$ srvctl stop listener -l listener\_name -n name\_of\_node\_to\_delete  
步骤2 更新inventory目录  
在要删除节点的$ORACLE\_HOME/oui/bin目录下执行  
$ ./runInstaller -updateNodeList ORACLE\_HOME=Oracle\_home\_location  
"CLUSTER\_NODES=\{name\_of\_node\_to\_delete\}" -local  
rac3-> ./runInstaller -updateNodeList ORACLE\_HOME=/oracle/app/oracle/product/11.2.0/db\_1 "CLUSTER\_NODES=\{rac3\}" -local  
Starting Oracle Universal Installer...  
Checking swap space: must be greater than 500 MB.   Actual 2998 MB    Passed  
The inventory pointer is located at /etc/oraInst.loc  
The inventory is located at /oracle/app/oraInventory  
'UpdateNodeList' was successful.  
步骤3 移除节点  
在删除节点$ORACLE\_HOME/deinstall目下执行  
./deinstall -local  
步骤4更新其他的节点的inventory  
在集群的其节点上 $ORACLE\_HOME/oui/bin目录下执行  
$ ./runInstaller -updateNodeList ORACLE\_HOME=Oracle\_home\_location  
"CLUSTER\_NODES=\{remaining\_node\_list\}"  
rac1-> ./runInstaller -updateNodeList ORACLE\_HOME=/oracle/app/oracle/product/11.2.0/db\_1 "CLUSTER\_NODES=\{rac1,rac2\}"  
Starting Oracle Universal Installer...  
Checking swap space: must be greater than 500 MB.   Actual 2999 MB    Passed  
The inventory pointer is located at /etc/oraInst.loc  
The inventory is located at /oracle/app/oraInventory  
'UpdateNodeList' was successful.  
rac1->   
3.卸载节点的clusterware软件  
步骤1确保所有节点的$GRID\_HOME环境变量配置正确  
步骤2查看删除节点是否为pined状态（root用户或者grid用户查看）  
$ olsnodes -s –t  
如果节点是pined状态，请执行以下命令（root用户执行）  
\# crsctl unpin css -n node\_to\_be\_deleted  
步骤3 在要删除节点的 Grid\_home/crs/install目录下 运行 rootcrs.pl脚本（root用户执行）  
\#./rootcrs.pl -deconfig -force  
\[root@rac3 install\]\# ./rootcrs.pl -deconfig -force  
Using configuration parameter file: ./crsconfig\_params  
缃缁瀛濞: 1/192.168.56.0/255.255.255.0/eth0, 绫诲 static  
VIP 瀛濞: /rac1-vip/192.168.56.2/192.168.56.0/255.255.255.0/eth0, 骁桤?rac1  
VIP 瀛濞: /rac2-vip/192.168.56.3/192.168.56.0/255.255.255.0/eth0, 骁桤?rac2  
VIP 瀛濞: /192.168.56.4/192.168.56.4/192.168.56.0/255.255.255.0/eth0, 骁桤?rac3  
GSD 宸插?  
ONS 瀛濞: 娆灏绔?6100, 杩绋绔?6200, EM 绔?2016  
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.oc4j' on 'rac3'  
CRS-2673: Attempting to stop 'ora.DATADG.dg' on 'rac3'  
CRS-2673: Attempting to stop 'ora.GRIDDATA.dg' on 'rac3'  
CRS-2677: Stop of 'ora.DATADG.dg' on 'rac3' succeeded  
CRS-2677: Stop of 'ora.oc4j' on 'rac3' succeeded  
CRS-2672: Attempting to start 'ora.oc4j' on 'rac1'  
CRS-2677: Stop of 'ora.GRIDDATA.dg' on 'rac3' succeeded  
CRS-2673: Attempting to stop 'ora.asm' on 'rac3'  
CRS-2677: Stop of 'ora.asm' on 'rac3' succeeded  
CRS-2676: Start of 'ora.oc4j' on 'rac1' 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.ctssd' on 'rac3' succeeded  
CRS-2677: Stop of 'ora.mdnsd' 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.  
Removing Trace File Analyzer  
Successfully deconfigured Oracle clusterware stack on this node  
步骤4 在保留节点的Grid\_home/bin目录下运行如下命令在集群中删除节点（root用户执行）  
\# crsctl delete node -n node\_to\_be\_deleted  
\[root@rac1 bin\]\# ./crsctl delete node -n rac3  
CRS-4661: Node rac3 successfully deleted.  
步骤5 在删除节点节点的Grid\_home/oui/bin目录下执行脚本（grid用户执行）  
$ ./runInstaller -updateNodeList ORACLE\_HOME=Grid\_home "CLUSTER\_NODES=  
\{node\_to\_be\_deleted\}" CRS=TRUE -local  
rac3->./runInstaller -updateNodeList ORACLE\_HOME=/oracle/app/11.2.0/grid "CLUSTER\_NODES=\{rac3\}" CRS=TRUE -local  
Starting Oracle Universal Installer...  
Checking swap space: must be greater than 500 MB.   Actual 2999 MB    Passed  
The inventory pointer is located at /etc/oraInst.loc  
The inventory is located at /oracle/app/oraInventory  
'UpdateNodeList' was successful.  
步骤6 在删除节点执行的目录下 Grid\_home/deinstall的deinstall脚本删除cluster软件  
$ ./deinstall –local  
rac3-> export LANG=C  
rac3->  ./deinstall –locl  
Checking for required files and bootstrapping ...  
Please wait ...  
Location of logs /tmp/deinstall2015-02-03\_03-07-18PM/logs/  
\#\#\#\#\#\#\#\#\#\#\#\# ORACLE DEINSTALL & DECONFIG TOOL START \#\#\#\#\#\#\#\#\#\#\#\#  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CHECK OPERATION START \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\#\# \[START\] Install check configuration \#\#  
Checking for existence of the Oracle home location /oracle/app/11.2.0/grid  
Oracle Home type selected for deinstall is: Oracle Grid Infrastructure for a Cluster  
Oracle Base selected for deinstall is: /oracle/app/grid  
Checking for existence of central inventory location /oracle/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/deinstall2015-02-03\_03-07-18PM/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.56.4" on node "rac3"\[255.255.255.0\]  
 >   
Enter the network interface name on which the virtual IP address "192.168.56.4" is active  
 >   
Enter an address or the name of the virtual IP\[\]  
 >   
Network Configuration check config START  
Network de-configuration trace file location: /tmp/deinstall2015-02-03\_03-07-18PM/logs/netdc\_check2015-02-03\_03-08-29-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/deinstall2015-02-03\_03-07-18PM/logs/asmcadc\_check2015-02-03\_03-08-53-PM.log  
ASM configuration was not detected in this Oracle home. Was ASM configured in this Oracle home (y|n) \[n\]: y  
Is OCR/Voting Disk placed in ASM y|n \[n\]: y  
Enter the OCR/Voting Disk diskgroup name \[\]:   
Specify the ASM Diagnostic Destination \[ \]:   
Specify the diskstring \[\]:   
Specify the diskgroups that are managed by this ASM instance \[\]:   
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# 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  
Oracle Home selected for deinstall is: /oracle/app/11.2.0/grid  
Inventory Location where the Oracle home registered is: /oracle/app/oraInventory  
Following RAC listener(s) will be de-configured: LISTENER,LISTENER\_SCAN1  
ASM instance will be de-configured from this Oracle home  
Do you want to continue (y - yes, n - no)? \[n\]: y  
A log of this session will be written to: '/tmp/deinstall2015-02-03\_03-07-18PM/logs/deinstall\_deconfig2015-02-03\_03-07-25-PM.out'  
Any error messages from this session will be written to: '/tmp/deinstall2015-02-03\_03-07-18PM/logs/deinstall\_deconfig2015-02-03\_03-07-25-PM.err'  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CLEAN OPERATION START \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
ASM de-configuration trace file location: /tmp/deinstall2015-02-03\_03-07-18PM/logs/asmcadc\_clean2015-02-03\_03-09-46-PM.log  
ASM Clean Configuration START  
ASM Clean Configuration END  
Network Configuration clean config START  
Network de-configuration trace file location: /tmp/deinstall2015-02-03\_03-07-18PM/logs/netdc\_clean2015-02-03\_03-09-49-PM.log  
De-configuring RAC listener(s): LISTENER,LISTENER\_SCAN1  
De-configuring listener: LISTENER  
    Stopping listener: LISTENER  
    Warning: Failed to stop listener. Listener may not be running.  
Listener de-configured successfully.  
De-configuring listener: LISTENER\_SCAN1  
    Stopping listener: 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.  
Run the following command as the root user or the administrator on node "rac3".  
/tmp/deinstall2015-02-03\_03-07-18PM/perl/bin/perl -I/tmp/deinstall2015-02-03\_03-07-18PM/perl/lib -I/tmp/deinstall2015-02-03\_03-07-18PM/crs/install /tmp/deinstall2015-02-03\_03-07-18PM/crs/install/rootcrs.pl -force  -deconfig -paramfile "/tmp/deinstall2015-02-03\_03-07-18PM/response/deinstall\_Ora11g\_gridinfrahome1.rsp" -lastnode  
Press Enter after you finish running the above commands  
<----------------------------------------  
Remove the directory: /tmp/deinstall2015-02-03\_03-07-18PM 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 '/oracle/app/11.2.0/grid' from the central inventory on the local node : Done  
Delete directory '/oracle/app/11.2.0/grid' on the local node : Done  
Delete directory '/oracle/app/oraInventory' on the local node : Done  
Delete directory '/oracle/app/grid' on the local node : Done  
Oracle Universal Installer cleanup was successful.  
Oracle Universal Installer clean END  
\#\# \[START\] Oracle install clean \#\#  
Clean install operation removing temporary directory '/tmp/deinstall2015-02-03\_03-07-18PM' on node 'rac3'  
\#\# \[END\] Oracle install clean \#\#  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CLEAN OPERATION END \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# CLEAN OPERATION SUMMARY \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
ASM instance was de-configured successfully from the Oracle home  
Following RAC listener(s) were de-configured successfully: LISTENER,LISTENER\_SCAN1  
Oracle Clusterware is stopped and successfully de-configured on node "rac3"  
Oracle Clusterware is stopped and de-configured successfully.  
Successfully detached Oracle home '/oracle/app/11.2.0/grid' from the central inventory on the local node.  
Successfully deleted directory '/oracle/app/11.2.0/grid' on the local node.  
Successfully deleted directory '/oracle/app/oraInventory' on the local node.  
Successfully deleted directory '/oracle/app/grid' 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 \#\#\#\#\#\#\#\#\#\#\#\#\#  
rac3->   
步骤7 在保留节点的 Grid\_home/oui/bin 目录下执行runInstaller更新inventory  
$ ./runInstaller -updateNodeList ORACLE\_HOME=Grid\_home  
"CLUSTER\_NODES=\{remaining\_nodes\_list\}" CRS=TRUE  
rac1-> ./runInstaller -updateNodeList ORACLE\_HOME=/oracle/app/11.2.0/grid "CLUSTER\_NODES=\{rac1,rac2\}" CRS=TRUE  
Starting Oracle Universal Installer...  
Checking swap space: must be greater than 500 MB.   Actual 2996 MB    Passed  
The inventory pointer is located at /etc/oraInst.loc  
The inventory is located at /oracle/app/oraInventory  
'UpdateNodeList' was successful.  
步骤8 在保留节点上执行验证节点是否删除成功  
$ cluvfy stage -post nodedel -n node\_list \[-verbose\]  
rac1-> cluvfy stage -post nodedel -n rac3 -verbose  
Performing post-checks for node removal   
Checking CRS integrity...  
Clusterware version consistency passed  
The Oracle Clusterware is healthy on node "rac2"  
The Oracle Clusterware is healthy on node "rac1"  
CRS integrity check passed  
Result:   
Node removal check passed  
Post-check for node removal was successful.   
rac1->