Written by nodejs-style
on 

오라클 재설치

오라클 재설치

빠르게 오라클 데이터베이스 소프트웨어의 재설치 명령어 위주로만 요약한 내용이다. deinstall 부터 runInstaller 명령까지의 과정을 나열하였다.

[oracle@enp0s3 dbhome_1]$ deinstall/deinstall Checking for required files and bootstrapping ... Please wait ... 로그 위치 /tmp/deinstall2021-11-11_04-37-35PM/logs/ ############ ORACLE DECONFIG TOOL START ############ ######################### DECONFIG CHECK OPERATION START ######################### ## [시작] 설치 확인 구성 ## Oracle 홈 위치의 존재 여부를 확인하는 중/u01/app/oracle/product/19.0.0/dbhome_1 설치 해제를 위해 선택된 Oracle 홈 유형: Oracle 단일 인스턴스 데이터베이스 설치 해제를 위해 선택된 Oracle 기본 위치: /u01/app/oracle 중앙 인벤토리 위치의 존재 여부를 확인하는 중/u01/app/oraInventory ## [종료] 설치 확인 구성 ## 네트워크 구성 확인 구성 시작 네트워크 구성 해제 추적 파일 위치: /tmp/deinstall2021-11-11_04-37-35PM/logs/netdc_check2021-11-11_04-37-44PM.log 네트워크 구성 확인 구성 종료 데이터베이스 확인 구성 시작 데이터베이스 구성 해제 추적 파일 위치: /tmp/deinstall2021-11-11_04-37-35PM/logs/databasedc_check2021-11-11_04-37-44PM.log 값 목록을 입력값으로 지정하는 경우 콤마를 구분 기호로 사용하십시오. 이 Oracle 홈에 구성된 데이터베이스 이름 목록을 지정하십시오. []: 데이터베이스 확인 구성 종료 ######################### DECONFIG CHECK OPERATION END ######################### ####################### DECONFIG CHECK OPERATION SUMMARY ####################### 설치 해제를 위해 선택된 Oracle 홈: /u01/app/oracle/product/19.0.0/dbhome_1 등록된 Oracle 홈이 있는 인벤토리 위치: /u01/app/oraInventory 계속하겠습니까(y - 예, n - 아니오)? [n]: y 이 세션의 로그는 '/tmp/deinstall2021-11-11_04-37-35PM/logs/deinstall_deconfig2021-11-11_04-37-43-PM.out'에 기록됩니다. 이 세션의 모든 오류 메시지는 '/tmp/deinstall2021-11-11_04-37-35PM/logs/deinstall_deconfig2021-11-11_04-37-43-PM.err'에 기록됩니다. ######################## DECONFIG CLEAN OPERATION START ######################## 데이터베이스 구성 해제 추적 파일 위치: /tmp/deinstall2021-11-11_04-37-35PM/logs/databasedc_clean2021-11-11_04-37-44PM.log 네트워크 구성 정리 구성 시작 네트워크 구성 해제 추적 파일 위치: /tmp/deinstall2021-11-11_04-37-35PM/logs/netdc_clean2021-11-11_04-37-44PM.log 백업 파일의 구성을 해제하는 중... 백업 파일의 구성이 성공적으로 해제되었습니다. 네트워크 구성이 성공적으로 정리되었습니다. 네트워크 구성 정리 구성 종료 ######################### DECONFIG CLEAN OPERATION END ######################### ####################### DECONFIG CLEAN OPERATION SUMMARY ####################### ####################################################################### ############# ORACLE DECONFIG TOOL END ############# 속성 파일 /tmp/deinstall2021-11-11_04-37-35PM/response/deinstall_2021-11-11_04-37-43-PM.rsp 사용 중 로그 위치 /tmp/deinstall2021-11-11_04-37-35PM/logs/ ############ ORACLE DEINSTALL TOOL START ############ ####################### DEINSTALL CHECK OPERATION SUMMARY ####################### 이 세션의 로그는 '/tmp/deinstall2021-11-11_04-37-35PM/logs/deinstall_deconfig2021-11-11_04-37-43-PM.out'에 기록됩니다. 이 세션의 모든 오류 메시지는 '/tmp/deinstall2021-11-11_04-37-35PM/logs/deinstall_deconfig2021-11-11_04-37-43-PM.err'에 기록됩니다. ######################## DEINSTALL CLEAN OPERATION START ######################## ## [시작] 설치 해제 준비 중 ## LOCAL_NODE을(를) enp0s3(으)로 설정하는 중 CRS_HOME을(를) false(으)로 설정하는 중 oracle.installer.invPtrLoc을(를) /tmp/deinstall2021-11-11_04-37-35PM/oraInst.loc(으)로 설정하는 중 oracle.installer.local을(를) false(으)로 설정하는 중 ## [끝] 설치 해제 준비 중 ## Setting the force flag to false Setting the force flag to cleanup the Oracle Base Oracle Universal Installer 정리 시작 로컬 노드의 중앙 인벤토리에서 Oracle 홈 '/u01/app/oracle/product/19.0.0/dbhome_1' 분리 : 완료 로컬 노드에서 '/u01/app/oracle/product/19.0.0/dbhome_1' 디렉토리 삭제 : 완료 로컬 노드에서 '/u01/app/oraInventory' 디렉토리 삭제 : 실패 <<<< '/u01/app/oracle' 디렉토리 삭제를 실패했습니다. 사용자에게 삭제할 권한이 없거나 디렉토리가 사용 중입니다. 로컬 노드에서 '/u01/app/oracle' 디렉토리 삭제 : 실패 <<<< Oracle Universal Installer 정리가 완료되었지만 오류가 있습니다. Oracle Universal Installer 정리 끝 ## [시작] Oracle 설치 지우기 ## ## [종료] Oracle 설치 지우기 ## ######################### DEINSTALL CLEAN OPERATION END ######################### ####################### DEINSTALL CLEAN OPERATION SUMMARY ####################### 로컬 노드의 중앙 인벤토리에서 Oracle 홈 '/u01/app/oracle/product/19.0.0/dbhome_1' 분리를 성공했습니다. 로컬 노드에서 '/u01/app/oracle/product/19.0.0/dbhome_1' 디렉토리 삭제를 성공했습니다. 로컬 노드에서 '/u01/app/oraInventory' 디렉토리 삭제를 실패했습니다. 오류: 사용자에게 삭제 권한이 없거나 파일이 사용 중입니다. 권한을 검토하고 로컬 노드에서 '/u01/app/oraInventory'을(를) 수동으로 삭제하십시오. 로컬 노드에서 '/u01/app/oracle' 디렉토리 삭제를 실패했습니다. 오류: 사용자에게 삭제 권한이 없거나 파일이 사용 중입니다. 권한을 검토하고 로컬 노드에서 '/u01/app/oracle'을(를) 수동으로 삭제하십시오. Oracle Universal Installer 정리가 완료되었지만 오류가 있습니다. 세션 종료 시 'enp0s3' 노드에서 루트로 'rm -r /etc/oraInst.loc'을(를) 실행하십시오. 세션 종료 시 'enp0s3' 노드에서 루트로 'rm -r /opt/ORCLfmap'을 실행하십시오. 세션 종료 시 'enp0s3' 노드에서 루트로 'rm -r /etc/oratab'을 실행하십시오. 'enp0s3' 노드에서 '/u01/app/oracle'의 권한 및 내용을 검토하십시오. '/u01/app/oracle'과(와) 연관된 Oracle 홈이 없는 경우 수동으로 '/u01/app/oracle' 및 해당 내용을 삭제하십시오. Oracle 설치 해제 툴이 임시 디렉토리를 성공적으로 정리했습니다. ####################################################################### ############# ORACLE DEINSTALL TOOL END ############# [oracle@enp0s3 dbhome_1]$ which sqlplus # SW 설치 검증 방법.. deinstall 했으므로 당연히 not found /usr/bin/which: no sqlplus in (/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin:/usr/sbin:/home/oracle/.local/bin:/u01/app/oracle/product/19.0.0/dbhome_1/bin) [oracle@enp0s3 dbhome_1]$ logout [sjh@enp0s3 ~]$ su 암호: [root@enp0s3 ~]# rm -rf /u01/app/oraInventory [root@enp0s3 ~]# rm -rf /u01/app/oracle [root@enp0s3 ~]# rm -rf /etc/oraInst.loc [root@enp0s3 ~]# rm -rf /opt/ORCLfmap [root@enp0s3 ~]# rm -rf /etc/oratab [root@enp0s3 ~]# mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1 [root@enp0s3 ~]# mkdir -p /u01/app/oraInventory [root@enp0s3 ~]# chown -R oracle:oinstall /u01/app/oracle/ [root@enp0s3 ~]# chown -R oracle:oinstall /u01/app/oraInventory/ [root@enp0s3 ~]# chmod -R 755 /u01/app/oracle/ [root@enp0s3 ~]# chmod -R 755 /u01/app/oraInventory/ [root@enp0s3 ~]# su - oracle [root@enp0s3 ~]# exit exit [sjh@enp0s3 ~]$ su - oracle 암호: 마지막 로그인: 목 11월 11 15:51:16 KST 2021 일시 pts/3 [oracle@enp0s3 ~]$ vim /home/oracle/.bash_profile [oracle@enp0s3 ~]$ cd $ORACLE_HOME [oracle@enp0s3 dbhome_1]$ unzip -q /tmp/LINUX.X64_193000_db_home.zip [oracle@enp0s3 dbhome_1]$ cd install/response/ [oracle@enp0s3 response]$ cp db_install.rsp db_install.rsp.bkp [oracle@enp0s3 response]$ vim db_install.rsp [oracle@enp0s3 response]$ cd $ORACLE_HOME [oracle@enp0s3 response]$ which sqlplus /usr/bin/which: no sqlplus in (/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin:/usr/sbin:/home/oracle/.local/bin:/u01/app/oracle/product/19.0.0/dbhome_1/bin) # runInstaller 명령 실행 전 responseFile은 백업 후 하단의 코드블럭 내용을 참고하여 수정하고 실행한다. [oracle@enp0s3 dbhome_1]$ ./runInstaller -waitforcompletion -silent -responseFile $ORACLE_HOME/install/response/db_install.rsp Oracle Database 설정 마법사 실행 중... 'root' 사용자에 대한 비밀번호 입력: 이 세션에 대한 응답 파일을 다음에서 찾을 수 있습니다. /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_2021-11-11_04-58-59PM.rsp 다음 위치에서 이 설치 세션의 로그를 찾을 수 있습니다. /tmp/InstallActions2021-11-11_04-58-59PM/installActions2021-11-11_04-58-59PM.log Successfully Setup Software. 설치 세션 로그 이동 위치: /u01/app/oraInventory/logs/InstallActions2021-11-11_04-58-59PM [oracle@enp0s3 dbhome_1]$ which sqlplus /u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus

responseFile 인 ORACLE_HOME/install/response/db_install.rsp 의 내용을 다음과 같이 수정하여 위의 ./runInstaller 명령을 실행한다.

#################################################################### ## Copyright(c) Oracle Corporation 1998,2019. All rights reserved.## ## ## ## Specify values for the variables listed below to customize ## ## your installation. ## ## ## ## Each variable is associated with a comment. The comment ## ## can help to populate the variables with the appropriate ## ## values. ## ## ## ## IMPORTANT NOTE: This file contains plain text passwords and ## ## should be secured to have read permission only by oracle user ## ## or db administrator who owns this installation. ## ## ## #################################################################### #------------------------------------------------------------------------------ # Do not change the following system generated value. #------------------------------------------------------------------------------ oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0 #------------------------------------------------------------------------------- # Specify the installation option. # It can be one of the following: # - INSTALL_DB_SWONLY # - INSTALL_DB_AND_CONFIG #------------------------------------------------------------------------------- oracle.install.option=INSTALL_DB_SWONLY #------------------------------------------------------------------------------- # Specify the Unix group to be set for the inventory directory. #------------------------------------------------------------------------------- UNIX_GROUP_NAME=oinstall #------------------------------------------------------------------------------- # Specify the location which holds the inventory files. # This is an optional parameter if installing on # Windows based Operating System. #------------------------------------------------------------------------------- INVENTORY_LOCATION=/u01/app/oraInventory #------------------------------------------------------------------------------- # Specify the complete path of the Oracle Home. #------------------------------------------------------------------------------- ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 #------------------------------------------------------------------------------- # Specify the complete path of the Oracle Base. #------------------------------------------------------------------------------- ORACLE_BASE=/u01/app/oracle #------------------------------------------------------------------------------- # Specify the installation edition of the component. # # The value should contain only one of these choices. # - EE : Enterprise Edition # - SE2 : Standard Edition 2 #------------------------------------------------------------------------------- oracle.install.db.InstallEdition=EE ############################################################################### # # # PRIVILEGED OPERATING SYSTEM GROUPS # # ------------------------------------------ # # Provide values for the OS groups to which SYSDBA and SYSOPER privileges # # needs to be granted. If the install is being performed as a member of the # # group "dba", then that will be used unless specified otherwise below. # # # # The value to be specified for OSDBA and OSOPER group is only for UNIX based # # Operating System. # # # ############################################################################### #------------------------------------------------------------------------------ # The OSDBA_GROUP is the OS group which is to be granted SYSDBA privileges. #------------------------------------------------------------------------------- oracle.install.db.OSDBA_GROUP=dba #------------------------------------------------------------------------------ # The OSOPER_GROUP is the OS group which is to be granted SYSOPER privileges. # The value to be specified for OSOPER group is optional. #------------------------------------------------------------------------------ oracle.install.db.OSOPER_GROUP=oper #------------------------------------------------------------------------------ # The OSBACKUPDBA_GROUP is the OS group which is to be granted SYSBACKUP privileges. #------------------------------------------------------------------------------ oracle.install.db.OSBACKUPDBA_GROUP=backupdba #------------------------------------------------------------------------------ # The OSDGDBA_GROUP is the OS group which is to be granted SYSDG privileges. #------------------------------------------------------------------------------ oracle.install.db.OSDGDBA_GROUP=dgdba #------------------------------------------------------------------------------ # The OSKMDBA_GROUP is the OS group which is to be granted SYSKM privileges. #------------------------------------------------------------------------------ oracle.install.db.OSKMDBA_GROUP=kmdba #------------------------------------------------------------------------------ # The OSRACDBA_GROUP is the OS group which is to be granted SYSRAC privileges. #------------------------------------------------------------------------------ oracle.install.db.OSRACDBA_GROUP=dba ################################################################################ # # # Root script execution configuration # # # ################################################################################ #------------------------------------------------------------------------------------------------------- # Specify the root script execution mode. # # - true : To execute the root script automatically by using the appropriate configuration methods. # - false : To execute the root script manually. # # If this option is selected, password should be specified on the console. #------------------------------------------------------------------------------------------------------- oracle.install.db.rootconfig.executeRootScript=true #-------------------------------------------------------------------------------------- # Specify the configuration method to be used for automatic root script execution. # # Following are the possible choices: # - ROOT # - SUDO #-------------------------------------------------------------------------------------- oracle.install.db.rootconfig.configMethod=ROOT #-------------------------------------------------------------------------------------- # Specify the absolute path of the sudo program. # # Applicable only when SUDO configuration method was chosen. #-------------------------------------------------------------------------------------- oracle.install.db.rootconfig.sudoPath= #-------------------------------------------------------------------------------------- # Specify the name of the user who is in the sudoers list. # Applicable only when SUDO configuration method was chosen. oracle.install.db.rootconfig.sudoPath= #-------------------------------------------------------------------------------------- # Specify the name of the user who is in the sudoers list. # Applicable only when SUDO configuration method was chosen. # Note:For Single Instance database installations,the sudo user name must be the username of the user installing the database. #-------------------------------------------------------------------------------------- oracle.install.db.rootconfig.sudoUserName= ############################################################################### # # # Grid Options # # # ############################################################################### #------------------------------------------------------------------------------ # Value is required only if the specified install option is INSTALL_DB_SWONLY # # Specify the cluster node names selected during the installation. # # Example : oracle.install.db.CLUSTER_NODES=node1,node2 #------------------------------------------------------------------------------ oracle.install.db.CLUSTER_NODES= ############################################################################### # # # Database Configuration Options # # # ############################################################################### #------------------------------------------------------------------------------- # Specify the type of database to create. # It can be one of the following: # - GENERAL_PURPOSE # - DATA_WAREHOUSE # GENERAL_PURPOSE: A starter database designed for general purpose use or transaction-heavy applications. # DATA_WAREHOUSE : A starter database optimized for data warehousing applications. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.type= #------------------------------------------------------------------------------- # Specify the Starter Database Global Database Name. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.globalDBName= #------------------------------------------------------------------------------- # Specify the Starter Database SID. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.SID= #------------------------------------------------------------------------------- # Specify whether the database should be configured as a Container database. # The value can be either "true" or "false". If left blank it will be assumed # to be "false". #------------------------------------------------------------------------------- oracle.install.db.ConfigureAsContainerDB= #------------------------------------------------------------------------------- # Specify the Pluggable Database name for the pluggable database in Container Database. #------------------------------------------------------------------------------- oracle.install.db.config.PDBName= #------------------------------------------------------------------------------- # Specify the Starter Database character set. # # One of the following # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2, # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257, # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6, # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8, # IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE, # KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950, # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258 #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.characterSet= #------------------------------------------------------------------------------ # This variable should be set to true if Automatic Memory Management # in Database is desired. # If Automatic Memory Management is not desired, and memory allocation # is to be done manually, then set it to false. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.memoryOption= #------------------------------------------------------------------------------- # Specify the total memory allocation for the database. Value(in MB) should be # at least 256 MB, and should not exceed the total physical memory available # on the system. # Example: oracle.install.db.config.starterdb.memoryLimit=512 #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.memoryLimit= #------------------------------------------------------------------------------- # This variable controls whether to load Example Schemas onto # the starter database or not. # The value can be either "true" or "false". If left blank it will be assumed # to be "false". #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.installExampleSchemas= ############################################################################### # # # Passwords can be supplied for the following four schemas in the # # starter database: # # SYS # # SYSTEM # # DBSNMP (used by Enterprise Manager) # # # # Same password can be used for all accounts (not recommended) # # or different passwords for each account can be provided (recommended) # # # ############################################################################### #------------------------------------------------------------------------------ # This variable holds the password that is to be used for all schemas in the # starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.ALL= #------------------------------------------------------------------------------- # Specify the SYS password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYS= #------------------------------------------------------------------------------- # Specify the SYSTEM password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSTEM= #------------------------------------------------------------------------------- # Specify the DBSNMP password for the starter database. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.DBSNMP= #------------------------------------------------------------------------------- # Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.PDBADMIN= #------------------------------------------------------------------------------- # Specify the management option to use for managing the database. # Options are: # 1. CLOUD_CONTROL - If you want to manage your database with Enterprise Manager Cloud Control along with Database Express. # 2. DEFAULT -If you want to manage your database using the default Database Express option. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.managementOption= #------------------------------------------------------------------------------- # Specify the OMS host to connect to Cloud Control. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.omsHost= #------------------------------------------------------------------------------- # Specify the OMS port to connect to Cloud Control. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.omsPort= #------------------------------------------------------------------------------- # Specify the EM Admin user name to use to connect to Cloud Control. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.emAdminUser= #------------------------------------------------------------------------------- # Specify the EM Admin password to use to connect to Cloud Control. # Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.emAdminPassword= ############################################################################### # # # SPECIFY RECOVERY OPTIONS # # ------------------------------------ # # Recovery options for the database can be mentioned using the entries below # # # ############################################################################### #------------------------------------------------------------------------------ # This variable is to be set to false if database recovery is not required. Else # this can be set to true. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.enableRecovery= #------------------------------------------------------------------------------- # Specify the type of storage to use for the database. # It can be one of the following: # - FILE_SYSTEM_STORAGE # - ASM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.storageType= #------------------------------------------------------------------------------- # Specify the database file location which is a directory for datafiles, control # files, redo logs. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= #------------------------------------------------------------------------------- # Specify the recovery location. # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= #------------------------------------------------------------------------------- # Specify the existing ASM disk groups to be used for storage. # # Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.asm.diskGroup= #------------------------------------------------------------------------------- # Specify the password for ASMSNMP user of the ASM instance. # # Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.asm.ASMSNMPPassword=

from http://xjhx.tistory.com/40 by ccl(A) rewrite - 2021-11-19 18:27:07