| 시나리오 : 3개 노드(svr1, svr2, svr3) 중 svr3 노드 제거 버전 : 19c |
1. 작업 전 확인
| [root@svr1 ~]# olsnodes -s -t svr1 Active Unpinned svr2 Active Unpinned svr3 Active Unpinned [root@svr1 ~]# crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE svr1 STABLE ONLINE ONLINE svr2 STABLE ONLINE ONLINE svr3 STABLE ora.chad ONLINE ONLINE svr1 STABLE ONLINE ONLINE svr2 STABLE ONLINE ONLINE svr3 STABLE ora.net1.network ONLINE ONLINE svr1 STABLE ONLINE ONLINE svr2 STABLE ONLINE ONLINE svr3 STABLE ora.ons ONLINE ONLINE svr1 STABLE ONLINE ONLINE svr2 STABLE ONLINE ONLINE svr3 STABLE ora.proxy_advm OFFLINE OFFLINE svr1 STABLE OFFLINE OFFLINE svr2 STABLE OFFLINE OFFLINE svr3 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE svr1 STABLE 2 ONLINE ONLINE svr2 STABLE 3 ONLINE ONLINE svr3 STABLE ora.DATA.dg(ora.asmgroup) 1 ONLINE ONLINE svr1 STABLE 2 ONLINE ONLINE svr2 STABLE 3 ONLINE ONLINE svr3 STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE svr3 STABLE ora.OCR.dg(ora.asmgroup) 1 ONLINE ONLINE svr1 STABLE 2 ONLINE ONLINE svr2 STABLE 3 ONLINE ONLINE svr3 STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE svr1 Started,STABLE 2 ONLINE ONLINE svr2 Started,STABLE 3 ONLINE ONLINE svr3 Started,STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE OFFLINE STABLE 2 ONLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE svr1 STABLE ora.qosmserver 1 ONLINE ONLINE svr3 STABLE ora.racdb.db 1 ONLINE ONLINE svr1 Open,HOME=/ora19/app /oracle/product/19.3 .0/db_1,STABLE 2 ONLINE ONLINE svr2 Open,HOME=/ora19/app /oracle/product/19.3 .0/db_1,STABLE 3 ONLINE ONLINE svr3 Open,HOME=/ora19/app /oracle/product/19.3 .0/db_1,STABLE ora.scan1.vip 1 ONLINE ONLINE svr3 STABLE ora.svr1.vip 1 ONLINE ONLINE svr1 STABLE ora.svr2.vip 1 ONLINE ONLINE svr2 STABLE ora.svr3.vip 1 ONLINE ONLINE svr3 STABLE -------------------------------------------------------------------------------- |
2. dbca 사용하여 instance 제거
(노드 : svr1, 계정 : oracle)
| [oracle@svr1 ~]$ cd $ORACLE_HOME/bin [oracle@svr1 bin]$ ./dbca        -- 작업 완료 후 확인 [root@svr1 ~]# crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE svr1 STABLE ONLINE ONLINE svr2 STABLE ONLINE ONLINE svr3 STABLE ora.chad ONLINE ONLINE svr1 STABLE ONLINE ONLINE svr2 STABLE ONLINE ONLINE svr3 STABLE ora.net1.network ONLINE ONLINE svr1 STABLE ONLINE ONLINE svr2 STABLE ONLINE ONLINE svr3 STABLE ora.ons ONLINE ONLINE svr1 STABLE ONLINE ONLINE svr2 STABLE ONLINE ONLINE svr3 STABLE ora.proxy_advm OFFLINE OFFLINE svr1 STABLE OFFLINE OFFLINE svr2 STABLE OFFLINE OFFLINE svr3 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE svr1 STABLE 2 ONLINE ONLINE svr2 STABLE 3 ONLINE ONLINE svr3 STABLE ora.DATA.dg(ora.asmgroup) 1 ONLINE ONLINE svr1 STABLE 2 ONLINE ONLINE svr2 STABLE 3 ONLINE ONLINE svr3 STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE svr3 STABLE ora.OCR.dg(ora.asmgroup) 1 ONLINE ONLINE svr1 STABLE 2 ONLINE ONLINE svr2 STABLE 3 ONLINE ONLINE svr3 STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE svr1 Started,STABLE 2 ONLINE ONLINE svr2 Started,STABLE 3 ONLINE ONLINE svr3 Started,STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE OFFLINE STABLE 2 ONLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE svr1 STABLE ora.qosmserver 1 ONLINE ONLINE svr3 STABLE ora.racdb.db 1 ONLINE ONLINE svr1 Open,HOME=/ora19/app /oracle/product/19.3 .0/db_1,STABLE 2 ONLINE ONLINE svr2 Open,HOME=/ora19/app /oracle/product/19.3 .0/db_1,STABLE ora.scan1.vip 1 ONLINE ONLINE svr3 STABLE ora.svr1.vip 1 ONLINE ONLINE svr1 STABLE ora.svr2.vip 1 ONLINE ONLINE svr2 STABLE ora.svr3.vip 1 ONLINE ONLINE svr3 STABLE -------------------------------------------------------------------------------- [root@svr1 ~]# |
3. DB 엔진 deinstall
(작업노드 : svr3, 계정 : oracle)
| [oracle@svr3 deinstall]$ ./deinstall -local Checking for required files and bootstrapping ... Please wait ... Location of logs /ora19/app/grid/oraInventory/logs/ ############ ORACLE DECONFIG TOOL START ############ ######################### DECONFIG CHECK OPERATION START ######################### ## [START] Install check configuration ## Checking for existence of the Oracle home location /ora19/app/oracle/product/19.3.0/db_1 Oracle Home type selected for deinstall is: Oracle Real Application Cluster Database Oracle Base selected for deinstall is: /ora19/app/oracle Checking for existence of central inventory location /ora19/app/grid/oraInventory Checking for existence of the Oracle Grid Infrastructure home /ora19/app/grid/19.3.0 The following nodes are part of this cluster: svr3,svr2,svr1 Checking for sufficient temp space availability on node(s) : 'svr3' ## [END] Install check configuration ## Network Configuration check config START Network de-configuration trace file location: /ora19/app/grid/oraInventory/logs/netdc_check2023-06-10_03-59-51PM.log Network Configuration check config END Database Check Configuration START Database de-configuration trace file location: /ora19/app/grid/oraInventory/logs/databasedc_check2023-06-10_03-59-51PM.log Use comma as separator when specifying list of values as input Specify the list of database names that are configured locally on this node for this Oracle home. Local configurations of the discovered databases will be removed []: 엔터입력 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: svr3,svr2,svr1 The cluster node(s) on which the Oracle home deinstallation will be performed are:svr3 Oracle Home selected for deinstall is: /ora19/app/oracle/product/19.3.0/db_1 Inventory Location where the Oracle home registered is: /ora19/app/grid/oraInventory Do you want to continue (y - yes, n - no)? [n]: y A log of this session will be written to: '/ora19/app/grid/oraInventory/logs/deinstall_deconfig2023-06-10_03-59-35-PM.out' Any error messages from this session will be written to: '/ora19/app/grid/oraInventory/logs/deinstall_deconfig2023-06-10_03-59-35-PM.err' ######################## DECONFIG CLEAN OPERATION START ######################## Database de-configuration trace file location: /ora19/app/grid/oraInventory/logs/databasedc_clean2023-06-10_03-59-51PM.log Network Configuration clean config START Network de-configuration trace file location: /ora19/app/grid/oraInventory/logs/netdc_clean2023-06-10_03-59-51PM.log Network Configuration clean config END ######################### DECONFIG CLEAN OPERATION END ######################### ####################### DECONFIG CLEAN OPERATION SUMMARY ####################### ####################################################################### ############# ORACLE DECONFIG TOOL END ############# Using properties file /tmp/deinstall2023-06-10_03-59-30PM/response/deinstall_2023-06-10_03-59-35-PM.rsp Location of logs /ora19/app/grid/oraInventory/logs/ ############ ORACLE DEINSTALL TOOL START ############ ####################### DEINSTALL CHECK OPERATION SUMMARY ####################### A log of this session will be written to: '/ora19/app/grid/oraInventory/logs/deinstall_deconfig2023-06-10_03-59-35-PM.out' Any error messages from this session will be written to: '/ora19/app/grid/oraInventory/logs/deinstall_deconfig2023-06-10_03-59-35-PM.err' ######################## DEINSTALL CLEAN OPERATION START ######################## ## [START] Preparing for Deinstall ## Setting LOCAL_NODE to svr3 Setting CLUSTER_NODES to svr3 Setting CRS_HOME to false Setting oracle.installer.invPtrLoc to /tmp/deinstall2023-06-10_03-59-30PM/oraInst.loc Setting oracle.installer.local to true ## [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/oracle/product/19.3.0/db_1' from the central inventory on the local node : Done Delete directory '/ora19/app/oracle/product/19.3.0/db_1' on the local node : Done Failed to delete the directory '/ora19/app/oracle'. Either user has no permission to delete or it is in use. Delete directory '/ora19/app/oracle' on the local node : Failed <<<< Oracle Universal Installer cleanup completed with errors. Oracle Universal Installer clean END ## [START] Oracle install clean ## ## [END] Oracle install clean ## ######################### DEINSTALL CLEAN OPERATION END ######################### ####################### DEINSTALL CLEAN OPERATION SUMMARY ####################### Successfully detached Oracle home '/ora19/app/oracle/product/19.3.0/db_1' from the central inventory on the local node. Successfully deleted directory '/ora19/app/oracle/product/19.3.0/db_1' on the local node. Failed to delete directory '/ora19/app/oracle' on the local node due to error : Either user has no permission to delete or file is in use. Review the permissions and manually delete '/ora19/app/oracle' on local node. Oracle Universal Installer cleanup completed with errors. Review the permissions and contents of '/ora19/app/oracle' on nodes(s) 'svr3'. 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 ############# -- DB엔진삭제 확인 [oracle@svr3 deinstall]$ pwd /ora19/app/oracle/product/19.3.0/db_1/deinstall [oracle@svr3 deinstall]$ ls [oracle@svr3 deinstall]$ cd .. cd: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory [oracle@svr3 ..]$ ls [oracle@svr3 ..]$ pwd /ora19/app/oracle/product/19.3.0/db_1/deinstall/.. [oracle@svr3 ..]$ cd /ora19 [oracle@svr3 ora19]$ ls app [oracle@svr3 ora19]$ cd app/ [oracle@svr3 app]$ ls grid oracle [oracle@svr3 app]$ du -sh * 6.6G grid 0 oracle [oracle@svr3 app]$ cd oracle/ [oracle@svr3 oracle]$ ls [oracle@svr3 oracle]$ cd .. [oracle@svr3 app]$ |
4. GRID deinstall
(작업노드 : svr1, 계정 : grid)
| [grid@svr1 ~]$ cd $ORACLE_HOME [grid@svr1 19.3.0]$ ./gridSetup.sh      -- svr3 에서 root 계정으로 스크립트 수행 [root@svr3 ~]# /ora19/app/grid/19.3.0/crs/install/rootdeinstall.sh Using configuration parameter file: /tmp/deinstall_OraGI19Home1.rsp The log of current session can be found at: /tmp/deinstall2023-06-10_04-10-15PM/logs/crsdeconfig_svr3_2023-06-10_04-12-36PM.log 2023/06/10 16:14:16 CLSRSC-4006: Removing Oracle Trace File Analyzer (TFA) Collector. 2023/06/10 16:16:02 CLSRSC-4007: Successfully removed Oracle Trace File Analyzer (TFA) Collector. 2023/06/10 16:16:03 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node Checking for required files and bootstrapping ... Please wait ... Using properties file /tmp/deinstall_OraGI19Home1.rsp Location of logs /tmp/deinstall2023-06-10_04-10-15PM/logs/ ############ ORACLE DEINSTALL TOOL START ############ A log of this session will be written to: '/tmp/deinstall2023-06-10_04-10-15PM/logs/deinstall_deconfig2023-06-10_04-16-07-PM.out' Any error messages from this session will be written to: '/tmp/deinstall2023-06-10_04-10-15PM/logs/deinstall_deconfig2023-06-10_04-16-07-PM.err' ######################## DEINSTALL CLEAN OPERATION START ######################## ## [START] Preparing for Deinstall ## Setting LOCAL_NODE to svr3 Setting CLUSTER_NODES to svr3 Setting CRS_HOME to true Setting oracle.installer.invPtrLoc to /tmp/deinstall2023-06-10_04-16-05PM/oraInst.loc Setting oracle.installer.local to true ## [END] Preparing for Deinstall ## Setting the force flag to false Setting the force flag to cleanup the Oracle Base Oracle Universal Installer clean START find: ‘/ora19/app/grid/oraInventory/backup/2023-06-10_04-00-17PM’: Permission denied find: ‘/ora19/app/grid/oraInventory/backup/2023-06-10_04-00-17PM’: Permission denied 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/grid/oraInventory' on the local node : Failed <<<< Delete directory '/ora19/app/grid/base' on the local node : Done Oracle Universal Installer cleanup completed with errors. Oracle Universal Installer clean END ## [START] Oracle install clean ## ## [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. Failed to delete directory '/ora19/app/grid/oraInventory' on the local node due to error : Either user has no permission to delete or file is in use. Review the permissions and manually delete '/ora19/app/grid/oraInventory' on local node. Successfully deleted directory '/ora19/app/grid/base' on the local node. Oracle Universal Installer cleanup completed with errors. Run 'rm -r /etc/oraInst.loc' as root on node(s) 'svr3' at the end of the session. Run 'rm -r /opt/ORCLfmap' as root on node(s) 'svr3' at the end of the session. Oracle deinstall tool successfully cleaned up temporary directories. ####################################################################### ############# ORACLE DEINSTALL TOOL END ############# [root@svr3 ~]# -- svr1 에서 root 계정으로 스크립트 수행 [root@svr1 ~]# cat /tmp/GridSetupActions2023-06-10_04-04-09PM/rootdelete.sh #!/bin/sh /ora19/app/grid/19.3.0/bin/crsctl delete node -n svr3 [root@svr1 ~]# /tmp/GridSetupActions2023-06-10_04-04-09PM/rootdelete.sh CRS-4661: Node svr3 successfully deleted. [root@svr1 ~]#  |
5. 모든 작업 후 확인
| [grid@svr1 ~]$ cluvfy stage -post nodedel -n svr3 -verbose Verifying Node Removal ... Verifying CRS Integrity ...PASSED Verifying Clusterware Version Consistency ...PASSED Verifying Node Removal ...PASSED Post-check for node removal was successful. CVU operation performed: stage -post nodedel Date: Jun 10, 2023 4:18:44 PM CVU home: /ora19/app/grid/19.3.0/ User: grid [grid@svr1 ~]$ [grid@svr1 ~]$ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE svr1 STABLE ONLINE ONLINE svr2 STABLE ora.chad ONLINE ONLINE svr1 STABLE ONLINE ONLINE svr2 STABLE ora.net1.network ONLINE ONLINE svr1 STABLE ONLINE ONLINE svr2 STABLE ora.ons ONLINE ONLINE svr1 STABLE ONLINE ONLINE svr2 STABLE ora.proxy_advm OFFLINE OFFLINE svr1 STABLE OFFLINE OFFLINE svr2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE svr1 STABLE 2 ONLINE ONLINE svr2 STABLE 3 ONLINE OFFLINE STABLE ora.DATA.dg(ora.asmgroup) 1 ONLINE ONLINE svr1 STABLE 2 ONLINE ONLINE svr2 STABLE 3 ONLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE svr2 STABLE ora.OCR.dg(ora.asmgroup) 1 ONLINE ONLINE svr1 STABLE 2 ONLINE ONLINE svr2 STABLE 3 ONLINE OFFLINE STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE svr1 Started,STABLE 2 ONLINE ONLINE svr2 Started,STABLE 3 ONLINE OFFLINE STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE OFFLINE STABLE 2 ONLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE svr1 STABLE ora.qosmserver 1 ONLINE OFFLINE STABLE ora.racdb.db 1 ONLINE ONLINE svr1 Open,HOME=/ora19/app /oracle/product/19.3 .0/db_1,STABLE 2 ONLINE ONLINE svr2 Open,HOME=/ora19/app /oracle/product/19.3 .0/db_1,STABLE ora.scan1.vip 1 ONLINE ONLINE svr2 STABLE ora.svr1.vip 1 ONLINE ONLINE svr1 STABLE ora.svr2.vip 1 ONLINE ONLINE svr2 STABLE -------------------------------------------------------------------------------- [grid@svr1 ~]$ |
'DBMS > ORACLE' 카테고리의 다른 글
| RAC 환경 VIP Failover 테스트 (0) | 2023.06.19 |
|---|---|
| RAC 노드 추가(OUI) (0) | 2023.06.18 |
| LMS(License Management Services) 체크 스크립트 (0) | 2023.06.01 |
| PMO_DEFERRED_GIDX_MAINT_JOB (0) | 2023.06.01 |
| NCHAR(national character set) 테스트 (0) | 2022.10.07 |
댓글