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->
--转自