오라클 사일런트 설치

오라클 사일런트 설치

소프트웨어를 설치하기 위해 파일 시스템에 복사 또는 마운트하고 ORACLE_HOME에다 압축을 해제한다.

[oracle@enp0s3 ~]$ cd $ORACLE_HOME [oracle@enp0s3 dbhome_1]$ unzip -q /tmp/LINUX.X64_193000_db_home.zip

설치 파라미터가 구성된 response 파일은 ORACLE_HOME/install/response 에 있다. db_install.rsp 로 .rsp 형식 파일로 존재한다.

#################################################################### ## 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= #------------------------------------------------------------------------------- # Specify the Unix group to be set for the inventory directory. #------------------------------------------------------------------------------- UNIX_GROUP_NAME= #------------------------------------------------------------------------------- # Specify the location which holds the inventory files. # This is an optional parameter if installing on # Windows based Operating System. #------------------------------------------------------------------------------- INVENTORY_LOCATION= #------------------------------------------------------------------------------- # Specify the complete path of the Oracle Home. #------------------------------------------------------------------------------- ORACLE_HOME= #------------------------------------------------------------------------------- # Specify the complete path of the Oracle Base. #------------------------------------------------------------------------------- ORACLE_BASE= #------------------------------------------------------------------------------- # 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= ############################################################################### # # # 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= #------------------------------------------------------------------------------ # 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= #------------------------------------------------------------------------------ # The OSBACKUPDBA_GROUP is the OS group which is to be granted SYSBACKUP privileges. #------------------------------------------------------------------------------ oracle.install.db.OSBACKUPDBA_GROUP= #------------------------------------------------------------------------------ # The OSDGDBA_GROUP is the OS group which is to be granted SYSDG privileges. #------------------------------------------------------------------------------ oracle.install.db.OSDGDBA_GROUP= #------------------------------------------------------------------------------ # The OSKMDBA_GROUP is the OS group which is to be granted SYSKM privileges. #------------------------------------------------------------------------------ oracle.install.db.OSKMDBA_GROUP= #------------------------------------------------------------------------------ # The OSRACDBA_GROUP is the OS group which is to be granted SYSRAC privileges. #------------------------------------------------------------------------------ oracle.install.db.OSRACDBA_GROUP= ################################################################################ # # # 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= #-------------------------------------------------------------------------------------- # Specify the configuration method to be used for automatic root script execution. # # Following are the possible choices: # - ROOT # - SUDO #-------------------------------------------------------------------------------------- oracle.install.db.rootconfig.configMethod= #-------------------------------------------------------------------------------------- # 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. # 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=

설치 시 사일런트 모드로 소프트웨어 설치 진행할 수 있다. 위 db_install.rsp 파일의 파라미터를 참고해서 적절히 입력한다.

그러나 아래처럼일때 보다시피 32015 에러 발생

[oracle@enp0s3 dbhome_1]$ ./runInstaller -waitforcompletion -silent -responseFile /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_install.rsp oracle.install.db.config.starterdb.globalDBName=orcl oracle.install.db.config.starterdb.SID=orcl oracle.install.db.config.starterdb.memoryLimit=1024 oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE oracle.install.db.config.starterdb.SID=orcl INVENTORY_LOCATION=/u01/app/oraInventory ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 ORACLE_BASE=/u01/app/oracle oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=FILE_SYSTEM_STORAGE oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=FILE_SYSTEM_STORAGE Oracle Database 설정 마법사 실행 중... [FATAL] [INS-32015] 파일 위치에 대해 지정된 위치가 부적합합니다. 원인: 지정된 위치를 파일 위치에 대해 사용할 수 없습니다. 지정된 위치를 시스템에서 찾을 수 없거나 파일인 것으로 감지되었습니다. 작업: 파일 위치에 대한 적합한 위치를 지정하십시오. 설치 세션 로그 이동 위치: /u01/app/oraInventory/logs/InstallActions2021-11-09_01-04-52PM

https://oracle-base.com/articles/19c/oracle-db-19c-installation-on-oracle-linux-7

위 링크에서 참고해서 다음처럼 진행하니 완료됨.

[oracle@enp0s3 dbhome_1]$ ./runInstaller -ignorePrereq -waitforcompletion -silent -responseFile ${ORACLE_HOME}/install/response/db_install.rsp oracle.install.option=INSTALL_DB_SWONLY INVENTORY_LOCATION=/u01/app/oraInventory ORACLE_HOME=${ORACLE_HOME} ORACLE_BASE=${ORACLE_BASE} oracle.install.db.InstallEdition=EE oracle.install.db.OSDBA_GROUP=dba oracle.install.db.OSBACKUPDBA_GROUP=dba oracle.install.db.OSDGDBA_GROUP=dba oracle.install.db.OSKMDBA_GROUP=dba oracle.install.db.OSRACDBA_GROUP=dba SECURITY_UPDATES_VIA_MYORACLESUPPORT=false DECLINE_SECURITY_UPDATES=true Oracle Database 설정 마법사 실행 중... 이 세션에 대한 응답 파일을 다음에서 찾을 수 있습니다. /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_2021-11-09_01-14-06PM.rsp 다음 위치에서 이 설치 세션의 로그를 찾을 수 있습니다. /tmp/InstallActions2021-11-09_01-14-06PM/installActions2021-11-09_01-14-06PM.log 루트 사용자로 다음 스크립트를 실행합니다. 1. /u01/app/oraInventory/orainstRoot.sh 2. /u01/app/oracle/product/19.0.0/dbhome_1/root.sh 다음 노드에서 /u01/app/oraInventory/orainstRoot.sh을(를) 실행하십시오. [enp0s3] 다음 노드에서 /u01/app/oracle/product/19.0.0/dbhome_1/root.sh을(를) 실행하십시오. [enp0s3] Successfully Setup Software. 설치 세션 로그 이동 위치: /u01/app/oraInventory/logs/InstallActions2021-11-09_01-14-06PM [oracle@enp0s3 dbhome_1]$ su 암호: [root@enp0s3 dbhome_1]# /u01/app/oraInventory/orainstRoot.sh 다음 권한 변경 중/u01/app/oraInventory. 그룹에 대한 읽기, 쓰기 권한을 추가하는 중입니다. 월드에 대한 읽기, 쓰기, 실행 권한을 제거하는 중입니다. 그룹 이름 변경 중 /u01/app/oraInventory 대상 oinstall. 스크립트 실행이 완료되었습니다. [root@enp0s3 dbhome_1]# /u01/app/oracle/product/19.0.0/dbhome_1/root.sh Check /u01/app/oracle/product/19.0.0/dbhome_1/install/root_enp0s3_2021-11-09_13-19-17-979967125.log for the output of root script

그 내용은 다음과 같다.

[root@enp0s3 dbhome_1]# cat /u01/app/oraInventory/orainstRoot.sh

#!/bin/sh AWK=/bin/awk CHMOD=/bin/chmod CHGRP=/bin/chgrp CP=/bin/cp ECHO=/bin/echo MKDIR=/bin/mkdir RUID=`/usr/bin/id|$AWK -F\( '{print $1}'|$AWK -F\= '{print $2}'` if [ ${RUID} != "0" ];then $ECHO "이 스크립트는 루트로 실행해야 합니다." exit 1 fi if [ ! -d "/etc" ]; then $MKDIR -p /etc; fi $CHMOD 755 /etc; if [ -f "/u01/app/oraInventory/oraInst.loc" ]; then $CP /u01/app/oraInventory/oraInst.loc /etc/oraInst.loc; $CHMOD 644 /etc/oraInst.loc else INVPTR=/etc/oraInst.loc INVLOC=/u01/app/oraInventory GRP=oinstall PTRDIR="`dirname $INVPTR`"; # 소프트웨어 인벤토리 위치 포인터 파일 생성 if [ ! -d "$PTRDIR" ]; then $MKDIR -p $PTRDIR; fi $ECHO "Oracle 인벤토리 포인터 파일 생성 중 ($INVPTR)"; $ECHO inventory_loc=$INVLOC > $INVPTR $ECHO inst_group=$GRP >> $INVPTR chmod 644 $INVPTR # 존재하지 않는 경우 인벤토리 디렉토리 생성 if [ ! -d "$INVLOC" ];then $ECHO "Oracle 인벤토리 디렉토리 생성 중 ($INVLOC)"; $MKDIR -p $INVLOC; fi fi $ECHO "다음 권한 변경 중/u01/app/oraInventory. 그룹에 대한 읽기, 쓰기 권한을 추가하는 중입니다. 월드에 대한 읽기, 쓰기, 실행 권한을 제거하는 중입니다. "; $CHMOD -R g+rw,o-rwx /u01/app/oraInventory; if [ $? != 0 ]; then $ECHO "OUI-35086: 경고: 다음 chmod/u01/app/oraInventory 그룹에 대한 읽기, 쓰기 권한을 추가하는 중입니다. ,월드에 대한 읽기, 쓰기, 실행 권한을 제거하는 중입니다. 실패했습니다!"; fi $ECHO "그룹 이름 변경 중 /u01/app/oraInventory 대상 oinstall."; $CHGRP -R oinstall /u01/app/oraInventory; if [ $? != 0 ]; then $ECHO "OUI-10057: 경고: chgrp /u01/app/oraInventory 대상 oinstall 실패했습니다!"; fi $ECHO "스크립트 실행이 완료되었습니다."

이제 소프트웨어 설치를 완료했다. 데이터베이스를 생성할 준비가 되었다.

from http://xjhx.tistory.com/33 by ccl(A) rewrite - 2021-11-11 15:01:03