在 CentOS 上安装 Oracle Database(以 Oracle 11g / 12c / 19c 为例,最常用的是 19c)是一个比较复杂的流程,下面给你一个通用、清晰的安装步骤指南(以 Oracle 19c + CentOS 7/8 为例,其他版本类似)。
systemctl stop firewalld
systemctl disable firewalld
setenforce 0
sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
hostnamectl set-hostname oracle19c
vi /etc/hosts
添加:
192.168.1.100 oracle19c
yum install -y \
binutils \
compat-libcap1 \
compat-libstdc++-33 \
gcc \
gcc-c++ \
glibc \
glibc-devel \
ksh \
libaio \
libaio-devel \
libgcc \
libstdc++ \
libstdc++-devel \
make \
sysstat \
unzip \
elfutils-libelf-devel
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
vi /etc/sysctl.conf
添加:
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
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
执行:
sysctl -p
vi /etc/security/limits.conf
添加:
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1
mkdir -p /u01/app/oraInventory
chown -R oracle:oinstall /u01
chmod -R 775 /u01
切换到 oracle 用户:
su - oracle
vi ~/.bash_profile
添加:
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
生效:
source ~/.bash_profile
Oracle 19c 安装包(如 LINUX.X64_193000_db_home.zip):
cd $ORACLE_HOME
unzip LINUX.X64_193000_db_home.zip
cd $ORACLE_HOME
./runInstaller
./runInstaller -silent \
-responseFile $ORACLE_HOME/install/response/db_install.rsp
安装完成后按提示执行:
/u01/app/oraInventory/orainstRoot.sh
/u01/app/oracle/product/19.3.0/dbhome_1/root.sh
dbca
或使用静默:
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname orcl -sid orcl \
-characterSet AL32UTF8
sqlplus / as sysdba
startup;
查看版本:
select * from v$version;
lsnrctl start如果你告诉我:
我可以给你更精确的一步到位方案,甚至 一键脚本。