Oracle Linux 7.6에 Oracle 19c RAC 삭제 가이드

OS환경 : Oracle Linux 7.6 (64bit)

 

DB 환경 : Oracle Database 19.6.0.0

 

방법 : Oracle Linux 7.6에 Oracle 19c RAC 삭제 가이드

grid 삭제 전 db 삭제는 아래 게시물 참조

https://positivemh.tistory.com/597

Oracle Linux 7.6에 Oracle 19c 삭제 가이드

 

 

grid home/deinstall/deinstall 실행

$ cd $GRID_HOME/deinstall
$ ./deinstall

 

 

로그

$ ./deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /tmp/deinstall2021-05-21_08-40-09PM/logs/
 
############ ORACLE DECONFIG TOOL START ############
 
 
######################### DECONFIG CHECK OPERATION START #########################
## [START] Install check configuration ##
 
 
Checking for existence of the Oracle home location /ORA19/app/grid/19.3.0
Oracle Home type selected for deinstall is: Oracle Grid Infrastructure for a Cluster
Oracle Base selected for deinstall is: /ORA19/app/oracle
Checking for existence of central inventory location /ORA19/app/oraInventory
Checking for existence of the Oracle Grid Infrastructure home /ORA19/app/grid/19.3.0
The following nodes are part of this cluster: oel19db1,oel19db2
Active Remote Nodes are oel19db2
Checking for sufficient temp space availability on node(s) : 'oel19db1,oel19db2'
 
## [END] Install check configuration ##
 
Traces log file: /tmp/deinstall2021-05-21_08-40-09PM/logs//crsdc_2021-05-21_08-40-27-PM.log
 
Network Configuration check config START
 
Network de-configuration trace file location: /tmp/deinstall2021-05-21_08-40-09PM/logs/netdc_check2021-05-21_08-40-28PM.log
 
Specify all RAC listeners (do not include SCAN listener) that are to be de-configured. Enter .(dot) to deselect all. [LISTENER]:
 
Network Configuration check config END
 
Asm Check Configuration START
 
ASM de-configuration trace file location: /tmp/deinstall2021-05-21_08-40-09PM/logs/asmcadc_check2021-05-21_08-40-28PM.log
 
Automatic Storage Management (ASM) instance is detected in this Oracle home /ORA19/app/grid/19.3.0.
ASM Diagnostic Destination : /ORA19/app/oracle
ASM Diskgroups : +DATA,+OCR_VOTE
ASM diskstring : /dev/oracleasm/disks/*
Diskgroups will be dropped
De-configuring ASM will drop all the diskgroups and their contents at cleanup time. This will affect all of the databases and ACFS that use this ASM instance(s).
 If you want to retain the existing diskgroups or if any of the information detected is incorrect, you can modify by entering 'y'. Do you  want to modify above information (y|n) [n]: y <-- [y 입력]
Is Grid Infrastructure Storage(OCR) in ASM diskgroup (y|n) [y]: y <-- [y 입력]
Enter the OCR/Voting Disk diskgroup name [+OCR_VOTE]: <-- [엔터 입력]
Specify the ASM Diagnostic Destination [/ORA19/app/oracle]: <-- [엔터 입력]
Specify the diskstring [/dev/oracleasm/disks/*]: <-- [엔터 입력]
Specify the diskgroups that are managed by this ASM instance [+DATA,+OCR_VOTE]: <-- [엔터 입력]
 
De-configuring ASM will drop the diskgroups at cleanup time. Do you want deconfig tool to drop the diskgroups (y|n) [y]: y <-- [y 입력]
 
Database Check Configuration START
 
Database de-configuration trace file location: /tmp/deinstall2021-05-21_08-40-09PM/logs/databasedc_check2021-05-21_08-40-28PM.log
 
Oracle Grid Management database was not found in this Grid Infrastructure home
 
Database Check Configuration END
 
######################### DECONFIG CHECK OPERATION END #########################
 
 
####################### DECONFIG CHECK OPERATION SUMMARY #######################
Oracle Grid Infrastructure Home is: /ORA19/app/grid/19.3.0
The following nodes are part of this cluster: oel19db1,oel19db2
Active Remote Nodes are oel19db2
The cluster node(s) on which the Oracle home deinstallation will be performed are:oel19db1,oel19db2
Oracle Home selected for deinstall is: /ORA19/app/grid/19.3.0
Inventory Location where the Oracle home registered is: /ORA19/app/oraInventory
Following RAC listener(s) will be de-configured: LISTENER
ASM instance will be de-configured from this Oracle home
Oracle Grid Management database was not found in this Grid Infrastructure home
Do you want to continue (y - yes, n - no)? [n]: y <-- [y 입력]
A log of this session will be written to: '/tmp/deinstall2021-05-21_08-40-09PM/logs/deinstall_deconfig2021-05-21_08-40-19-PM.out'
Any error messages from this session will be written to: '/tmp/deinstall2021-05-21_08-40-09PM/logs/deinstall_deconfig2021-05-21_08-40-19-PM.err'
 
######################## DECONFIG CLEAN OPERATION START ########################
Database de-configuration trace file location: /tmp/deinstall2021-05-21_08-40-09PM/logs/databasedc_clean2021-05-21_08-40-28PM.log
ASM de-configuration trace file location: /tmp/deinstall2021-05-21_08-40-09PM/logs/asmcadc_clean2021-05-21_08-40-28PM.log
ASM Clean Configuration START
ASM Clean Configuration END
 
Network Configuration clean config START
 
Network de-configuration trace file location: /tmp/deinstall2021-05-21_08-40-09PM/logs/netdc_clean2021-05-21_08-40-28PM.log
 
De-configuring RAC listener(s): LISTENER
 
De-configuring listener: LISTENER
    Stopping listener: LISTENER
    Listener stopped successfully.
    Unregistering listener: LISTENER
    Listener unregistered successfully.
Listener de-configured successfully.
 
De-configuring Naming Methods configuration file on all nodes...
Naming Methods configuration file de-configured successfully.
 
De-configuring Local Net Service Names configuration file on all nodes...
Local Net Service Names configuration file de-configured successfully.
 
De-configuring Directory Usage configuration file on all nodes...
Directory Usage configuration file de-configured successfully.
 
De-configuring backup files on all nodes...
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 "oel19db2".
 
/ORA19/app/grid/19.3.0/crs/install/rootcrs.sh -force  -deconfig -paramfile "/tmp/deinstall2021-05-21_08-40-09PM/response/deinstall_OraGI19Home1.rsp"
 
Run the following command as the root user or the administrator on node "oel19db1".
 
/ORA19/app/grid/19.3.0/crs/install/rootcrs.sh -force  -deconfig -paramfile "/tmp/deinstall2021-05-21_08-40-09PM/response/deinstall_OraGI19Home1.rsp" -lastnode
 
Press Enter after you finish running the above commands
 
<----------------------------------------

 

 

로그 마지막에 나온 내용대로 node2번에서 root 유저로 스크립트 실행

# /ORA19/app/grid/19.3.0/crs/install/rootcrs.sh -force  -deconfig -paramfile "/tmp/deinstall2021-05-21_08-40-09PM/response/deinstall_OraGI19Home1.rsp"
Using configuration parameter file: /tmp/deinstall2021-05-21_08-40-09PM/response/deinstall_OraGI19Home1.rsp
The log of current session can be found at:
  /tmp/deinstall2021-05-21_08-40-09PM/logs/crsdeconfig_oel19db2_2021-05-21_08-51-04PM.log
PRCR-1070 : Failed to check if resource ora.net1.network is registered
CRS-0184 : Cannot communicate with the CRS daemon.
PRCR-1070 : Failed to check if resource ora.helper is registered
CRS-0184 : Cannot communicate with the CRS daemon.
PRCR-1070 : Failed to check if resource ora.ons is registered
CRS-0184 : Cannot communicate with the CRS daemon.
 
2021/05/21 20:51:19 CLSRSC-180: An error occurred while executing the command '/ORA19/app/grid/19.3.0/bin/srvctl config nodeapps'
Redirecting to /bin/systemctl restart rsyslog.service
2021/05/21 20:51:38 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector.
2021/05/21 20:52:21 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector.
2021/05/21 20:52:22 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node

 

 

로그 마지막에 나온 내용대로 node1번에서 root 유저로 스크립트 실행

# /ORA19/app/grid/19.3.0/crs/install/rootcrs.sh -force  -deconfig -paramfile "/tmp/deinstall2021-05-21_08-40-09PM/response/deinstall_OraGI19Home1.rsp" -lastnode
Using configuration parameter file: /tmp/deinstall2021-05-21_08-40-09PM/response/deinstall_OraGI19Home1.rsp
The log of current session can be found at:
  /tmp/deinstall2021-05-21_08-40-09PM/logs/crsdeconfig_oel19db1_2021-05-21_08-53-10PM.log
CRS-2673: Attempting to stop 'ora.crsd' on 'oel19db1'
CRS-2677: Stop of 'ora.crsd' on 'oel19db1' succeeded
ASM de-configuration trace file location: /tmp/deinstall2021-05-21_08-40-09PM/logs/asmcadc_clean2021-05-21_08-56-03PM.log
ASM Clean Configuration START
ASM Clean Configuration END
 
ASM instance deleted successfully. Check /tmp/deinstall2021-05-21_08-40-09PM/logs/asmcadc_clean2021-05-21_08-56-03PM.log for details.
 
Redirecting to /bin/systemctl restart rsyslog.service
2021/05/21 20:57:21 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector.
2021/05/21 20:57:50 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector.
2021/05/21 20:57:53 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node
2021/05/21 20:57:53 CLSRSC-559: Ensure that the GPnP profile data under the 'gpnp' directory in /ORA19/app/grid/19.3.0 is deleted on each node before using the software in the current Grid Infrastructure home for reconfiguration.

 

 

deinstall 실행한 세션으로 와서 엔터 입력

$ ./deinstall
.
.
(중간 생략)
.
.
---------------------------------------->
 
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 "oel19db2".
 
/ORA19/app/grid/19.3.0/crs/install/rootcrs.sh -force  -deconfig -paramfile "/tmp/deinstall2021-05-21_08-40-09PM/response/deinstall_OraGI19Home1.rsp"
 
Run the following command as the root user or the administrator on node "oel19db1".
 
/ORA19/app/grid/19.3.0/crs/install/rootcrs.sh -force  -deconfig -paramfile "/tmp/deinstall2021-05-21_08-40-09PM/response/deinstall_OraGI19Home1.rsp" -lastnode
 
Press Enter after you finish running the above commands
 
<----------------------------------------
[엔터 입력]
 
######################### DECONFIG CLEAN OPERATION END #########################
 
 
####################### DECONFIG CLEAN OPERATION SUMMARY #######################
There is no Oracle Grid Management database to de-configure in this Grid Infrastructure home
ASM instance was de-configured successfully from the Oracle home
Following RAC listener(s) were de-configured successfully: LISTENER
Oracle Clusterware is stopped and successfully de-configured on node "oel19db2"
Oracle Clusterware is stopped and successfully de-configured on node "oel19db1"
Oracle Clusterware is stopped and de-configured successfully.
#######################################################################
 
 
############# ORACLE DECONFIG TOOL END #############
 
Using properties file /tmp/deinstall2021-05-21_08-40-09PM/response/deinstall_2021-05-21_08-40-19-PM.rsp
Location of logs /tmp/deinstall2021-05-21_08-40-09PM/logs/
 
############ ORACLE DEINSTALL TOOL START ############
 
 
 
 
 
####################### DEINSTALL CHECK OPERATION SUMMARY #######################
A log of this session will be written to: '/tmp/deinstall2021-05-21_08-40-09PM/logs/deinstall_deconfig2021-05-21_08-40-19-PM.out'
Any error messages from this session will be written to: '/tmp/deinstall2021-05-21_08-40-09PM/logs/deinstall_deconfig2021-05-21_08-40-19-PM.err'
 
######################## DEINSTALL CLEAN OPERATION START ########################
## [START] Preparing for Deinstall ##
Setting LOCAL_NODE to oel19db1
Setting REMOTE_NODES to oel19db2
Setting CLUSTER_NODES to oel19db1,oel19db2
Setting CRS_HOME to true
Setting oracle.installer.invPtrLoc to /tmp/deinstall2021-05-21_08-40-09PM/oraInst.loc
Setting oracle.installer.local to false
 
## [END] Preparing for Deinstall ##
 
Setting the force flag to false
Setting the force flag to cleanup the Oracle Base
Oracle Universal Installer clean START
 
Detach Oracle home '/ORA19/app/grid/19.3.0' from the central inventory on the local node : Done
 
Delete directory '/ORA19/app/grid/19.3.0' on the local node : Done
 
Delete directory '/ORA19/app/oraInventory' on the local node : Done
 
Failed to delete the directory '/ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/driver/2020-03-10-05-26-46/machine-readable'. Either user has no permission to delete or it is in use.
Failed to delete the directory '/ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/driver/2020-03-10-05-26-46/.tmp'. Either user has no permission to delete or it is in use.
Failed to delete the directory '/ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/2020-03-10-05-27-31/machine-readable'. Either user has no permission to delete or it is in use.
Failed to delete the directory '/ORA19/app/oracle/product/19.3.0/db_1/cfgtoollogs/opatchautodb/2020-03-10-05-27-31/.tmp'. Either user has no permission to delete or it is in use.
The Oracle Base directory '/ORA19/app/oracle' will not be removed on local node. The directory is not empty. User needs to manually cleanup this directory.
 
Detach Oracle home '/ORA19/app/grid/19.3.0' from the central inventory on the remote nodes 'oel19db2' : Done
 
Delete directory '/ORA19/app/grid/19.3.0' on the remote nodes 'oel19db2' : Done
 
Delete directory '/ORA19/app/oraInventory' on the remote nodes 'oel19db2' : Done
 
The Oracle Base directory '/ORA19/app/oracle' will not be removed on node 'oel19db2'. 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/deinstall2021-05-21_08-40-09PM' on node 'oel19db2'
 
## [END] Oracle install clean ##
 
 
######################### DEINSTALL CLEAN OPERATION END #########################
 
 
####################### DEINSTALL CLEAN OPERATION SUMMARY #######################
Successfully detached Oracle home '/ORA19/app/grid/19.3.0' from the central inventory on the local node.
Successfully deleted directory '/ORA19/app/grid/19.3.0' on the local node.
Successfully deleted directory '/ORA19/app/oraInventory' on the local node.
Successfully detached Oracle home '/ORA19/app/grid/19.3.0' from the central inventory on the remote nodes 'oel19db2'.
Successfully deleted directory '/ORA19/app/grid/19.3.0' on the remote nodes 'oel19db2'.
Successfully deleted directory '/ORA19/app/oraInventory' on the remote nodes 'oel19db2'.
Oracle Universal Installer cleanup was successful.
 
 
Run 'rm -r /etc/oraInst.loc' as root on node(s) 'oel19db1,oel19db2' at the end of the session.
 
Run 'rm -r /opt/ORCLfmap' as root on node(s) 'oel19db1,oel19db2' at the end of the session.
Review the permissions and contents of '/ORA19/app/oracle' on nodes(s) 'oel19db1,oel19db2'.
If there are no Oracle home(s) associated with '/ORA19/app/oracle', manually delete '/ORA19/app/oracle' and its contents.
Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################
 
 
############# ORACLE DEINSTALL TOOL END #############

 

 

deinstall 마지막 로그에있는 112,114~116 번째 줄 내용에 따라 관련 파일 삭제(양쪽노드)

$ exit
# rm -rf /etc/oraInst.loc
# rm -rf /opt/ORCLfmap
# rm -rf /ORA19/app/oracle

 

 

GRID 삭제 확인(양쪽노드)

$ ls -al $GRID_HOME
ls: cannot access /ORA19/app/grid/19.3.0: No such file or directory

$GRID_HOME 인 /ORA19/app/grid/19.3.0 디렉토리 자체가 없어진것을 확인 가능함

 

 

삭제 완료

 

 

 

 

로그

추후 참고용 deinstall 로그 압축 및 업로드

# tar -cvf grid_del_rac_log.tar.gz /tmp/deinstall2021-05-21_08-40-09PM/logs
# ls grid_del_rac_log.tar.gz 
grid_del_rac_log.tar.gz

grid_del_rac_log.tar.gz

1.09MB

 

 

참조 : 

https://positivemh.tistory.com/615

Oracle Linux 7.4에 Oracle 11g R2 RAC 삭제 가이드

https://positivemh.tistory.com/522

Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 1

https://positivemh.tistory.com/523

Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 2