oracle 19c 离线安装到服务器

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;