CentOS 7.4 静默安装Oracle 11g R2操作总结
前提规划工作：
查看操作系统的版本：
cat /etc/redhat-release
CentOS Linux release 7.4.1708 (Core)
内核的版本：
uname -a
Linux onecardbk 3.10.0-693.el7.x86_64 #1 SMP Tue Aug 22 21:09:27 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
查看服务器的名字：
hostname
修改主机名并在hosts解析
vi /etc/hostname
HOSTNAME=bjdb
vi /etc/hosts
172.10.8.237 bjdb
查看内存的大小
内存大小：
free -h
total used free shared buffers cached
Mem: 3832 204 3627 0 10 63
-/+ buffers/cache: 131 3701
Swap: 7999 0 7999
IP：172.10.8.237
数据库名：orcl
挂在镜像（系统安装包）
mount /dev/cdrom /mnt --将光盘挂在到/mnt目录下
mount /dev/cdrom /media --将光盘挂在到/media目录下
卸载镜像
umount /mnt
umount /media
此处为2个挂载点，使用其中之一即可
Centos 7.4yum配置
首先将/etc/yum.repos.d/CentOS-Base.repo文件重命名为CentOS-Base.repo.bak
mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.bak
然后修改CentOS-Media.repo文件如下：
vi /etc/yum.repos.d/CentOS-Media.repo
[c7-media]
name=CentOS-$releasever - Media
baseurl=file:///media
gpgcheck=1
enabled=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
1、关闭防火墙
关闭防火墙
systemctl stop firewalld
查看防火墙状态
systemctl status firewalld
禁止开机启动
systemctl disable firewalld
关闭selinux
vi /etc/selinux/config
#SELINUX=enforcing
SEIINUX=disabled
二、检查oracle所需的包：
参考官方文档如下：
rpm -qa|grep 包名
The following or later version of packages for Oracle Linux 6, and Red Hat Enterprise Linux 6 must be installed:
rpm -ivh binutils-2.25.1-31.base.el7.x86_64.rpm
rpm -ivh compat-libcap1-1.10-7.el7.x86_64.rpm
rpm -ivh glibc-2.17-196.el7.x86_64.rpm
rpm -ivh glibc-devel-2.17-196.el7.x86_64.rpm
rpm -ivh ksh-20120801-34.el7.x86_64.rpm
rpm -ivh libgcc-4.8.5-16.el7.x86_64.rpm
rpm -ivh libstdc++-4.8.5-16.el7.x86_64.rpm
rpm -ivh libstdc++-devel-4.8.5-16.el7.x86_64.rpm
rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm
rpm -ivh libaio-devel-0.3.109-13.el7.x86_64.rpm
rpm -ivh make-3.82-23.el7.x86_64.rpm
yum install gcc-4.8.5-16.el7.x86_64
yum install gcc-c++-4.8.5-16.el7.x86_64
yum install sysstat-10.1.5-12.el7.x86_64
yum install elfutils-libelf-devel-0.168-8.el7.x86_64
yum install unixODBC-2.3.1-11.el7.x86_64
yum install unixODBC-devel-2.3.1-11.el7.x86_64
yum install -y unzip zip
会缺少libreadline.so.5()；libtermcap.so.2
可以通过
yum provides libtermcap.so.2 ----查看属于哪个包，经验证为下面两个包
compat-readline5-5.2-17.1.el6.i686.rpm
compat-libtermcap-2.0.8-49.el6.i686.rpm
安装rlwrap
rpm -ivh rlwrap-0.41-1.el5.x86_64.rpm
三、配置核心参数：
vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
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
sysctl -p 立即生效
四、修改oracle用户资源限制：
shell资源 资源名 软限制 硬限制
打开文件描述符 nofile 最小1024 最小65536
单个用户可用进程数 nproc 最小2047 最小16384
进程堆栈段的大小 stack 最小10240 KB 最小10240KB，通常32768KB
查看用户的上述资源限制：
oracle用户：
ulimit -Sn nofile 软限制
ulimit -Hn nofile 硬限制
ulimit -Su nproc 软限制
ulimit -Hu nproc 硬限制
ulimit -Ss stack 软限制
ulimit -Hs stack 硬限制
修改资源限制
vi /etc/security/limits.conf
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
五、修改login
login文件：登陆以后自动启动limits（限制文件）。
[root@node1 ~]# vi /etc/pam.d/login
添加：
session required /lib64/security/pam_limits.so
session required pam_limits.so
六、创建组和用户：
groupadd oinstall
groupadd dba
查看用户组：
cat /etc/group
添加用户：
useradd oracle -g oinstall -G dba
设置密码：
passwd oracle
七、创建安装目录，并修改属性
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oraInventory
chown -R oracle:oinstall /u01/app
chmod -R 775 /u01/app
八、设置全局环境变量
vi /etc/profile
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
source /etc/profile
八、修改oracle的环境文件.bash_profile
oracle
vi /home/oracle/.bash_profile
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/db_1
ORACLE_SID=orcl
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
#alias sqlplus='rlwrap sqlplus'
#alias rman='rlwrap rman'
NLS_LANG="simplified chinese"_china.AL32UTF8
export NLS_LANG
export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
export NLS_TIMESTAMP_FORMAT='yyyy-mm-dd HH24:MI:SSXFF'
export NLS_TIMESTAMP_TZ_FORMAT='yyyy-mm-dd HH24:MI:SSXFF TZR'
九、安装oracle软件
1、解压缩
unzip p13390677_112040_Linux-x86-64_1of7.zip
unzip p13390677_112040_Linux-x86-64_2of7.zip
解压后得到database目录，其中包含response目录，该目录中有三个rsp文件，用来作为静默安装时的应答文件的模板。三个文件作用分别是：
db_install.rsp：安装应答
dbca.rsp：创建数据库应答
netca.rsp：建立监听、本地服务名等网络设置的应答
2、修改database属组
chown -R oracle:oinstall database/
3、修改配置文件，安装oracle软件
cp /u01/database/response/* /home/oracle
4、修改后的静默安装配置文件db_install.rsp，如果oracle用户没有操作文件的权限，可使用root用户修改该文件，保存退出即可，修改相关的配置项，修改后的文件内容如下：
db_install.rsp配置文件：
####################################################################
#Copyright© 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=bjdb
#-------------------------------------------------------------------------------
#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,zh_CN
#------------------------------------------------------------------------------
#Specify the complete path of the Oracle Home.
#------------------------------------------------------------------------------
ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/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=oinstall
#------------------------------------------------------------------------------
#Specify the cluster node names selected during the installation.
#Example : oracle.install.db.CLUSTER_NODES=node1,node2
#------------------------------------------------------------------------------
#------------------------------------------------------------------------------
oracle.install.db.CLUSTER_NODES=
#------------------------------------------------------------------------------
#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=
#------------------------------------------------------------------------------
#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=GENERAL_PURPOSE
#------------------------------------------------------------------------------
#Specify the Starter Database Global Database Name.
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.globalDBName=orcl
#------------------------------------------------------------------------------
#Specify the Starter Database SID.
#------------------------------------------------------------------------------
oracle.install.db.config.starterdb.SID=orcl
#------------------------------------------------------------------------------
#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=true
#------------------------------------------------------------------------------
#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=2048
#------------------------------------------------------------------------------
#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=oracle
#-------------------------------------------------------------------------------
#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=FILE_SYSTEM_STORAGE
#-------------------------------------------------------------------------------
#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=
#------------------------------------------------------------------------------
#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=
查看配置结果：
less /home/oracle/db_install.rsp |grep -v "#"|grep -v "^$"
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=bjdb
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=false
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
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.CLUSTER_NODES=
oracle.install.db.isRACOneInstall=
oracle.install.db.racOneServiceName=
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=orcl
oracle.install.db.config.starterdb.SID=orcl
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=2048
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.password.ALL=oracle
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=
oracle.install.db.config.starterdb.control=DB_CONTROL
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
oracle.install.db.config.starterdb.automatedBackup.enable=false
oracle.install.db.config.starterdb.automatedBackup.osuid=
oracle.install.db.config.starterdb.automatedBackup.ospwd=
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=
DECLINE_SECURITY_UPDATES=true
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
PROXY_REALM=
COLLECTOR_SUPPORTHUB_URL=
oracle.installer.autoupdates.option=
oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
5、开始静默安装
su - oracle
cd /u01/database
./runInstaller -silent -ignorePrereq -showProgress -responseFile /home/oracle/db_install.rsp
安装到这步，需要另外开启一个终端，用root执行以下脚本：
As a root user, execute the following script(s):
1. /u01/app/oraInventory/orainstRoot.sh
2. /u01/app/oracle/product/11.2.0.4/db_1/root.sh
… 100% Done.
Execute Root Scripts successful.
Successfully Setup Software.
创建监听：
netca /silent /responseFile /home/oracle/netca.rsp
查看监听状态：
lsnrctl status
安装数据库前需要创建所需的目录
mkdir -p /u01/app/oracle/admin/orcl/{a,b,u}dump
mkdir -p /u01/app/oracle/oradata/orcl
然后将Seed_Database.dfb文件，拷贝到/u01/app/oracle/oradata/orcl下；
cp /u01/app/oracle/product/11.2.0.4/db_1/assistants/dbca/templates/Seed_Database.dfb /u01/app/oracle/oradata/orcl
静默dbca建立数据库：
vi /home/oracle/dbca.rsp
less /home/oracle/dbca.rsp |grep -v "#"|grep -v "^$"
[GENERAL]
RESPONSEFILE_VERSION = “11.2.0”
OPERATION_TYPE = “createDatabase”
[CREATEDATABASE]
GDBNAME = “orcl.bjdb”
SID = “orcl”
TEMPLATENAME = “General_Purpose.dbc”
SYSPASSWORD = “oracle”
SYSTEMPASSWORD = “oracle”
SYSMANPASSWORD = “oracle”
DBSNMPPASSWORD = “oracle”
DATAFILEJARLOCATION =/u01/app/oracle/oradata/orcl
RECOVERYAREADESTINATION=/u01/app/oracle/fast_recovery_area
CHARACTERSET = “AL32UTF8”
NATIONALCHARACTERSET= “UTF8”
dbca -silent -responseFile /home/oracle/dbca.rsp
[oracle@bjdb orcl]$ dbca -silent -responseFile /home/oracle/dbca.rsp
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file “/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log” for further details.
对安装结果进行检查：
lsnrctl status
[oracle@bjdb templates]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-8月 -2018 14:12:00
Copyright © 1991, 2013, Oracle. All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for Linux: Version 11.2.0.4.0 - Production
启动日期 04-8月 -2018 10:44:28
正常运行时间 0 天 3 小时 27 分 31 秒
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 /u01/app/oracle/product/11.2.0.4/db_1/network/admin/listener.ora
监听程序日志文件 /u01/app/oracle/diag/tnslsnr/bjdb/listener/alert/log.xml
监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bjdb)(PORT=1521)))
服务摘要..
服务 "orcl.bjdb" 包含 1 个实例。
实例 "orcl", 状态 READY, 包含此服务的 1 个处理程序...
服务 "orclXDB.bjdb" 包含 1 个实例。
实例 "orcl", 状态 READY, 包含此服务的 1 个处理程序...
命令执行成功
数据库状态：
[oracle@bjdb templates]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期六 8月 4 14:12:40 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> desc dba_data_files;
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS VARCHAR2(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
ONLINE_STATUS VARCHAR2(7)
SQL> select file_name from dba_data_files;
FILE_NAME
-----------------------------------
/u01/app/oracle/oradata/orcl/users01.dbf
/u01/app/oracle/oradata/orcl/undotbs01.dbf
/u01/app/oracle/oradata/orcl/sysaux01.dbf
/u01/app/oracle/oradata/orcl/system01.dbf
静默卸载oracle实例：
su oracle -c "/u01/app/oracle/product/11.2.0/EE/bin/dbca -silent -deleteDatabase -sourcedb EE -sid EE -sysDBAUserName system -sysDBAPassword oracle"
5192
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
