oracle 19c 离线安装

近期分配到一个任务，在无法连接外网的服务器上安装oracle数据库，查找许多资料总结为以下内容：
oracle下载
https://www.oracle.com/database/technologies/xe-prior-releases.html

1、配置yum源

cd /etc
mv yum.repos.d yum.repos.d.bak
mkdir yum.repos.d
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo
yum clean all
yum makecache

没有 wget 命令则

yum install wget -y

2、安装依赖包

yum -y install binutils \
compat-libstdc++-33 \
elfutils-libelf \
elfutils-libelf-devel \
expat \
gcc \
gcc-c++ \
glibc \
glibc-common \
glibc-devel \
glibc-headers \
libaio \
libaio-devel \
libgcc \
libstdc++ \
libstdc++-devel \
make \
pdksh \
sysstat \
unixODBC \
unixODBC-devel

3、检查依赖是否安装完整

rpm -q \
binutils \
compat-libstdc++-33 \
elfutils-libelf \
elfutils-libelf-devel \
expat \
gcc \
gcc-c++ \
glibc \
glibc-common \
glibc-devel \
glibc-headers \
libaio \
libaio-devel \
libgcc \
libstdc++ \
libstdc++-devel \
make \
pdksh \
sysstat \
unixODBC \
unixODBC-devel | grep "not installed"

如果在内网环境(无法连接互联网的情况下)，需要下载百度网盘下的base.zip，并解压丢在/root/base目录下。

链接：https://pan.baidu.com/s/1nTEYekhbCbS3YXwynLPzKA
提取码：iscy

然后

echo "[local]" > /etc/yum.repos.d/local.repo
echo "name=local" >> /etc/yum.repos.d/local.repo
echo "enable=1" >> /etc/yum.repos.d/local.repo
echo "baseurl=file:///root/base" >> /etc/yum.repos.d/local.repo
echo "gpgcheck=0" >> /etc/yum.repos.d/local.repo

并将CentOS-fasttrack.repo修改为以下内容

#CentOS-fasttrack.repo

[cdrom]
name=CentOS-7 - cdrom
baseurl=file:///media/cdrom
gpgcheck=0
enabled=0

然后执行

yum clean all

yum makecache

5、添加oracle用户组和用户

groupadd oinstall
groupadd dba
groupadd asmadmin
groupadd asmdba
useradd -g oinstall -G dba,asmdba oracle -d /home/oracle

6、添加完成后，查看oracle用户

id oracle

7、初始化oracle密码 123456

passwd oracle

8、安装oracle-database-preinstall

yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

9、安装oracle 19C

yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm

10、初始化oracle数据库

/etc/init.d/oracledb_ORCLCDB-19c configure

11、配置oracle用户的环境变量

su - oracle ## oracle用户登陆


vi .bash_profile

export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1 
export PATH=$PATH:/opt/oracle/product/19c/dbhome_1/bin 
export ORACLE_SID=ORCLCDB

以上配置完成后，建议重启系统 或执行以下命令：

source /home/oracle/.bash_profile

12、登陆oracle数据库

sqlplus / as sysdba

13、修改密码

alter user system identified by 123456;

14、使用SSH隧道、Nacivat连接数据库

https://www.cnblogs.com/maoxianfei/p/7404144.html