安装前准备
# host添加域名
echo "127.0.0.1 oracle.test.com
10.100.2.116 oracle.test.com" >> /etc/hosts
# 关闭防火墙开机自启
chkconfig --level 2345 iptables off || systemctl disable firewalld
# 创建组和用户
groupadd oinstall groupadd dba
useradd -g oinstall -G dba oracle passwd oracle解压部署包和安装依赖
# 解压缩部署包
unzip *(安装包).zip
# 创建目录并授权
mv database /home/
chown -R oracle.oinstall /home/database
mkdir -p /app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /app
chmod -R 775 /app
# 安装依赖
yum -y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel gcc- gcc-c++ libaio-devel libaio libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel pdksh 修改orainst.loc文件
vim /etc/orainst.loc
# 修改为实际路径
inventory_loc=/app/oracle/orainventory
inst_group=oinstall
# 授权
chown -R oracle:oinstall orainst.loc
chmod 664 orainst.loc添加变量和配置
su - oracle
vim ~/.bash_profile
export PATH export ORACLE_BASE=/app
export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/db_1
export ORACLE_SID=orcl export PATH=$PATH:$ORACLE_HOME/bin
vim /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
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 = 1048586
sysctl -p
vim /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
vim /etc/pam.d/login
session required pam_selinux.so open
session optional pam_keyinit.so force revoke
session required pam_limits.so
vim /etc/selinux/config
SELINUX=disabled安装数据库软件静默文件,需要修改下面字段
vim /response/db_install.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 oracle.install.option=INSTALL_DB_SWONLY ORACLE_HOSTNAME=ndb (按实际主机名填写)
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/home/oracle/orainventory
SELECTED_LANGUAGES=en,zh_CN,zh_TW ORACLE_HOME=/app/oracle/product/11.2.0/db_1
ORACLE_BASE=/app/
oracle.install.db.InstallEdition=EE
oracle.install.db.isCustomInstall=false
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
DECLINE_SECURITY_UPDATES=true
oracle.install.db.config.starterdb.password.ALL=123.com 创建数据库响应文件
vim /response/UPRR_DBCA.rsp
[GENERAL] RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE] GDBNAME = "orcl"
SID = "orcl"
TEMPLATENAME = "General_Purpose.dbc"
DATAFILEDESTINATION = "/app/oracle/oradata"
RECOVERYAREADESTINATION= "/app/oracle/flash_recovery_area"
CHARACTERSET = "ZHS16GBK"
NATIONALCHARACTERSET= "AL16UTF16"
vim /response/dbca.rsp
GDBNAME = "orcl.oracle.test.com" # SID和主机域名
SYSPASSWORD = "123.com"
SYSTEMPASSWORD = "123.com"
SID = "orcl" 安装
./runInstaller -silent -responseFile /home/database/response/db_install.rsp -invPtrLoc /etc/orainst.loc -ignoreSysPrereqs -ignorePrereq
dbca -silent -responseFile /home/database/response/dbca.rsp
tail -100f /app/oracle/orainventory/logs/installActions2017-12-07_01-24-36PM.log查看安装进度 静默配置监听
/app/oracle/product/11.2.0/db_1/bin/netca /silent /responseFile /home/database/response/UPRR_DBCA.rsp /app/oracle/product/11.2.0/db_1/srvm/admin/getcrshome
oracle安装过程中出现INFO: Unloading Setup Driver 给/etc/security目录赋予读写权限就可以了