創建response檔案 /home/oracle/db.rsp
[oracle@oracle ~]$ cat db.rsp #------------------------------------------------------------------------------- # Do not change the following system generated value. #------------------------------------------------------------------------------- oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 #------------------------------------------------------------------------------- # The installation option can be one of the following # 1. INSTALL_DB_SWONLY # 2. INSTALL_DB_AND_CONFIG # 3. UPGRADE_DB #------------------------------------------------------------------------------- oracle.install.option=INSTALL_DB_AND_CONFIG #------------------------------------------------------------------------------- # This variable holds the hostname of the system as set by the user. # 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=oracle.example.com #------------------------------------------------------------------------------- # Unix group to be set for the inventory directory. #------------------------------------------------------------------------------- UNIX_GROUP_NAME=oinstall #------------------------------------------------------------------------------- # Inventory location. #------------------------------------------------------------------------------- INVENTORY_LOCATION=/opt/oracle/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 # # Example : SELECTED_LANGUAGES=en,fr,ja #------------------------------------------------------------------------------- SELECTED_LANGUAGES=en #------------------------------------------------------------------------------- # Complete path of the Oracle Home #------------------------------------------------------------------------------- ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1 #------------------------------------------------------------------------------- # Complete path of the Oracle Base. #------------------------------------------------------------------------------- ORACLE_BASE=/opt/oracle #------------------------------------------------------------------------------- # 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 property is considered only if InstallEdition is EE. # # true : Components mentioned as part of 'customComponents' property # are considered for install. # false : Value for 'customComponents' is not considered. #------------------------------------------------------------------------------- oracle.install.db.isCustomInstall=false #------------------------------------------------------------------------------- # This property is considered only if 'IsCustomInstall' is set to true # # Description: List of Enterprise Edition Options you would like to install. # # 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 install. # # oracle.oraolap:11.2.0.0.2 - Oracle OLAP # oracle.rdbms.dm:11.2.0.0.2 - Oracle Data Mining RDBMS Files # oracle.rdbms.dv:11.2.0.0.2 - Oracle Database Vault option # oracle.rdbms.lbac:11.2.0.0.2 - Oracle Label Security # oracle.rdbms.partitioning:11.2.0.0.2 - Oracle Partitioning # oracle.rdbms.rat:11.2.0.0.2 - Oracle Real Application Testing # oracle.clrintg.ode_net:11.2.0.0.2 - Oracle Database Extensions for .NET 1.x (Windows) # oracle.clrintg.ode_net_2:11.2.0.0.2 - Oracle Database Extensions for .NET 2.0 (Windows) #------------------------------------------------------------------------------- oracle.install.db.customComponents= #------------------------------------------------------------------------------- oracle.install.db.DBA_GROUP=dba #------------------------------------------------------------------------------- oracle.install.db.OPER_GROUP=dba #------------------------------------------------------------------------------- # This variable represents the cluster node names selected by the . # user for installation #------------------------------------------------------------------------------- oracle.install.db.CLUSTER_NODES= #------------------------------------------------------------------------------- # One of the following # - GENERAL_PURPOSE # - TRANSACTION_PROCESSING # - DATAWAREHOUSE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.type=GENERAL_PURPOSE #------------------------------------------------------------------------------- # Global Database Name #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.globalDBName=orcl.example.com #------------------------------------------------------------------------------- # The Starter Database SID #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.SID=orcl #------------------------------------------------------------------------------- # 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=AL32UTF8 #------------------------------------------------------------------------------- # Specify the total memory allocation for the database. (in MB) # Value 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=40 #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.memoryLimit=6218 oracle.install.db.config.starterdb.memoryOption=true #------------------------------------------------------------------------------- # This variable controls whether to load Example Schemas onto # the starter database or not. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.installExampleSchemas=true #------------------------------------------------------------------------------- # This include enabling audit settings, configuring password # profiles and revoking some grants to public. These settings # are provided by default. You may choose to disable all. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.enableSecuritySettings=true #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.ALL= #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYS= #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSTEM= #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.SYSMAN= #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.password.DBSNMP= #------------------------------------------------------------------------------- # Can be one of the following # 1. GRID_CONTROL # 2. DB_CONTROL # oracle.install.db.config.starterdb.control=DB_CONTROL #------------------------------------------------------------------------------- # Determines the Management Service to use if Grid Control # is selected to manage the database. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL= #------------------------------------------------------------------------------- # Determines whether to receive email notification for # critical alerts when using DB control. #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.dbcontrol.emailAddress= #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.dbcontrol.SMTPServer= #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.automatedBackup.enable=false #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.automatedBackup.osuid= #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.automatedBackup.ospwd= #------------------------------------------------------------------------------- # Can be one of the following # - FILE_SYSTEM_STORAGE # - ASM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE #------------------------------------------------------------------------------- # Database file location: # 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=/opt/oracle/oradata #------------------------------------------------------------------------------- # Backup and recovery location # # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= #------------------------------------------------------------------------------- # Name of ASM disk group to be used for storage. # # Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE #------------------------------------------------------------------------------- oracle.install.db.config.asm.diskGroup= #------------------------------------------------------------------------------- # 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=metalink #------------------------------------------------------------------------------ MYORACLESUPPORT_USERNAME=neo.chen@msn.com #------------------------------------------------------------------------------ # 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 wants to give any proxy details for connection. # 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=false #------------------------------------------------------------------------------ # 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 atleast 2 chars. # # Example : PROXY_PORT=25 #------------------------------------------------------------------------------ PROXY_PORT=
/home/oracle/orains.sh
#!/bin/bash ORACLE_BASE=/opt/oracle ORACLE_PASSWORD="oracle" groupadd oinstall groupadd dba useradd -m -g oinstall -G dba oracle echo "oracle:$ORACLE_PASSWORD" | chpasswd mkdir -p $ORACLE_BASE chown -R oracle:oinstall $ORACLE_BASE chmod -R 775 $ORACLE_BASE cat >> /etc/sysctl.conf <<EOF fs.aio-max-nr = 3145728 fs.file-max = 6815744 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.shmmni = 4096 kernel.sem = 250 32000 100 142 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 EOF cat >> /etc/security/limits.conf <<EOF oracle soft nproc 2048 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 EOF cat >> /home/oracle/.bash_profile <<\EOF export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=$(hostname) export ORACLE_BASE=/opt/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 export ORACLE_SID=orcl export ORACLE_TERM=xterm export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib64:/usr/lib64:/usr/local/lib64 export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib export LD_ASSUME_KERNEL=2.6.18 export NLS_LANG="american_america.UTF8" export NLS_LANG="AMERICAN_AMERICA.US7ASCII" #export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK" #export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK" #export NLS_LANG="TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950" #export NLS_LANG="JAPANESE_JAPAN.WE8MSWIN1252" EOF cat >> /home/oracle/.bashrc <<\EOF alias sysdba='sqlplus "/ as sysdba"' EOF cat >> /etc/oraInst.loc <<EOF inventory_loc=$ORACLE_BASE/oraInventory inst_group=oinstall EOF chmod 664 /etc/oraInst.loc cat >> /etc/yum.repos.d/rhel-source-local.repo <<\EOF [rhel-source-local] name=Red Hat Enterprise Linux $releasever - Source baseurl=file:///media/cdrom0/Server enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release EOF yum install gcc gcc-c++ glibc-devel libstdc++ libstdc++-devel libaio-devel sysstat libaio-devel elfutils-libelf-devel unixODBC unixODBC-devel
su - root /home/oracle/orains.sh