centos7.9 oracle 19c 安装

东方-phantom

已于 2024-01-16 10:09:51 修改

阅读量732

点赞数 10

文章标签： oracle 数据库

于 2024-01-09 18:22:18 首次发布

本文链接：https://blog.csdn.net/hkyw000/article/details/135487137

版权

本文详细描述了一个在Linux环境下安装Oracle19.3.0数据库的过程，包括修改主机名、添加用户组和用户、禁用SELinux、配置iptables、设置环境变量、安装依赖包、调整资源限制以及解压和初始化数据库软件。

摘要由CSDN通过智能技术生成

#!/bin/bash

hostnamectl set-hostname xxx-uat-db && bash

groupadd oinstall
groupadd dba
useradd oracle -g oinstall -G dba

setenforce 0
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config

iptables -F
iptables -L

mkdir -p /data/oracle/product/19.3.0
chown -R oracle:oinstall /data/oracle

yum install -y binutils*
yum install -y compat-libcap*
yum install -y compat-libstdc++*
yum install -y gcc-4.8*
yum install -y gcc-c++*
yum install -y glibc*
yum install -y ksh
yum install -y libaio*
yum install -y libgcc*
yum install -y libstdc*
yum install -y libXi*
yum install -y libXtst*
yum install -y make*
yum install -y sysstat*
yum install -y xorg-x11-xauth install bc binutils compat-libcap1 compat-libstdc+±33 elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libXrender-devel libX11 libXau libXi libXtst libgcc libstdc++ libstdc+±devel libxcb make policycoreutils policycoreutils-python smartmontools sysstat

cat >> /home/oracle/.bash_profile <<EOF
export ORACLE_BASE=/data/oracle
export ORACLE_HOME=/data/oracle/product/19.3.0
export PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin
export ORACLE_HOSTNAME=xx-prod-db
export ORACLE_SID=wind
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/network/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
EOF

cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF

cat >> /etc/pam.d/login <<EOF
session required pam_limits.so
EOF

cat >> /etc/sysctl.conf <<EOF
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
EOF

cd /data/software

unzip LINUX.X64_193000_db_home.zip -d /data/oracle/product/19.3.0

chown oracle:oinstall /data/oracle -R

DISPLAY=xxxx:0.0; export DISPLAY

cd /data/oracle/product/19.3.0