1. Database 19c 설치
A) 사전 준비
$DB_HOME 경로 생성 및 설치 파일 압축 해제
export DB_HOME=/u01/app/oracle/product/19.0.0/db_1 mkdir -p $DB_HOME unzip <설치 파일 다운로드 경로>/LINUX.X64_193000_db_home.zip -d $DB_HOME
[racdb1:/home/oracle]> export DB_HOME=/u01/app/oracle/product/19.0.0/db_1 [racdb1:/home/oracle]> db_env [racdb1:/home/oracle]> echo $ORACLE_HOME /u01/app/oracle/product/19.0.0/db_1 [racdb1:/home/oracle]> mkdir -p $DB_HOME [racdb1:/home/oracle]> unzip /media/sf_oracle/19.3/LINUX.X64_193000_db_home.zip -d $DB_HOME Archive: /media/sf_oracle/19.3/LINUX.X64_193000_db_home.zip creating: /u01/app/oracle/product/19.0.0/db_1/drdaas/ ... << 중략 >> ... extracting: /u01/app/oracle/product/19.0.0/db_1/install/.img.bin finishing deferred symbolic links: /u01/app/oracle/product/19.0.0/db_1/bin/lbuilder -> ../nls/lbuilder/lbuilder /u01/app/oracle/product/19.0.0/db_1/lib/libocci.so -> libocci.so.19.1 /u01/app/oracle/product/19.0.0/db_1/lib/libagtsh.so -> libagtsh.so.1.0 /u01/app/oracle/product/19.0.0/db_1/lib/libodm19.so -> libodmd19.so /u01/app/oracle/product/19.0.0/db_1/lib/libclntsh.so -> libclntsh.so.19.1 /u01/app/oracle/product/19.0.0/db_1/lib/libjavavm19.a -> ../javavm/jdk/jdk8/lib/libjavavm19.a /u01/app/oracle/product/19.0.0/db_1/javavm/lib/jce.jar -> ../../javavm/jdk/jdk8/lib/jce.jar /u01/app/oracle/product/19.0.0/db_1/lib/libocci.so.18.1 -> libocci.so /u01/app/oracle/product/19.0.0/db_1/lib/libclntshcore.so -> libclntshcore.so.19.1 /u01/app/oracle/product/19.0.0/db_1/jdk/bin/ControlPanel -> jcontrol /u01/app/oracle/product/19.0.0/db_1/javavm/admin/cbp.jar -> ../../javavm/jdk/jdk8/admin/cbp.jar /u01/app/oracle/product/19.0.0/db_1/lib/libclntsh.so.10.1 -> libclntsh.so /u01/app/oracle/product/19.0.0/db_1/lib/libclntsh.so.11.1 -> libclntsh.so /u01/app/oracle/product/19.0.0/db_1/lib/libclntsh.so.12.1 -> libclntsh.so /u01/app/oracle/product/19.0.0/db_1/lib/libclntsh.so.18.1 -> libclntsh.so /u01/app/oracle/product/19.0.0/db_1/precomp/public/SQLCA.H -> sqlca.h /u01/app/oracle/product/19.0.0/db_1/precomp/public/SQLDA.H -> sqlda.h /u01/app/oracle/product/19.0.0/db_1/precomp/public/ORACA.H -> oraca.h /u01/app/oracle/product/19.0.0/db_1/precomp/public/SQLCA.COB -> sqlca.cob /u01/app/oracle/product/19.0.0/db_1/precomp/public/ORACA.COB -> oraca.cob /u01/app/oracle/product/19.0.0/db_1/javavm/admin/classes.bin -> ../../javavm/jdk/jdk8/admin/classes.bin /u01/app/oracle/product/19.0.0/db_1/javavm/admin/libjtcjt.so -> ../../javavm/jdk/jdk8/admin/libjtcjt.so /u01/app/oracle/product/19.0.0/db_1/jdk/jre/bin/ControlPanel -> jcontrol /u01/app/oracle/product/19.0.0/db_1/javavm/admin/lfclasses.bin -> ../../javavm/jdk/jdk8/admin/lfclasses.bin /u01/app/oracle/product/19.0.0/db_1/javavm/lib/security/cacerts -> ../../../javavm/jdk/jdk8/lib/security/cacerts /u01/app/oracle/product/19.0.0/db_1/javavm/lib/sunjce_provider.jar -> ../../javavm/jdk/jdk8/lib/sunjce_provider.jar /u01/app/oracle/product/19.0.0/db_1/javavm/lib/security/README.txt -> ../../../javavm/jdk/jdk8/lib/security/README.txt /u01/app/oracle/product/19.0.0/db_1/javavm/lib/security/java.security -> ../../../javavm/jdk/jdk8/lib/security/java.security /u01/app/oracle/product/19.0.0/db_1/jdk/jre/lib/amd64/server/libjsig.so -> ../libjsig.so
B) Response 파일 생성
db19_install.rsp 파일 생성 (주요 파라미터 요약)
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0 oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1 ORACLE_BASE=/u01/app/oracle oracle.install.db.InstallEdition=EE oracle.install.db.OSDBA_GROUP=dba oracle.install.db.OSOPER_GROUP=oper oracle.install.db.OSBACKUPDBA_GROUP=backupdba oracle.install.db.OSDGDBA_GROUP=dgdba oracle.install.db.OSKMDBA_GROUP=kmdba oracle.install.db.OSRACDBA_GROUP=racdba oracle.install.db.rootconfig.executeRootScript=false oracle.install.db.CLUSTER_NODES=rac1,rac2
#################################################################### ## 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/db_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=racdba ################################################################################ # # # 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=false #-------------------------------------------------------------------------------------- # 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=rac1,rac2 ############################################################################### # # # 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=
C) 사전 검증
필요 조건 검사
$DB_HOME/runInstaller -silent -responseFile ~/db19_install.rsp -executePrereqs
[racdb1:/home/oracle]> $DB_HOME/runInstaller -silent -responseFile ~/db19_install.rsp -executePrereqs Oracle Database 설정 마법사 실행 중... 필요 조건 검사가 성공적으로 실행되었습니다.
D) 설치
설치 스크립트 실행
$DB_HOME/runInstaller -silent -responseFile ~/db19_install.rsp -waitForCompletion
[racdb1:/home/oracle]> $DB_HOME/runInstaller -silent -responseFile ~/db19_install.rsp -waitForCompletion
Oracle Database 설정 마법사 실행 중...
이 세션에 대한 응답 파일을 다음에서 찾을 수 있습니다.
/u01/app/oracle/product/19.0.0/db_1/install/response/db_2020-04-16_04-38-56PM.rsp
다음 위치에서 이 설치 세션의 로그를 찾을 수 있습니다.
/u01/app/oraInventory/logs/InstallActions2020-04-16_04-38-56PM/installActions2020-04-16_04-38-56PM.log
루트 사용자로 다음 스크립트를 실행합니다.
1. /u01/app/oracle/product/19.0.0/db_1/root.sh
다음 노드에서 /u01/app/oracle/product/19.0.0/db_1/root.sh을(를) 실행하십시오.
[rac1, rac2]
Successfully Setup Software.
E) root.sh 수행
모든 노드에서 root.sh 스크립트 실행
/u01/app/oracle/product/19.0.0/db_1/root.sh
[root@rac1 ~]# /u01/app/oracle/product/19.0.0/db_1/root.sh Check /u01/app/oracle/product/19.0.0/db_1/install/root_rac1_2020-04-16_16-48-26-139795997.log for the output of root script
[root@rac1 ~]# cat /u01/app/oracle/product/19.0.0/db_1/install/root_rac1_2020-04-16_16-48-26-139795997.log
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/19.0.0/db_1
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
[root@rac2 ~]# /u01/app/oracle/product/19.0.0/db_1/root.sh Check /u01/app/oracle/product/19.0.0/db_1/install/root_rac2_2020-04-16_16-48-41-195355083.log for the output of root script
[root@rac2 ~]# cat /u01/app/oracle/product/19.0.0/db_1/install/root_rac2_2020-04-16_16-48-41-195355083.log
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/19.0.0/db_1
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
{}
