centos7.5安装19c单实例数据库

1.操作系统

centos7.5

ram=8G

root密码：12345678

配置yum源

mkdir /media/cdrom

mount /dev/sr0 /media/cdrom

df -h查看挂载情况：

修改yum源为新配置的/media/cdrom路径

vi /etc/yum.repos.d/CentOS-Base.repo

[base]

name=CentOS-$releasever - Base

#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os&infra=$infra

baseurl=file:///media/cdrom

gpgcheck=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7

#released updates

[updates]

name=CentOS-$releasever - Updates

#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=updates&infra=$infra

baseurl=file:///media/cdrom

gpgcheck=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7

#additional packages that may be useful

[extras]

name=CentOS-$releasever - Extras

#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=extras&infra=$infra

baseurl=file:///media/cdrom

gpgcheck=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7

#additional packages that extend functionality of existing packages

[centosplus]

name=CentOS-$releasever - Plus

#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=centosplus&infra=$infra

baseurl=file:///media/cdrom

gpgcheck=1

enabled=0

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7

安装操作系统依赖包

yum install libst* -y

yum install gcc* -y

yum install libaio* -y

yum install glibc* -y

yum install compat* -y

yum install libx* -y

yum install libX* -y

yum install make* -y

yum install sysstat* -y

修改配置参数

net.ipv4.ip_local_port_range = 9000 65500

net.ipv4.tcp_rmem = 4096 87380 4194304

net.ipv4.tcp_wmem = 4096 16384 4194304

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 1048576        //shmall=shmmax/4096

kernel.shmmax = 4294967295   //shmmax=ram/2*1024*1024*1024

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

使配置生效

/sbin/sysctl -p

vi /etc/security/limits.conf

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft stack 10240

oracle hard stack 32768

查看大页是否关闭

cat /sys/kernel/mm/transparent_hugepage/enabled

修改文件vi /etc/default/grub，添加transparent_hugepage=never

grub2-mkconfig -o /boot/grub2/grub.cfg重新生成文件

reboot后生效

创建组

groupadd -g 54321 oinstall

groupadd -g 54322 dba

groupadd -g 54323 oper

groupadd -g 54324 backupdba

groupadd -g 54325 dgdba

groupadd -g 54326 kmdba

groupadd -g 54330 racdba

创建用户

useradd -u 54321 -g oinstall -G dba,backupdba,dgdba,kmdba,racdba,oper oracle

设置Oracle用户密码echo “oracle123”|passwd --stdin oracle  为oracle123

创建目录并授权

mkdir -p /u01/app

chown -R oracle:oinstall /u01/app

chmod -R 775 /u01/app

mkdir -p /u01/app/oraInventory

chown -R oracle:oinstall /u01/app/oraInventory

chmod -R 775 /u01/app/oraInventory

mkdir -p /u01/app/oracle/cfgtoollogs

mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1

chown -R oracle:oinstall /u01/app/oracle

chmod -R 775 /u01/app/oracle

关闭防火墙以及selinux

vi /etc/selinux/config

将enforcing改成disabled

防火墙关闭以及禁止开机自启动

systemctl list-unit-files|grep firewalld

systemctl stop firewalld.service

systemctl status firewalld.service

systemctl disable firewalld.service

检查状态

systemctl status firewalld.service

getenforce

设置环境变量

su - oracle

vi .bash_profile

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1

export ORACLE_SID=db

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

创建文件夹存放安装包

mkdir /soft

chown oracle:oinstall /soft -R

chmod 755 /soft -R

上传安装包

解压安装包

unzip LINUX.X64_193000_db_home.zip -d $ORACLE_HOME/

解压完成后，打开xmanager 的passive

export DISPLAY=192.168.50.2:0.0

在$ORACLE_HOME路径安装数据库软件

./runInstaller

补充手动脚本

/u01/app/oraInventory/orainstRoot.sh

/u01/app/oracle/product/19.3.0/dbhome_1/root.sh

dbca建库

创建一个数据库

至此，19C单实例数据库安装完成