CentOS7.6 安装Oracle18c RPM
数据库2年前 (2019-04-18)
CentOS7.6使用rpm方式在线安装Oracle Database 18c，rpm安装包会执行安装前的检测，解压缩数据库软件，修改Oracl 软件的权限到之前配置的用户和组，维护Oracle inventory，执行安装需要需要执行的root操作。这样安装的好处是可以快速的完成数据库初始化和完成数据库安装和部署工作。
离线rpm安装包下载地址
https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-linux-180000-5022980.html
#登录账号后浏览器里下载一下将URL复制下来 wget https://download.oracle.com/otn/linux/oracle18c/180000/oracle-database-ee-18c-1.0-1.x86_64.rpm?AuthParam=1555554779_208906635afddb7e99fb8b7efdcedd5b
下载速度确实很慢，最好使用代理工具下载
ls -lh
下载预安装环境
curl -o oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
yum -y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm rm -f oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
#默认安装到目录/opt/oracle/product/18c/dbhome_1 #自动创建一个CDB (ORCLCDB) 和一个PDB (ORCLPDB1) 和配置一个listener在默认端口1521 yum -y localinstall oracle-database-ee-18c-1.0-1.x86_64.rpm
cat /etc/sysconfig/oracledb_ORCLCDB-18c.conf # 定义监听端口 # 定义数据存放位置 # 定义Enterprise Manager监听端口
创建数据库
/etc/init.d/oracledb_ORCLCDB-18c configure
du -sh /opt/
su - oracle vi .bash_profile 添加 export ORACLE_SID=ORCLCDB export ORACLE_BASE=/opt/oracle/oradata export ORACLE_HOME=/opt/oracle/product/18c/dbhome_1 export PATH=$PATH:$ORACLE_HOME/bin umask 022 执行source .bash_profile
配置数据库自启
vi /etc/oratab ORCLCDB:/opt/oracle/product/18c/dbhome_1:Y
vi /etc/sysconfig/ORCLCDB.oracledb 添加 ORACLE_BASE=/opt/oracle/oradata ORACLE_HOME=/opt/oracle/product/18c/dbhome_1 ORACLE_SID=ORCLCDB
创建监听服务
vi /usr/lib/systemd/system/ORCLCDB@lsnrctl.service 添加 [Unit] Description=Oracle Net Listener After=network.target [Service] Type=forking EnvironmentFile=/etc/sysconfig/ORCLCDB.oracledb ExecStart=/opt/oracle/product/18c/dbhome_1/bin/lsnrctl start ExecStop=/opt/oracle/product/18c/dbhome_1/bin/lsnrctl stop User=oracle [Install] WantedBy=multi-user.target
创建数据库服务
vi /usr/lib/systemd/system/ORCLCDB@oracledb.service 添加 [Unit] Description=Oracle Database service After=network.target lsnrctl.service [Service] Type=forking EnvironmentFile=/etc/sysconfig/ORCLCDB.oracledb ExecStart=/opt/oracle/product/18c/dbhome_1/bin/dbstart $ORACLE_HOME ExecStop=/opt/oracle/product/18c/dbhome_1/bin/dbshut $ORACLE_HOME User=oracle [Install] WantedBy=multi-user.target
设置服务自启
systemctl daemon-reload systemctl enable ORCLCDB@lsnrctl ORCLCDB@oracledb
测试
netstat -nultp | grep -E '1521|5500'
su - oracle lsnrctl start sqlplus / as sysdba select banner from sys.v_$version; select * from v$version;
登录EM管理器
su - oracle sqlplus / as sysdba connect / as sysdba alter user system identified by oracle; alter user sys identified by oracle;
浏览器登录地址 https://IP:5500/em/login 用户名sys 密码刚修改的oracle
本站所有文章均可随意转载，转载时请保留原文链接及作者。
，想必也是非常愉悦的事！
