oracle19c 单机图形化安装

5.2安装oracle19c数据库

5.2.1设置yum源

详情见阿里云镜像配置相关操作-Oracle文档类资源-CSDN下载

yum clean all

yum makecache

5.2.2安装依赖包

yum install bc gcc gcc-c++ binutils compat-libcap1 compat-libstdc++ dtrace-modules dtrace-modules-headers  dtrace-modules-provider-headers dtrace-utils elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel  ksh libaio libaio-devel libdtrace-ctf-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc librdmacm-devel  libstdc++ libstdc++-devel libxcb make smartmontools sysstat net-tools 

5.2.3创建组和用户

/usr/sbin/groupadd -g 54321 oinstall

/usr/sbin/groupadd -g 54322 dba

/usr/sbin/groupadd -g 54323 oper

/usr/sbin/useradd -u 54321 -g oinstall -G dba,oper oracle

5.2.4修改用户密码

passwd oracle

5.2.5关闭防火墙还有selinux

systemctl stop firewalld.service

systemctl disable firewalld.service

5.2.6创建工作的目录，然后赋予相应的权限。

mkdir -p /oracle/app/oracle/product/19/db_1

mkdir -p /oracle/app/oraInventory

chown -R oracle:oinstall /oracle/

chmod -R 775 /oracle/

5.2.7配置Oracle环境变量

vi .bash_profile

export ORACLE_BASE=/oracle/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/19/db_1

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export PATH=/usr/sbin:$PATH:$ORACLE_HOME/bin

export ORACLE_SID=txwsdb

alias cdtrace='cd $ORACLE_BASE/diag/rdbms/tdb/$ORACLE_SID/trace'

5.2.8修改内核参数

# vi /etc/sysctl.conf

fs.file-max = 6815744

kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104

kernel.panic_on_oops = 1

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

sysctl --system

5.2.9准备安装

# mv 安装包 $ORACLE_HOME

# chown -R oracle:oinstall 安装包

# su – oracle

# unzip 安装包

# export DISPLAY=IP地址:1.0

# LANG=en_US ./runInstaller

5.3创建数据库

Dbca

export DISPLAY=IP地址:1.0

LANG=en_US dbca