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