乐趣区

关于数据库:OracleOracle-数据库安装

jiezi

作者：threedayman

起源：恒生 LIGHT 云社区

安装包下载地址

https://www.oracle.com/cn/dat…

咱们选用 RPM 包下载安装。

装置帮忙文档

https://docs.oracle.com/en/da…

装置环境 

cat /etc/redhat-release 
CentOS Linux release 7.7.1908 (Core)

在非 OralceLinux 环境下装置，须要下载对应平台的 rpm。

下载地址：https://yum.oracle.com/repo/O…，搜寻 -19c 下载最新版本即可。

装置

首先执行 

[root@linuxtestb538 oracle]# rpm -ivh oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpm 
warning: oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
error: Failed dependencies:
        bind-utils is needed by oracle-database-preinstall-19c-1.0-3.el7.x86_64
        compat-libcap1 is needed by oracle-database-preinstall-19c-1.0-3.el7.x86_64
        ksh is needed by oracle-database-preinstall-19c-1.0-3.el7.x86_64
        smartmontools is needed by oracle-database-preinstall-19c-1.0-3.el7.x86_64
        sysstat is needed by oracle-database-preinstall-19c-1.0-3.el7.x86_64
        xorg-x11-utils is needed by oracle-database-preinstall-19c-1.0-3.el7.x86_64

执行呈现短少依赖谬误。

改用 yum 命令进行装置 

 yum install oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpm
 Installed:
  oracle-database-preinstall-19c.x86_64 0:1.0-3.el7                                                                                                                        

Dependency Installed:
  GeoIP.x86_64 0:1.5.0-14.el7                             bind-libs.x86_64 32:9.11.4-26.P2.el7_9.7              bind-libs-lite.x86_64 32:9.11.4-26.P2.el7_9.7            
  bind-license.noarch 32:9.11.4-26.P2.el7_9.7             bind-utils.x86_64 32:9.11.4-26.P2.el7_9.7             compat-libcap1.x86_64 0:1.10-7.el7                       
  geoipupdate.x86_64 0:2.5.0-1.el7                        ksh.x86_64 0:20120801-142.el7                         smartmontools.x86_64 1:7.0-2.el7                         
  sysstat.x86_64 0:10.1.5-19.el7                          xorg-x11-utils.x86_64 0:7.5-23.el7                   

Complete!

装置 Oracle 数据库 

 yum install oracle-database-ee-19c-1.0-1.x86_64.rpm 
 Installed:
  oracle-database-ee-19c.x86_64 0:1.0-1                                                                      
Complete!

配置数据库 

/etc/init.d/oracledb_ORCLCDB-19c configure
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.

Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.

配置好后设置以后用户下的环境变量 

vi ~/.bashrc    (关上文件后追加 oracle 的环境变量信息)
---------------------------------------------------
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1 
export ORACLE_SID=ORCLCDB
export PATH=$ORACLE_HOME/bin:$PATH
---------------------------------------------------

通过运行
source ~/.bashrc（命令运行后设置的环境变量失效）

验证装置是否正确 

su oracle   (用户切换到 oracle 用户)
sysplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 17 18:59:32 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL>

运行以上命令 确认 Oracle 数据库是否可能正确连贯胜利。

退出移动版