oracle 12c rac 的删除

rdbms 12.1.0.2

OS redhat 7.4 (三个节点)

参考文档：

https://docs.oracle.com/database/121/LADBI/remove_oracle_sw.htm#LADBI7828

10.3 Example of Running the Deinstall Command

If you run the deinstallation tool using the deinstall command from the $ORACLE_HOME/deinstall directory, then the deinstallation starts without prompting you for the Oracle home path.

Use the optional flag -paramfile to provide a path to a response file.

In the following example, the deinstall command is in the path /u01/app/oracle/product/12.1.0/dbhome_1/deinstall, and it uses a response file in the software owner location /home/usr/oracle:

$ cd /u01/app/oracle/product/12.1.0/dbhome_1/deinstall
$ ./deinstall -paramfile /home/usr/oracle/my_db_paramfile.tmpl

For the Oracle Grid Infrastructure home, use the deinstallation script in the Oracle Grid Infrastructure for a standalone server home, which in this example is /u01/app/oracle/product/12.1.0/grid:

$ cd /u01/app/oracle/product/12.1.0/grid/deinstall
$ ./deinstall -paramfile /home/usr/oracle/my_grid_paramfile.tmpl

步骤

1 使用dbca删除数据库

2  删除oracle软件，在oracle用户下，$oracle_home/deinstall

3 在grid 用户下(没有停止集群)，$oracle_home/deinstall

过程

1 dbca 删除数据库，略。

2 删除Oracle软件，在其中一个节点执行就可以了，会把远程节点的oracle软件删除掉。删除结果如下：

######################### DEINSTALL CLEAN OPERATION END #########################


####################### DEINSTALL CLEAN OPERATION SUMMARY #######################
Successfully detached Oracle home '/u01/app/oracle/product/12.1.0/db_1' from the central inventory on the local node.
Successfully deleted directory '/u01/app/oracle/product/12.1.0/db_1' on the local node.
Failed to delete directory '/u01/app/oracle' on the local node.
Successfully detached Oracle home '/u01/app/oracle/product/12.1.0/db_1' from the central inventory on the remote nodes 'rac01,rac02'.
Successfully deleted directory '/u01/app/oracle/product/12.1.0/db_1' on the remote nodes 'rac01,rac02'.
Failed to delete directory '/u01/app/oracle' on the remote nodes 'rac02'.
Oracle Universal Installer cleanup completed with errors.

Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################


############# ORACLE DEINSTALL TOOL END #############

3 删除grid 软件，在其中一个节点执行就可以了，会把其他节点的软件删除掉。在删除过程中，会要求额外执行一些命令，执行就可以了。删除完毕后，会要求删除掉一些目录。执行即可。

提示要执行的命令，执行完毕后回车即可。

---------------------------------------->

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 "rac02".

/tmp/deinstall2019-10-09_08-20-19AM/perl/bin/perl -I/tmp/deinstall2019-10-09_08-20-19AM/perl/lib -I/tmp/deinstall2019-10-09_08-20-19AM/crs/install /tmp/deinstall2019-10-09_08-20-19AM/crs/install/rootcrs.pl -force  -deconfig -paramfile "/tmp/deinstall2019-10-09_08-20-19AM/response/deinstall_OraGI12Home1.rsp"

Run the following command as the root user or the administrator on node "rac01".

/tmp/deinstall2019-10-09_08-20-19AM/perl/bin/perl -I/tmp/deinstall2019-10-09_08-20-19AM/perl/lib -I/tmp/deinstall2019-10-09_08-20-19AM/crs/install /tmp/deinstall2019-10-09_08-20-19AM/crs/install/rootcrs.pl -force  -deconfig -paramfile "/tmp/deinstall2019-10-09_08-20-19AM/response/deinstall_OraGI12Home1.rsp"

Run the following command as the root user or the administrator on node "rac03".

/tmp/deinstall2019-10-09_08-20-19AM/perl/bin/perl -I/tmp/deinstall2019-10-09_08-20-19AM/perl/lib -I/tmp/deinstall2019-10-09_08-20-19AM/crs/install /tmp/deinstall2019-10-09_08-20-19AM/crs/install/rootcrs.pl -force  -deconfig -paramfile "/tmp/deinstall2019-10-09_08-20-19AM/response/deinstall_OraGI12Home1.rsp" -lastnode

Press Enter after you finish running the above commands

三个节点的命令执行过程

[[email protected] ~]# /tmp/deinstall2019-10-09_08-20-19AM/perl/bin/perl -I/tmp/deinstall2019-10-09_08-20-19AM/perl/lib -I/tmp/deinstall2019-10-09_08-20-19AM/crs/install /tmp/deinstall2019-10-09_08-20-19AM/crs/install/rootcrs.pl -force  -deconfig -paramfile "/tmp/deinstall2019-10-09_08-20-19AM/response/deinstall_OraGI12Home1.rsp"
Using configuration parameter file: /tmp/deinstall2019-10-09_08-20-19AM/response/deinstall_OraGI12Home1.rsp
Network 1 exists
Subnet IPv4: 192.168.54.0/255.255.255.0/ens192, static
Subnet IPv6: 
Ping Targets: 
Network is enabled
Network is individually enabled on nodes: 
Network is individually disabled on nodes: 
VIP exists: network number 1, hosting node rac01
VIP Name: rac01-vip
VIP IPv4 Address: 192.168.54.97
VIP IPv6 Address: 
VIP is enabled.
VIP is individually enabled on nodes: 
VIP is individually disabled on nodes: 
VIP exists: network number 1, hosting node rac02
VIP Name: rac02-vip
VIP IPv4 Address: 192.168.54.99
VIP IPv6 Address: 
VIP is enabled.
VIP is individually enabled on nodes: 
VIP is individually disabled on nodes: 
VIP exists: network number 1, hosting node rac03
VIP Name: rac03-vip
VIP IPv4 Address: 192.168.54.71
VIP IPv6 Address: 
VIP is enabled.
VIP is individually enabled on nodes: 
VIP is individually disabled on nodes: 
ONS exists: Local port 6100, remote port 6200, EM port 2016, Uses SSL false
ONS is enabled
ONS is individually enabled on nodes: 
ONS is individually disabled on nodes: 
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac02'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac02'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac02'
CRS-2673: Attempting to stop 'ora.asm' on 'rac02'
CRS-2673: Attempting to stop 'ora.oc4j' on 'rac02'
CRS-2673: Attempting to stop 'ora.MGMTLSNR' on 'rac02'
CRS-2677: Stop of 'ora.MGMTLSNR' on 'rac02' succeeded
CRS-2672: Attempting to start 'ora.MGMTLSNR' on 'rac03'
CRS-2677: Stop of 'ora.asm' on 'rac02' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac02'
CRS-2672: Attempting to start 'ora.asm' on 'rac01'
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac02' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'rac02' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'rac03'
CRS-2676: Start of 'ora.MGMTLSNR' on 'rac03' succeeded
CRS-2676: Start of 'ora.oc4j' on 'rac03' succeeded
CRS-2676: Start of 'ora.asm' on 'rac01' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac02' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac02' succeeded
CRS-2673: Attempting to stop 'ora.storage' on 'rac02'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac02'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac02'
CRS-2677: Stop of 'ora.storage' on 'rac02' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'rac02'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac02'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac02'
CRS-2673: Attempting to stop 'ora.asm' on 'rac02'
CRS-2677: Stop of 'ora.gpnpd' on 'rac02' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac02' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac02' succeeded
CRS-2677: Stop of 'ora.crf' on 'rac02' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac02' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac02' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac02'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac02' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac02'
CRS-2677: Stop of 'ora.cssd' on 'rac02' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac02'
CRS-2677: Stop of 'ora.gipcd' on 'rac02' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac02' has completed
CRS-4133: Oracle High Availability Services has been stopped.
2019/10/09 08:27:28 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector.

2019/10/09 08:29:20 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector.

2019/10/09 08:30:10 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node

2019/10/09 08:30:13 CLSRSC-46: Error: '/u01/app/grid/crsdata/rac02/crsconfig/cluutil2.log' does not exist

2019/10/09 08:30:14 CLSRSC-46: Error: '/u01/app/grid/crsdata/rac02/crsconfig/cluutil2.log' does not exist

[[email protected] ~]# 

[[email protected] ~]# /tmp/deinstall2019-10-09_08-20-19AM/perl/bin/perl -I/tmp/deinstall2019-10-09_08-20-19AM/perl/lib -I/tmp/deinstall2019-10-09_08-20-19AM/crs/install /tmp/deinstall2019-10-09_08-20-19AM/crs/install/rootcrs.pl -force  -deconfig -paramfile "/tmp/deinstall2019-10-09_08-20-19AM/response/deinstall_OraGI12Home1.rsp"
Using configuration parameter file: /tmp/deinstall2019-10-09_08-20-19AM/response/deinstall_OraGI12Home1.rsp
Network 1 exists
Subnet IPv4: 192.168.54.0/255.255.255.0/ens192, static
Subnet IPv6: 
Ping Targets: 
Network is enabled
Network is individually enabled on nodes: 
Network is individually disabled on nodes: 
VIP exists: network number 1, hosting node rac01
VIP Name: rac01-vip
VIP IPv4 Address: 192.168.54.97
VIP IPv6 Address: 
VIP is enabled.
VIP is individually enabled on nodes: 
VIP is individually disabled on nodes: 
VIP exists: network number 1, hosting node rac03
VIP Name: rac03-vip
VIP IPv4 Address: 192.168.54.71
VIP IPv6 Address: 
VIP is enabled.
VIP is individually enabled on nodes: 
VIP is individually disabled on nodes: 
ONS exists: Local port 6100, remote port 6200, EM port 2016, Uses SSL false
ONS is enabled
ONS is individually enabled on nodes: 
ONS is individually disabled on nodes: 
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac01'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac01'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac01'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'rac01'
CRS-2677: Stop of 'ora.OCR.dg' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac01'
CRS-2677: Stop of 'ora.asm' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac01'
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac01' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac01' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.storage' on 'rac01'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac01'
CRS-2673: Attempting to stop 'ora.crf' on 'rac01'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac01'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac01'
CRS-2677: Stop of 'ora.storage' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac01'
CRS-2677: Stop of 'ora.ctssd' on 'rac01' succeeded
CRS-2677: Stop of 'ora.crf' on 'rac01' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac01' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'rac01' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac01'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'rac01'
CRS-2677: Stop of 'ora.evmd' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac01'
CRS-2677: Stop of 'ora.cssd' on 'rac01' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac01'
CRS-2677: Stop of 'ora.gipcd' on 'rac01' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
2019/10/09 08:29:51 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector.

2019/10/09 08:31:45 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector.

2019/10/09 08:32:37 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node

2019/10/09 08:32:40 CLSRSC-46: Error: '/u01/app/grid/crsdata/rac01/crsconfig/cluutil2.log' does not exist

2019/10/09 08:32:40 CLSRSC-46: Error: '/u01/app/grid/crsdata/rac01/crsconfig/cluutil2.log' does not exist

[[email protected] ~]# 

[[email protected] ~]# /tmp/deinstall2019-10-09_08-20-19AM/perl/bin/perl -I/tmp/deinstall2019-10-09_08-20-19AM/perl/lib -I/tmp/deinstall2019-10-09_08-20-19AM/crs/install /tmp/deinstall2019-10-09_08-20-19AM/crs/install/rootcrs.pl -force  -deconfig -paramfile "/tmp/deinstall2019-10-09_08-20-19AM/response/deinstall_OraGI12Home1.rsp" -lastnode
Using configuration parameter file: /tmp/deinstall2019-10-09_08-20-19AM/response/deinstall_OraGI12Home1.rsp

Network 1 exists
Subnet IPv4: 192.168.54.0/255.255.255.0/ens192, static
Subnet IPv6: 
Ping Targets: 
Network is enabled
Network is individually enabled on nodes: 
Network is individually disabled on nodes: 
VIP exists: network number 1, hosting node rac03
VIP Name: rac03-vip
VIP IPv4 Address: 192.168.54.71
VIP IPv6 Address: 
VIP is enabled.
VIP is individually enabled on nodes: 
VIP is individually disabled on nodes: 
ONS exists: Local port 6100, remote port 6200, EM port 2016, Uses SSL false
ONS is enabled
ONS is individually enabled on nodes: 
ONS is individually disabled on nodes: 
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac03'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac03'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac03'
CRS-2673: Attempting to stop 'ora.asm' on 'rac03'
CRS-2673: Attempting to stop 'ora.MGMTLSNR' on 'rac03'
CRS-2677: Stop of 'ora.MGMTLSNR' on 'rac03' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac03'
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac03' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac03' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac03'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac03'
CRS-2673: Attempting to stop 'ora.storage' on 'rac03'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac03'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac03'
CRS-2677: Stop of 'ora.storage' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac03'
CRS-2677: Stop of 'ora.ctssd' on 'rac03' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac03' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac03' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'rac03' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac03'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac03'
CRS-2677: Stop of 'ora.cssd' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'rac03'
CRS-2677: Stop of 'ora.crf' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac03'
CRS-2677: Stop of 'ora.gipcd' on 'rac03' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac03' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.evmd' on 'rac03'
CRS-2672: Attempting to start 'ora.mdnsd' on 'rac03'
CRS-2676: Start of 'ora.mdnsd' on 'rac03' succeeded
CRS-2676: Start of 'ora.evmd' on 'rac03' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'rac03'
CRS-2676: Start of 'ora.gpnpd' on 'rac03' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac03'
CRS-2672: Attempting to start 'ora.gipcd' on 'rac03'
CRS-2676: Start of 'ora.cssdmonitor' on 'rac03' succeeded
CRS-2676: Start of 'ora.gipcd' on 'rac03' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'rac03'
CRS-2672: Attempting to start 'ora.diskmon' on 'rac03'
CRS-2676: Start of 'ora.diskmon' on 'rac03' succeeded
CRS-2676: Start of 'ora.cssd' on 'rac03' succeeded
ASM de-configuration trace file location: /tmp/deinstall2019-10-09_08-20-19AM/logs/asmcadc_clean2019-10-09_08-35-03-AM.log
ASM Clean Configuration START
ASM Clean Configuration END

ASM with SID +ASM1 deleted successfully. Check /tmp/deinstall2019-10-09_08-20-19AM/logs/asmcadc_clean2019-10-09_08-35-03-AM.log for details.

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac03'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac03'
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac03'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac03'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac03'
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac03'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac03' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 'rac03' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac03' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac03' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac03'
CRS-2677: Stop of 'ora.cssd' on 'rac03' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac03'
CRS-2677: Stop of 'ora.gipcd' on 'rac03' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac03' has completed
CRS-4133: Oracle High Availability Services has been stopped.
2019/10/09 08:37:40 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector.

2019/10/09 08:39:32 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector.

2019/10/09 08:40:12 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node

2019/10/09 08:40:12 CLSRSC-559: Ensure that the GPnP profile data under the 'gpnp' directory in /u01/app/11.2.0/grid is deleted on each node before using the software in the current Grid Infrastructure home for reconfiguration.

2019/10/09 08:40:14 CLSRSC-46: Error: '/u01/app/grid/crsdata/rac03/crsconfig/cluutil2.log' does not exist

2019/10/09 08:40:14 CLSRSC-46: Error: '/u01/app/grid/crsdata/rac03/crsconfig/cluutil2.log' does not exist

[[email protected] ~]# 
[[email protected] ~]# 

最终的执行结果（删除结果），按照提示rm -rf即可。

######################### DEINSTALL CLEAN OPERATION END #########################


####################### DEINSTALL CLEAN OPERATION SUMMARY #######################
Successfully detached Oracle home '/u01/app/11.2.0/grid' from the central inventory on the local node.
Successfully deleted directory '/u01/app/11.2.0/grid' on the local node.
Successfully deleted directory '/u01/app/oraInventory' on the local node.
Successfully detached Oracle home '/u01/app/11.2.0/grid' from the central inventory on the remote nodes 'rac01,rac02'.
Successfully deleted directory '/u01/app/11.2.0/grid' on the remote nodes 'rac01,rac02'.
Successfully deleted directory '/u01/app/oraInventory' on the remote nodes 'rac01'.
Successfully deleted directory '/u01/app/oraInventory' on the remote nodes 'rac02'.
Successfully deleted directory '/u01/app/grid' on the remote nodes 'rac02'.
Oracle Universal Installer cleanup was successful.


Run 'rm -r /etc/oraInst.loc' as root on node(s) 'rac03,rac01,rac02' at the end of the session.

Run 'rm -r /opt/ORCLfmap' as root on node(s) 'rac03,rac01,rac02' at the end of the session.
Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################


############# ORACLE DEINSTALL TOOL END #############

[[email protected] deinstall]$ 

END