Oracle19c下载地址:https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html
服务器环境要求
事项 | 详情 |
---|---|
操作系统 | Centos 7.3 |
数据库版本 | 19.3.0 |
CPU | inter 16核 2.30GHz |
内存 | 64GB |
swap | 20GB |
关闭系统防火墙(如外网环境不能关闭防火墙自行开放相关需要使用的端口即可)
关闭selinux
systemctl stop firewalld
syustemctl disable firewalld
依赖安装
vim /etc/selinux/config
SELINUX=disabled
安装oracle需要的依赖(已通过互联网提前下载并制作yum仓库,配置一个离线yum源直接安装即可)
下载链接:https://download.csdn.net/download/qq_35893120/19666469
unzip base.zip
创建离线yum源,备份原有repo文件,创建local.repo文件
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
yum clean all
安装oracle-database-preinstall
yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
安装配置Oracle 19c
(1)安装Oracle 19c
yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm
如果遇到报错:Exception java.lang.UnsatisfiedLinkError: /opt/oracle/product/19c/dbhome_1/oui/lib/linux64/liboraInstaller.so: libnsl.so.1: cannot open shared object file: No such file or directory occurred..
(参考:http://www.ibmceo.com/detail_42.html)
解决:①
yum -y install /lib64/libnsl.so.1
②删除原来安装的 /opt/oracle/*
③ 卸载安装
yum -y remove oracle-database-ee-19c
④再重新执行一次安装
(2)初始化Oracle数据库,这个过程一般比较漫长
/etc/init.d/oracledb_ORCLCDB-19c configure
(3)配置环境变量,切换到oracle用户下
su - oracle
vim .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 .bash_profile
4)登陆oracle数据库
sqlplus / as sysdba
(5)修改密码
alter user system identified by 123456;
(6)使用连接工具PLSQL连接