19c 安装步骤

1.修改hosts
vim /etc/hosts

2.添加用户和组
[root@henry01 ~]# groupadd -g 54321 oinstall
[root@henry01 ~]# groupadd -g 54322 dba
[root@henry01 ~]# groupadd -g 54323 oper
[root@henry01 ~]# useradd -u 60001 -g oinstall -G dba,oper -m oracle

passwd oracle 修改密码

[root@henry01 ~]# mkdir /oracle
[root@henry01 ~]# mkdir -p /oracle/app/oracle/product/19.3.0/dbhome_1
[root@henry01 ~]# mkdir -p /oracle/app/oraInventory
[root@henry01 ~]# chown -R oracle:oinstall /oracle
[root@henry01 ~]# chmod -R 775 /oracle

3.配置yum安装rpm包
[root@henry01 ~]# mount /dev/cdrom /mnt/
mount: /dev/sr0 is write-protected, mounting read-only
[root@henry01 ~]# ls /mnt/
addons  images    RELEASE-NOTES-U7-en       RPM-GPG-KEY-oracle
EFI     isolinux  RELEASE-NOTES-U7-en.html  TRANS.TBL
EULA    LiveOS    repodata
GPL     Packages  RPM-GPG-KEY

cd /etc/yum.repos.d/
rm -rf *

[root@henry01 ~]# vim /etc/yum.repos.d/henry.repo
[root@henry01 ~]# cat /etc/yum.repos.d/henry.repo
[henry]
name=henry_repo
baseurl=file:///mnt/
gpgcheck=0
enabled=1

yum clean all
yum repolist all

yum -y install autoconf
yum -y install automake
yum -y install binutils
yum -y install binutils-devel
yum -y install bison
yum -y install cpp
yum -y install dos2unix
yum -y install ftp
yum -y install gcc
yum -y install gcc-c++
yum -y install lrzsz
yum -y install python-devel
yum -y install compat-libcap1
yum -y install compat-libstdc++-33
yum -y install compat-libstdc++-33.i686
yum -y install glibc-*
yum -y install glibc-*.i686
yum -y install libXpm-*.i686
yum -y install libXext
yum -y install libXext.i686
yum -y install libXtst
yum -y install libXtst.i686
yum -y install libX11
yum -y install libX11.i686
yum -y install libXau
yum -y install libXau.i686
yum -y install libxcb
yum -y install libxcb.i686
yum -y install libXi
yum -y install libXi.i686
yum -y install libstdc++.i686
yum -y install libstdc++-devel
yum -y install libstdc++-devel.i686
yum -y install libaio
yum -y install libaio.i686
yum -y install libaio-devel
yum -y install libaio-devel.i686
yum -y install ksh
yum -y install libXp
yum -y install libaio-devel
yum -y install numactl
yum -y install numactl-devel
yum -y install make -y
yum -y install sysstat -y
yum -y install unixODBC
yum -y install unixODBC-devel
yum -y install elfutils-libelf-devel
yum -y install redhat-lsb-core
yum -y install unzip
yum install -y libXrender
yum install -y libXrender-devel
yum install -y nfs-utils
yum install -y smartmontools

4.limits.conf
[root@henry01 ~]# vim /etc/security/limits.conf

oracle soft nproc 16384
oracle hard nproc 16384
oracle soft nofile 16384
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768

5.内核参数
[root@henry01 ~]# vim /etc/sysctl.conf

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmax = 1932735283
kernel.shmall = 471859
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
kernel.panic_on_oops = 1

sysctl -p

6.防火墙
systemctl status firewalld.service
systemctl stop firewalld.service
systemctl disable firewalld.service

7.环境变量
su - oracle
编辑 .bash_profile

vim .bash_profile


PS1="[`whoami`@`hostname`:"'$PWD]$'
export PS1
export TMP=/tmp
export LANG=en_US
export TMPDIR=$TMP
export ORACLE_UNQNAME=cdb19c
ORACLE_SID=cdb19c; export ORACLE_SID
ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG
PATH=.:$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin; export PATH
THREADS_FLAG=native; export THREADS_FLAG
umask=022
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi

8.授权解压文件
[root@henry01 soft]# chown -R oracle:oinstall /soft/
[root@henry01 soft]# chmod -R 775 /soft/
[root@henry01 soft]# su - oracle
Last login: Sat Jul 24 22:16:51 CST 2021 on pts/0
[oracle@henry01:/home/oracle]$cd $ORACLE_HOME
[oracle@henry01:/oracle/app/oracle/product/19.3.0/dbhome_1]$pwd
/oracle/app/oracle/product/19.3.0/dbhome_1
[oracle@henry01:/oracle/app/oracle/product/19.3.0/dbhome_1]$unzip -q /soft/LINUX.X64_193000_db_home.zip

9.重启oracle登陆
./runInstaller
netca
dbca