一、环境
系统 : CentOS 7.x
硬件:虚拟机处理器4核 内存 4g 硬盘1:40g 硬盘2:20g
1、上传安装包,安装压缩组件
uname -r
yum install -y unzip zip
centos7.x都是3.10.0内核
2、SELINUX: 关闭
setenforce 0 sed -i '/^SELINUX=/cSELINUX=disabled' /etc/selinux/config getenforce
3、FIREWALL:关闭
systemctl stop firewalld.service
systemctl disable firewalld.service
systemctl status firewalld.service
4、挂载镜像
参考
挂载本地镜像源 https://www.cnblogs.com/wxp100/p/14781661.html
挂载局域网仓库 https://www.cnblogs.com/wxp100/p/15309408.html
5、yum安装组件
yum -y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*.i686 elfutils-libelf-devel gcc gcc-c++ gcc-c++glibc*.i686 \
glibc glibc-devel glibc-devel*.i686 ksh libgcc*.i686 libgcclibstdc++ libstdc++*.i686 libstdc++-devel libstdc++-devel*.i686 libaiolibaio*.i686 \
libaio-devel libaio-devel*.i686 make sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBC-devel*.i686 libXp
二、部署
1、创建用户和组
groupadd oinstall groupadd dba useradd -g oinstall -G dba oracle echo "123456" | passwd --stdin oracle
2、修改内核参数
vi /etc/sysctl.conf
添加内容
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 1048596
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 = 1048586
:wq保存后,输入以下名命令使系统配置生效
sysctl -p
ps:kernel.shmall 和 kernel.shmmax 根据实际物理内存修改,保证oracle数据库SGA 小于系统上的 shmmax
3、修改oacle用户限制
vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle soft stack 10240oracle hard memlock 8421772
oracle soft memlock 8421772
#当内存大于8g是要添加内存锁 其值一般为物理内存的80%
vi /etc/pam.d/login
session required /lib64/security/pam_limits.so
session required pam_limits.so
4、配置oracle用户环境变量
vi ~oracle/.bash_profile
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1
ORACLE_SID=orcl
export ORACLE_BASE ORACLE_HOME ORACLE_SID
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
PATH=$ORACLE_HOME/bin:$PATH
export PATH
source ~oracle/.bash_profile
5、创建安装目录
mkdir -p /u01/app/ chown -R oracle:oinstall /u01/app/ chmod -R 775 /u01/app/
三、安装
1、解压安装文件,并修改参数配置
unzip linuxx64_12201_database.zip -d /u01/app/ chown -R oracle:oinstall /u01/app/
su - oracle
vi /home/oracle/db_install.rsp
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1
ORACLE_BASE=/u01/app/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.characterSet=ZHS16GBK
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=3096
oracle.install.db.config.starterdb.password.ALL=oracle
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
memoryLimit 是可分配内存 单位是MB,一般设置物理内存60%-80%
参考资料
http://blog.chinaunix.net/uid-23886490-id-3565908.html
https://blog.csdn.net/yinzhipeng123/article/details/53141950
2、执行安装程序
cd /u01/app/database ./runInstaller -silent -responseFile /home/oracle/db_install.rsp
一边安装一边查看日志(日志文件是installActions+日期AM.log)
tail -500f /u01/app/oraInventory/logs/installActions2021-10-04_01-30-19AM.log
安装完切换到root执行脚本
exit
/u01/app/oraInventory/orainstRoot.sh
/u01/app/oracle/product/12.2.0.1/db_1/root.sh
3、静默添加监听
切换到oracle用户
su - oracle netca -silent -responsefile /u01/app/database/response/netca.rsp
查看监听: lsnrctl status
启动监听:lsnrctl start
netstat -tlnp
4、静默配置建库
vi /home/oracle/dbca.rsp
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0
gdbName=orcl
sid=orcl
databaseConfigType=SIcreateAsContainerDatabase=true
numberOfPDBs=1
pdbName=orclpdb
pdbAdminPassword=333333datafileDestination=/ora_data
sysPassword=123456
systemPassword=654321
templateName=/u01/app/oracle/product/12.2.0.1/db_1/assistants/dbca/templates/General_Purpose.dbc
emExpressPort=5500
omsPort=0
characterSet=ZHS16GBK
listeners=LISTENER
memoryPercentage=40
automaticMemoryManagement=false
totalMemory=0
1、创建非容器数据库把黑色加粗字体删掉
2、可选定义数据文件路径,要设置oracle权限
chown -R oracle:oinstall /ora_data
参考文件
https://blog.csdn.net/yinzhipeng123/article/details/53144589
https://www.cnblogs.com/liyang6/p/11378069.html
https://blog.csdn.net/bjywxc/article/details/105116581
https://www.imzcy.cn/1631.html
开始安装数据库
dbca -silent -createDatabase -responseFile /home/oracle/dbca.rsp
安装过程中打断再次安装会报错
解决方法
1、查看/etc/oratab中是否还有SID,删除或者注释掉
2、ps -ef|grep SID ,查看是否后台进程还有SID,有就kill掉
开启归档日志
https://www.cnblogs.com/wxp100/p/15367659.html
数据文件迁移
https://www.cnblogs.com/jyzhao/p/3968504.html