oracle19c rpm安装

环境：

虚拟机： Centons7（内存2g，处理器：2，硬盘：40g）,jdk1.8,

 

1）hosts添加名称

echo "ip oracle19c" >> /etc/hosts

2）安装oracle依赖包（以root身份操作）

yum install -y binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*.i686 glibc glibc*.i686 glibc-devel glibc-devel*.i686 ksh libaio libaio*.i686 libaio-devel libaio-devel*.i686 libX11 libX11*.i686 libXau libXau*.i686 libXi libXi*.i686 libXtst libXtst*.i686 libgcc libgcc*.i686 libstdc++ libstdc++*.i686 libstdc++-devel libstdc++-devel*.i686  libxcb libxcb*.i686 make nfs-utils net-tools smartmontools sysstat unixODBC unixODBC-devel gcc gcc-c++ libXext libXext*.i686 zlib-devel zlib-devel*.i686 unzip

# 也可以分段执行，避免遗漏
yum install -y compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*.i686
yum install -y glibc*.i686 glibc-devel glibc-devel*.i686
yum install -y ksh libaio*.i686 libaio-devel libaio-devel*.i686
yum install -y libX11 libX11*.i686 libXau libXau*.i686 libXi libXi*.i686
yum install -y libXtst libXtst*.i686 libgcc*.i686 libstdc++*.i686 libstdc++-devel libstdc++-devel*.i686
yum install -y libxcb libxcb*.i686 make nfs-utils net-tools smartmontools sysstat unixODBC unixODBC-devel
yum install -y gcc gcc-c++ libXext libXext*.i686 zlib-devel zlib-devel*.i686 unzip

3）preinstall 依赖包

http://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

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

4）安装

yum localinstall -y oracle-database-ee-19c-1.0-1.x86_64.rpm 【oracle 官网下载】

#初始化Oracle数据库：
/etc/init.d/oracledb_ORCLCDB-19c configure

su - oracle

vim /etc/profile

export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export PATH=$PATH:/opt/oracle/product/19c/dbhome_1/bin
export ORACLE_SID=ORCLCDB
## 解决命令行乱码
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

登陆oracle数据库:

sqlplus / as sysdba

修改密码:

alter user system identified by 123456;

# 创建用户
create user c##test identified by Test123;
# 授予权限
grant create session, connect, resource to c##test;