cd <설치 파일 압축해제 경로>/database/sshsetup ./sshUserSetup.sh -user oracle -hosts "oraw1 oraw2" -noPromptPassphrase -advanced
[oracle@orawdb1 ~]$ cd /media/sf_oracle/database/sshsetup [oracle@orawdb1 sshsetup]$ ./sshUserSetup.sh -user oracle -hosts "oraw1 oraw2" -noPromptPassphrase -advanced The output of this script is also logged into /tmp/sshUserSetup_2019-04-04-15-05-32.log Hosts are oraw1 oraw2 user is oracle Platform:- Linux Checking if the remote hosts are reachable PING oraw1 (10.0.1.101) 56(84) bytes of data. 64 bytes from oraw1 (10.0.1.101): icmp_seq=1 ttl=64 time=0.014 ms 64 bytes from oraw1 (10.0.1.101): icmp_seq=2 ttl=64 time=0.043 ms 64 bytes from oraw1 (10.0.1.101): icmp_seq=3 ttl=64 time=0.023 ms 64 bytes from oraw1 (10.0.1.101): icmp_seq=4 ttl=64 time=0.023 ms 64 bytes from oraw1 (10.0.1.101): icmp_seq=5 ttl=64 time=0.022 ms --- oraw1 ping statistics --- 5 packets transmitted, 5 received, 0% packet loss, time 4002ms rtt min/avg/max/mdev = 0.014/0.025/0.043/0.009 ms PING oraw2 (10.0.1.102) 56(84) bytes of data. 64 bytes from oraw2 (10.0.1.102): icmp_seq=1 ttl=64 time=0.262 ms 64 bytes from oraw2 (10.0.1.102): icmp_seq=2 ttl=64 time=0.323 ms 64 bytes from oraw2 (10.0.1.102): icmp_seq=3 ttl=64 time=0.311 ms 64 bytes from oraw2 (10.0.1.102): icmp_seq=4 ttl=64 time=0.354 ms 64 bytes from oraw2 (10.0.1.102): icmp_seq=5 ttl=64 time=0.301 ms --- oraw2 ping statistics --- 5 packets transmitted, 5 received, 0% packet loss, time 4001ms rtt min/avg/max/mdev = 0.262/0.310/0.354/0.031 ms Remote host reachability check succeeded. The following hosts are reachable: oraw1 oraw2. The following hosts are not reachable: . All hosts are reachable. Proceeding further... firsthost oraw1 numhosts 2 The script will setup SSH connectivity from the host oraw1 to all the remote hosts. After the script is executed, the user can use SSH to run commands on the remote hosts or copy files between this host oraw1 and the remote hosts without being prompted for passwords or confirmations. NOTE 1: As part of the setup procedure, this script will use ssh and scp to copy files between the local host and the remote hosts. Since the script does not store passwords, you may be prompted for the passwords during the execution of the script whenever ssh or scp is invoked. NOTE 2: AS PER SSH REQUIREMENTS, THIS SCRIPT WILL SECURE THE USER HOME DIRECTORY AND THE .ssh DIRECTORY BY REVOKING GROUP AND WORLD WRITE PRIVILEDGES TO THESE directories. Do you want to continue and let the script make the above mentioned changes (yes/no)? yes The user chose yes User chose to skip passphrase related questions. Creating .ssh directory on local host, if not present already Creating authorized_keys file on local host Changing permissions on authorized_keys to 644 on local host Creating known_hosts file on local host Changing permissions on known_hosts to 644 on local host Creating config file on local host If a config file exists already at /home/oracle/.ssh/config, it would be backed up to /home/oracle/.ssh/config.backup. Removing old private/public keys on local host Running SSH keygen on local host with empty passphrase Generating public/private rsa key pair. Your identification has been saved in /home/oracle/.ssh/id_rsa. Your public key has been saved in /home/oracle/.ssh/id_rsa.pub. The key fingerprint is: 1e:90:15:60:59:3e:4d:aa:b5:2b:fd:e9:70:b2:52:0b oracle@oraw1 The key's randomart image is: +--[ RSA 1024]----+ | o++.. | | ..+ + | | o = . | | + o | | . S | | Eo.o | | .o*.. | | ...* . | | ...+ | +-----------------+ Creating .ssh directory and setting permissions on remote host oraw1 THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT. The script would create ~oracle/.ssh/config file on remote host oraw1. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup. The user may be prompted for a password here since the script would be running SSH on host oraw1. Warning: Permanently added 'oraw1,10.0.1.101' (RSA) to the list of known hosts. oracle@oraw1's password: Done with creating .ssh directory and setting permissions on remote host oraw1. Creating .ssh directory and setting permissions on remote host oraw2 THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT. The script would create ~oracle/.ssh/config file on remote host oraw2. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup. The user may be prompted for a password here since the script would be running SSH on host oraw2. Warning: Permanently added 'oraw2,10.0.1.102' (RSA) to the list of known hosts. oracle@oraw2's password: Done with creating .ssh directory and setting permissions on remote host oraw2. Copying local host public key to the remote host oraw1 The user may be prompted for a password or passphrase here since the script would be using SCP for host oraw1. oracle@oraw1's password: Done copying local host public key to the remote host oraw1 Copying local host public key to the remote host oraw2 The user may be prompted for a password or passphrase here since the script would be using SCP for host oraw2. oracle@oraw2's password: Done copying local host public key to the remote host oraw2 Creating keys on remote host oraw1 if they do not exist already. This is required to setup SSH on host oraw1. Creating keys on remote host oraw2 if they do not exist already. This is required to setup SSH on host oraw2. Generating public/private rsa key pair. Your identification has been saved in .ssh/id_rsa. Your public key has been saved in .ssh/id_rsa.pub. The key fingerprint is: ba:1a:9a:b1:9c:d2:af:db:8b:a7:f1:02:a9:b4:b3:ff oracle@oraw2 The key's randomart image is: +--[ RSA 1024]----+ | | | | | | | | | . S | |o. . | |oo+ . . | |o+o@.. . | | o#OBE. | +-----------------+ Updating authorized_keys file on remote host oraw1 Updating known_hosts file on remote host oraw1 Updating authorized_keys file on remote host oraw2 Updating known_hosts file on remote host oraw2 cat: /home/oracle/.ssh/known_hosts.tmp: 그런 파일이나 디렉터리가 없습니다 cat: /home/oracle/.ssh/authorized_keys.tmp: 그런 파일이나 디렉터리가 없습니다 SSH setup is complete. ------------------------------------------------------------------------ Verifying SSH setup =================== The script will now run the date command on the remote nodes using ssh to verify if ssh is setup correctly. IF THE SETUP IS CORRECTLY SETUP, THERE SHOULD BE NO OUTPUT OTHER THAN THE DATE AND SSH SHOULD NOT ASK FOR PASSWORDS. If you see any output other than date or are prompted for the password, ssh is not setup correctly and you will need to resolve the issue and set up ssh again. The possible causes for failure could be: 1. The server settings in /etc/ssh/sshd_config file do not allow ssh for user oracle. 2. The server may have disabled public key based authentication. 3. The client public key on the server may be outdated. 4. ~oracle or ~oracle/.ssh on the remote host may not be owned by oracle. 5. User may not have passed -shared option for shared remote users or may be passing the -shared option for non-shared remote users. 6. If there is output in addition to the date, but no password is asked, it may be a security alert shown as part of company policy. Append the additional text to the <OMS HOME>/sysman/prov/resources/ignoreMessages.txt file. ------------------------------------------------------------------------ --oraw1:-- Running /usr/bin/ssh -x -l oracle oraw1 date to verify SSH connectivity has been setup from local host to oraw1. IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR. 2019. 04. 04. (목) 15:05:53 KST ------------------------------------------------------------------------ --oraw2:-- Running /usr/bin/ssh -x -l oracle oraw2 date to verify SSH connectivity has been setup from local host to oraw2. IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR. 2019. 04. 04. (목) 15:05:53 KST ------------------------------------------------------------------------ ------------------------------------------------------------------------ Verifying SSH connectivity has been setup from oraw1 to oraw1 IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. bash: -c: line 0: unexpected EOF while looking for matching `"' bash: -c: line 1: syntax error: unexpected end of file ------------------------------------------------------------------------ ------------------------------------------------------------------------ Verifying SSH connectivity has been setup from oraw1 to oraw2 IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. bash: -c: line 0: unexpected EOF while looking for matching `"' bash: -c: line 1: syntax error: unexpected end of file ------------------------------------------------------------------------ -Verification from complete- SSH verification complete.
ssh oraw1 date ssh oraw2 date ssh oraw1-priv date ssh oraw2-priv date
[oracle@orawdb1 ~]$ ssh oraw1 date 2019. 04. 04. (목) 15:06:23 KST [oracle@orawdb1 ~]$ ssh oraw2 date 2019. 04. 04. (목) 15:06:25 KST [oracle@orawdb1 ~]$ ssh oraw1-priv date The authenticity of host 'oraw1-priv (10.0.5.101)' can't be established. RSA key fingerprint is 12:cf:8a:65:85:4c:2d:9d:bd:b8:92:3f:49:6c:2d:a9. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added 'oraw1-priv,10.0.5.101' (RSA) to the list of known hosts. 2019. 04. 04. (목) 15:06:32 KST [oracle@orawdb1 ~]$ ssh oraw2-priv date The authenticity of host 'oraw2-priv (10.0.5.102)' can't be established. RSA key fingerprint is 12:cf:8a:65:85:4c:2d:9d:bd:b8:92:3f:49:6c:2d:a9. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added 'oraw2-priv,10.0.5.102' (RSA) to the list of known hosts. 2019. 04. 04. (목) 15:06:36 KST
[oracle@orawdb2 ~]$ ssh oraw1 date 2019. 04. 04. (목) 15:06:58 KST [oracle@orawdb2 ~]$ ssh oraw2 date 2019. 04. 04. (목) 15:07:00 KST [oracle@orawdb2 ~]$ ssh oraw1-priv date The authenticity of host 'oraw1-priv (10.0.5.101)' can't be established. RSA key fingerprint is 12:cf:8a:65:85:4c:2d:9d:bd:b8:92:3f:49:6c:2d:a9. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added 'oraw1-priv,10.0.5.101' (RSA) to the list of known hosts. 2019. 04. 04. (목) 15:07:06 KST [oracle@orawdb2 ~]$ ssh oraw2-priv date The authenticity of host 'oraw2-priv (10.0.5.102)' can't be established. RSA key fingerprint is 12:cf:8a:65:85:4c:2d:9d:bd:b8:92:3f:49:6c:2d:a9. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added 'oraw2-priv,10.0.5.102' (RSA) to the list of known hosts. 2019. 04. 04. (목) 15:07:10 KST
chmod 775 /u01/app/oracle
[root@oraw1 ~]# chmod 775 /u01/app/oracle
[root@oraw2 ~]# chmod 775 /u01/app/oracle
cp <설치 파일 압축해제 경로>/database/response/db_install.rsp ~/. vi ~/db_install.rsp
#################################################################### ## Copyright(c) Oracle Corporation 1998,2013. 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_v11_2_0 #------------------------------------------------------------------------------ # Specify the installation option. # It can be one of the following: # - INSTALL_DB_SWONLY # - INSTALL_DB_AND_CONFIG # - UPGRADE_DB #------------------------------------------------------------------------------- oracle.install.option=INSTALL_DB_SWONLY #------------------------------------------------------------------------------- # Specify the hostname of the system as set during the install. It can be used # to force the installation to use an alternative hostname rather than using the # first hostname found on the system. (e.g., for systems with multiple hostnames # and network interfaces) #------------------------------------------------------------------------------- ORACLE_HOSTNAME=oraw1 #------------------------------------------------------------------------------- # 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 languages in which the components will be installed. # # en : English ja : Japanese # fr : French ko : Korean # ar : Arabic es : Latin American Spanish # bn : Bengali lv : Latvian # pt_BR: Brazilian Portuguese lt : Lithuanian # bg : Bulgarian ms : Malay # fr_CA: Canadian French es_MX: Mexican Spanish # ca : Catalan no : Norwegian # hr : Croatian pl : Polish # cs : Czech pt : Portuguese # da : Danish ro : Romanian # nl : Dutch ru : Russian # ar_EG: Egyptian zh_CN: Simplified Chinese # en_GB: English (Great Britain) sk : Slovak # et : Estonian sl : Slovenian # fi : Finnish es_ES: Spanish # de : German sv : Swedish # el : Greek th : Thai # iw : Hebrew zh_TW: Traditional Chinese # hu : Hungarian tr : Turkish # is : Icelandic uk : Ukrainian # in : Indonesian vi : Vietnamese # it : Italian # # all_langs : All languages # # Specify value as the following to select any of the languages. # Example : SELECTED_LANGUAGES=en,fr,ja # # Specify value as the following to select all the languages. # Example : SELECTED_LANGUAGES=all_langs #------------------------------------------------------------------------------ SELECTED_LANGUAGES=en,ko #------------------------------------------------------------------------------ # Specify the complete path of the Oracle Home. #------------------------------------------------------------------------------ ORACLE_HOME=/u01/app/oracle/product/11.2.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 # - SE : Standard Edition # - SEONE : Standard Edition One # - PE : Personal Edition (WINDOWS ONLY) #------------------------------------------------------------------------------ oracle.install.db.InstallEdition=EE #------------------------------------------------------------------------------ # This variable is used to enable or disable custom install and is considered # only if InstallEdition is EE. # # true : Components mentioned as part of 'optionalComponents' property # are considered for install. # false : Value for 'optionalComponents' is not considered. #------------------------------------------------------------------------------ oracle.install.db.EEOptionsSelection=false #------------------------------------------------------------------------------ # This variable is considered only if 'EEOptionsSelection' is set to true. # # Description: List of Enterprise Edition Options you would like to enable. # # The following choices are available. You may specify any # combination of these choices. The components you choose should # be specified in the form "internal-component-name:version" # Below is a list of components you may specify to enable. # # oracle.oraolap:11.2.0.4.0 - Oracle OLAP # oracle.rdbms.dm:11.2.0.4.0 - Oracle Data Mining # oracle.rdbms.dv:11.2.0.4.0 - Oracle Database Vault # oracle.rdbms.lbac:11.2.0.4.0 - Oracle Label Security # oracle.rdbms.partitioning:11.2.0.4.0 - Oracle Partitioning # oracle.rdbms.rat:11.2.0.4.0 - Oracle Real Application Testing #------------------------------------------------------------------------------ oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0 ############################################################################### # # # PRIVILEGED OPERATING SYSTEM GROUPS # # ------------------------------------------ # # Provide values for the OS groups to which OSDBA and OSOPER 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 DBA_GROUP is the OS group which is to be granted OSDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.DBA_GROUP=dba #------------------------------------------------------------------------------ # The OPER_GROUP is the OS group which is to be granted OSOPER privileges. # The value to be specified for OSOPER group is optional. #------------------------------------------------------------------------------ oracle.install.db.OPER_GROUP=oper #------------------------------------------------------------------------------ # Specify the cluster node names selected during the installation. # Example : oracle.install.db.CLUSTER_NODES=node1,node2 #------------------------------------------------------------------------------ oracle.install.db.CLUSTER_NODES=oraw1,oraw2 #------------------------------------------------------------------------------ # This variable is used to enable or disable RAC One Node install. # # - true : Value of RAC One Node service name is used. # - false : Value of RAC One Node service name is not used. # # If left blank, it will be assumed to be false #------------------------------------------------------------------------------ oracle.install.db.isRACOneInstall=false #------------------------------------------------------------------------------ # Specify the name for RAC One Node Service. #------------------------------------------------------------------------------ oracle.install.db.racOneServiceName= #------------------------------------------------------------------------------ # Specify the type of database to create. # It can be one of the following: # - GENERAL_PURPOSE/TRANSACTION_PROCESSING # - DATA_WAREHOUSE #------------------------------------------------------------------------------ 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 the Starter Database character set. # # It can be 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=AL32UTF8 #------------------------------------------------------------------------------ # 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=false #------------------------------------------------------------------------------ # 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. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.installExampleSchemas=false #------------------------------------------------------------------------------ # This variable includes enabling audit settings, configuring password profiles # and revoking some grants to public. These settings are provided by default. # These settings may also be disabled. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.enableSecuritySettings=true ############################################################################### # # # Passwords can be supplied for the following four schemas in the # # starter database: # # SYS # # SYSTEM # # SYSMAN (used by Enterprise Manager) # # 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 SYSMAN password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSMAN= #------------------------------------------------------------------------------- # Specify the DBSNMP password for the starter database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.DBSNMP= #------------------------------------------------------------------------------- # Specify the management option to be selected for the starter database. # It can be one of the following: # - GRID_CONTROL # - DB_CONTROL #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.control=DB_CONTROL #------------------------------------------------------------------------------- # Specify the Management Service to use if Grid Control is selected to manage # the database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL= ############################################################################### # # # SPECIFY BACKUP AND RECOVERY OPTIONS # # ------------------------------------ # # Out-of-box backup and recovery options for the database can be mentioned # # using the entries below. # # # ############################################################################### #------------------------------------------------------------------------------ # This variable is to be set to false if automated backup is not required. Else # this can be set to true. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.automatedBackup.enable=false #------------------------------------------------------------------------------ # Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily to backup # the database. This job will run as the operating system user that is # specified in this variable. #------------------------------------------------------------------------------ oracle.install.db.config.starterdb.automatedBackup.osuid= #------------------------------------------------------------------------------- # Regardless of the type of storage that is chosen for backup and recovery, if # automated backups are enabled, a job will be scheduled to run daily to backup # the database. This job will run as the operating system user specified by the # above entry. The following entry stores the password for the above operating # system user. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.automatedBackup.ospwd= #------------------------------------------------------------------------------- # 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 backup and 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.storage=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= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username. # # Example : MYORACLESUPPORT_USERNAME=abc@oracle.com #------------------------------------------------------------------------------ MYORACLESUPPORT_USERNAME= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username password. # # Example : MYORACLESUPPORT_PASSWORD=password #------------------------------------------------------------------------------ MYORACLESUPPORT_PASSWORD= #------------------------------------------------------------------------------ # Specify whether to enable the user to set the password for # My Oracle Support credentials. The value can be either true or false. # If left blank it will be assumed to be false. # # Example : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true #------------------------------------------------------------------------------ SECURITY_UPDATES_VIA_MYORACLESUPPORT=false #------------------------------------------------------------------------------ # Specify whether user doesn't want to configure Security Updates. # The value for this variable should be true if you don't want to configure # Security Updates, false otherwise. # # The value can be either true or false. If left blank it will be assumed # to be false. # # Example : DECLINE_SECURITY_UPDATES=false #------------------------------------------------------------------------------ DECLINE_SECURITY_UPDATES=true #------------------------------------------------------------------------------ # Specify the Proxy server name. Length should be greater than zero. # # Example : PROXY_HOST=proxy.domain.com #------------------------------------------------------------------------------ PROXY_HOST= #------------------------------------------------------------------------------ # Specify the proxy port number. Should be Numeric and at least 2 chars. # # Example : PROXY_PORT=25 #------------------------------------------------------------------------------ PROXY_PORT= #------------------------------------------------------------------------------ # Specify the proxy user name. Leave PROXY_USER and PROXY_PWD # blank if your proxy server requires no authentication. # # Example : PROXY_USER=username #------------------------------------------------------------------------------ PROXY_USER= #------------------------------------------------------------------------------ # Specify the proxy password. Leave PROXY_USER and PROXY_PWD # blank if your proxy server requires no authentication. # # Example : PROXY_PWD=password #------------------------------------------------------------------------------ PROXY_PWD= #------------------------------------------------------------------------------ # Specify the proxy realm. This value is used if auto-updates option is selected. # # Example : PROXY_REALM=metalink #------------------------------------------------------------------------------ PROXY_REALM= #------------------------------------------------------------------------------ # Specify the Oracle Support Hub URL. # # Example : COLLECTOR_SUPPORTHUB_URL=https://orasupporthub.company.com:8080/ #------------------------------------------------------------------------------ COLLECTOR_SUPPORTHUB_URL= #------------------------------------------------------------------------------ # Specify the auto-updates option. It can be one of the following: # - MYORACLESUPPORT_DOWNLOAD # - OFFLINE_UPDATES # - SKIP_UPDATES #------------------------------------------------------------------------------ oracle.installer.autoupdates.option= #------------------------------------------------------------------------------ # In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where # the updates are to be downloaded. # In case OFFLINE_UPDATES option is chosen, specify the location where the updates # are present. #------------------------------------------------------------------------------ oracle.installer.autoupdates.downloadUpdatesLoc= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username which has the patches download privileges # to be used for software updates. # Example : AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com #------------------------------------------------------------------------------ AUTOUPDATES_MYORACLESUPPORT_USERNAME= #------------------------------------------------------------------------------ # Specify the My Oracle Support Account Username password which has the patches download privileges # to be used for software updates. # # Example : AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password #------------------------------------------------------------------------------ AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
cd <설치 파일 압축해제 경로>/database ./runInstaller -silent -responseFile ~/db_install.rsp -ignorePrereq -ignoreSysPreReqs
[oracle@orawdb1 database]$ ./runInstaller -silent -responseFile /media/sf_oracle/db_install.rsp -ignorePrereq -ignoreSysPreReqs
Oracle Universal Installer 시작 중...
임시 공간 확인 중: 120MB 이상이어야 합니다.. 실제 17489MB 성공
스왑 공간 확인 중: 150MB 이상이어야 합니다.. 실제 4051MB 성공
다음에서 Oracle Universal Installer의 시작을 준비하는 중 /tmp/OraInstall2019-04-04_03-18-43PM. 기다리십시오.[oracle@orawdb1 database]$ 다음 위치에서 이 설치 세션의 로그를 찾을 수 있습니다.
/u01/app/oraInventory/logs/installActions2019-04-04_03-18-43PM.log
Oracle Database 11g의 설치을(를) 성공했습니다.
자세한 내용은 '/u01/app/oraInventory/logs/silentInstall2019-04-04_03-18-43PM.log'을(를) 확인하십시오.
루트 사용자로 다음 스크립트를 실행합니다.
1. /u01/app/oracle/product/11.2.0/db_1/root.sh
다음 노드에서 /u01/app/oracle/product/11.2.0/db_1/root.sh을(를) 실행하십시오.
[oraw1, oraw2]
Successfully Setup Software.
/u01/app/oracle/product/11.2.0/db_1/root.sh
[root@oraw1 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh Check /u01/app/oracle/product/11.2.0/db_1/install/root_oraw1_2019-04-04_15-32-45.log for the output of root script
[root@oraw2 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh Check /u01/app/oracle/product/11.2.0/db_1/install/root_oraw2_2019-04-04_15-32-52.log for the output of root script
