Oracle19c安装图文教程

一、安装前环境配置

1.基本信息

2.配置/etc/hosts

[root@STUDY /]# echo '192.168.2.98 STUDY' >> /etc/hosts  

3.关闭防火墙和Selinux

[root@STUDY etc]# systemctl stop firewalld.service
[root@STUDY etc]# systemctl disable firewalld.service
[root@STUDY etc]# sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/sysconfig/selinux

4.配置系统参数

[root@STUDY etc]# vi /etc/sysctl.conf

添加如下内容：
kernel.shmmni=4096
kernel.sem=250 32000 100 128
fs.file-max=6815744
fs.aio-max-nr=1048576
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
kernel.shmmax=53687091200
kernel.shmall=52780232

[root@STUDY etc]# vi /etc/pam.d/login

添加如下内容：
session required /lib64/security/pam_limits.so
session required pam_limits.so

[root@STUDY etc]# 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 hard stack 32768

说明：
生产环境注意这两个参数，需要根据服务器的内存大小调整
kernel.shmmax：内核共享内存段最大值
kernel.shmall：所有内存（单位是页 4096）

[root@STUDY etc]#sysctl -p     --使上面参数生效
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
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
kernel.shmmax = 53687091200
kernel.shmall = 52780232

5.创建用户oracle用户和组

[root@STUDY etc]# groupadd oinstall
[root@STUDY etc]# groupadd dba
[root@STUDY etc]# groupadd oper
[root@STUDY etc]# useradd -g oinstall -G dba,oper oracle
[root@STUDY etc]# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: The password fails the dictionary check - it is too simplistic/systematic
Retype new password:
passwd: all authentication tokens updated successfully.

[root@STUDY etc]# id oracle
uid=1000(oracle) gid=1000(oinstall) groups=1000(oinstall),1001(dba),1002(oper)

6.创建安装目录

[root@STUDY etc]# mkdir -p /u01/app/oracle/product/19.3/dbhome_1
[root@STUDY etc]# chown -R oracle:oinstall /u01/app
[root@STUDY etc]# chmod -R 775 /u01/app

7.配置yum

[root@STUDY etc]# cd /etc/yum.repos.d
[root@STUDY etc]# vi local-oraclelinux.repo 

8.配置oracle 用户环境变量

[root@STUDY etc]# su – oracle
[oraclet@STUDY ~]$ vi /home/oracle/.bash_profile

添加如下内容：
umask 022
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.3/dbhome_1
ORACLE_SID=win
PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin
export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID

[oracle@STUDY ~]$ source /home/oracle/.bash_profile

9.服务器上VNC安装与配置

#yum -y install tigervnc-server-1.8.0-17.el7.