1.下载依赖包:
yum -y install binutils compat-libcap1 compat-libstdc+±33 compat-libstdc+±33i686 compat-libstdc+±33.devel compat-libstdc+±33 compat-libstdc+±33*.devel gcc gcc-c++ glibc glibc*.i686 glibc-devel glibc-devel*.i686 ksh libaio libaio*.i686 libaio-devel libaio-devel*.devel libgcc libgcc*.i686 libstdc++ libstdc++.i686 libstdc+±devel libstdc+±devel.devel libXi libXi*.i686 libXtst libXtst*.i686 make sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBC-devel*.i686
2 检验安装包:
rpm -q binutils compat-libcap1 compat-libstdc+±33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc+±devel libXi libXtst make sysstat unixODBC unixODBC-devel
3.创建oracle用户组
1.创建oinstall和dba组
/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
2.创建oracle用户
/usr/sbin/useradd -g oinstall -G dba oracle
3.设置oracle密码(可不用)
passwd oracle
4.查看创建结果
id oracle
4.root 用户给oinstall(oracle目录授权)
mkdir -p /home/yyt/oracle/
chown -R oracle:oinstall /home/yyt/oracle/
chmod -R 775 /home/yyt/oracle/
5.修改内核参数
1.编辑配置文件
vi /etc/sysctl.conf
2.文件内容添加
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967296
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
3.使配置生效
/sbin/sysctl -p
6.修改配置
(1)修改用户限制
1.编辑文件
vi /etc/security/limits.conf
2.在文件末尾添加以下内容
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 10240
(2)改 /etc/pam.d/login
vi /etc/pam.d/login
#添加以下内容
session required /lib64/security/pam_limits.so
session required pam_limits.so
(3)修改/etc/profile
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
7.配置oracle环境变量
vim .bash_profile
export ORACLE_BASE=/home/yyt/oracle
export ORACLE_SID=orcl
使配置生效:source ~/.bash_profile
8.解压安装包到指定目录(oracle_base)
unzip linuxx64_12201_database.zip
9.静默安装
1.root用户授权
chmod 700 /home/yyt/oracle/database/response/*.rsp
2.静默安装文件配置(oracle用户)
vi /home/oracle/database/db_install.rsp
oracle.install.option=INSTALL_DB_SWONLY // 安装类型
UNIX_GROUP_NAME=oinstall // 安装组
INVENTORY_LOCATION=/home/yyt/oraInventory //INVENTORY目录(不填就是默认值 日志目录 不建议跟oracle安装同一目录)
ORACLE_HOME=/home/yyt/oracle/product/12.2.0/db_1
ORACLE_BASE=/home/yyt/oracle
oracle.install.db.InstallEdition=EE // 企业版本
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_GROUP=oinstall
oracle.install.db.OSBACKUPDBA_GROUP=oinstall
oracle.install.db.OSDGDBA_GROUP=oinstall
oracle.install.db.OSKMDBA_GROUP=oinstall
oracle.install.db.OSRACDBA_GROUP=oinstall
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.memoryLimit=81920 //自动管理内存的内存(M)
oracle.install.db.config.starterdb.password.ALL=oracle //设定所有数据库用户使用同一个密码
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
3.执行安装文件(db_install.rsp) (等待安装具体查看日志(上面配置的这个地方:INVENTORY_LOCATION))
./runInstaller -silent -ignorePrereq -responseFile /home/yyt/oracle/database/response/db_install.rsp
4.安装提示使用root账户执行
su - root
/home/yyt/oracle/oraInventory/orainstRoot.sh
/home/yyt/oracle/product/12.2.0/db_1/root.sh
5.修改oracle环境变量(oracle用户)
vim ~/.bash_profile
#for oracle
export ORACLE_BASE=/home/yyt/oracle
export ORACLE_SID=orcl
export ROACLE_PID=oral12
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
export ORACLE_HOME=/home/yyt/oracle/product/12.2.0/db_1
export PATH=$PATH:$ORACLE_HOME/bin
export LANG="zh_CN.UTF-8"
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"
export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
配置生效:source ~/.bash_profile
6.配置监听
netca /silent /responsefile /home/yyt/oracle/database/response/netca.rsp
lsnrctl start
7.构建oracle实例
vi /home/oracle/database/dbca.rsp
#文件修改
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0
gdbName=orcl
sid=orcl
databaseConfigType=SI
createAsContainerDatabase=true
numberOfPDBs=1
pdbName=orclpdb
templateName=/home/yyt/oracle/product/12.2.0/db_1/assistants/dbca/templates/General_Purpose.dbc
emExpressPort=5500
omsPort=0
characterSet=AL32UTF8
listeners=LISTENER
memoryPercentage=40
automaticMemoryManagement=false
totalMemory=0
执行:
dbca -silent -createDatabase -responseFile /home/yyt/oracle/database/response/dbca.rsp