Oracle Database Express 18.4版本：敏捷的二步安装法

最新推荐文章于 2023-10-06 10:08:49 发布

eygle

最新推荐文章于 2023-10-06 10:08:49 发布

阅读量759

点赞数 2

分类专栏：数据库 Oracle技术 IT大事记

本文链接：https://blog.csdn.net/eygle/article/details/105088412

版权

Oracle技术同时被 3 个专栏收录

208 篇文章 4 订阅

订阅专栏

IT大事记

57 篇文章 1 订阅

订阅专栏

数据库

47 篇文章 0 订阅

订阅专栏

墨天轮原文链接：https://www.modb.pro/db/21800?ywm

可能有些朋友还不知道，Oracle 推出了完全免费的 Express 版本，虽然存在一些功能限制，但是这个版本是完全免费的，只要你需要，可以随意适用。

现在，Oracle 也将这个版本的安装简化到了极致。
安装这个版本，你只需要两个步骤：

第一：安装preinstall安装包
第二：安装数据库软件包

两者都简约到极致，第一步，下载安装预需求包：

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

第二步，安装数据库软件包，从 OTN 直接抓取软件，你不需要帐号，不需要登录：

yum -y install https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-18c-1.0-1.x86_64.rpm

一些基本的输出如下：

[root@enmodb1 ~]# cat /etc/redhat-release 
CentOS Linux release 7.2.1511 (Core) 
[root@enmodb1 ~]# 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
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 18244  100 18244    0     0   6888      0  0:00:02  0:00:02 --:--:--  6889
[root@enmodb1 ~]# yum -y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
Loaded plugins: fastestmirror
Examining oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm: oracle-database-preinstall-18c-1.0-1.el7.x86_64
Marking oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-preinstall-18c.x86_64 0:1.0-1.el7 will be installed
--> Processing Dependency: compat-libcap1 for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
Loading mirror speeds from cached hostfile
 * base: mirrors.cqu.edu.cn
 * epel: mirrors.yun-idc.com
 * extras: mirrors.cqu.edu.cn
 * updates: mirrors.cqu.edu.cn
--> Processing Dependency: compat-libstdc++-33 for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: ksh for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: xorg-x11-utils for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Running transaction check
---> Package compat-libcap1.x86_64 0:1.10-7.el7 will be installed
---> Package compat-libstdc++-33.x86_64 0:3.2.3-72.el7 will be installed
---> Package ksh.x86_64 0:20120801-139.el7 will be installed
---> Package xorg-x11-utils.x86_64 0:7.5-23.el7 will be installed
--> Processing Dependency: libdmx.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libXxf86dga.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libXv.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Running transaction check
---> Package libXv.x86_64 0:1.0.11-1.el7 will be installed
---> Package libXxf86dga.x86_64 0:1.1.4-2.1.el7 will be installed
---> Package libdmx.x86_64 0:1.1.3-3.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

======================================================================================================================================================
 Package                                 Arch            Version                      Repository                                                 Size
======================================================================================================================================================
Installing:
 oracle-database-preinstall-18c          x86_64          1.0-1.el7                    /oracle-database-preinstall-18c-1.0-1.el7.x86_64           55 k
Installing for dependencies:
 compat-libcap1                          x86_64          1.10-7.el7                   base                                                       19 k
 compat-libstdc++-33                     x86_64          3.2.3-72.el7                 base                                                      191 k
 ksh                                     x86_64          20120801-139.el7             base                                                      885 k
 libXv                                   x86_64          1.0.11-1.el7                 base                                                       18 k
 libXxf86dga                             x86_64          1.1.4-2.1.el7                base                                                       19 k
 libdmx                                  x86_64          1.1.3-3.el7                  base                                                       16 k
 xorg-x11-utils                          x86_64          7.5-23.el7                   base                                                      114 k

Transaction Summary
======================================================================================================================================================
Install  1 Package (+7 Dependent packages)

Total size: 1.3 M
Total download size: 1.2 M
Installed size: 4.3 M
Downloading packages:
(1/7): compat-libcap1-1.10-7.el7.x86_64.rpm                                                                                    |  19 kB  00:00:00     
(2/7): compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm                                                                             | 191 kB  00:00:00     
(3/7): libXv-1.0.11-1.el7.x86_64.rpm                                                                                           |  18 kB  00:00:00     
(4/7): libXxf86dga-1.1.4-2.1.el7.x86_64.rpm                                                                                    |  19 kB  00:00:00     
(5/7): ksh-20120801-139.el7.x86_64.rpm                                                                                         | 885 kB  00:00:00     
(6/7): libdmx-1.1.3-3.el7.x86_64.rpm                                                                                           |  16 kB  00:00:00     
(7/7): xorg-x11-utils-7.5-23.el7.x86_64.rpm                                                                                    | 114 kB  00:00:00     
------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                 1.5 MB/s | 1.2 MB  00:00:00     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : compat-libcap1-1.10-7.el7.x86_64                                                                                                   1/8 
  Installing : compat-libstdc++-33-3.2.3-72.el7.x86_64                                                                                            2/8 
  Installing : libXxf86dga-1.1.4-2.1.el7.x86_64                                                                                                   3/8 
  Installing : libXv-1.0.11-1.el7.x86_64                                                                                                          4/8 
  Installing : ksh-20120801-139.el7.x86_64                                                                                                        5/8 
  Installing : libdmx-1.1.3-3.el7.x86_64                                                                                                          6/8 
  Installing : xorg-x11-utils-7.5-23.el7.x86_64                                                                                                   7/8 
  Installing : oracle-database-preinstall-18c-1.0-1.el7.x86_64                                                                                    8/8 
  Verifying  : libdmx-1.1.3-3.el7.x86_64                                                                                                          1/8 
  Verifying  : ksh-20120801-139.el7.x86_64                                                                                                        2/8 
  Verifying  : libXv-1.0.11-1.el7.x86_64                                                                                                          3/8 
  Verifying  : oracle-database-preinstall-18c-1.0-1.el7.x86_64                                                                                    4/8 
  Verifying  : libXxf86dga-1.1.4-2.1.el7.x86_64                                                                                                   5/8 
  Verifying  : compat-libstdc++-33-3.2.3-72.el7.x86_64                                                                                            6/8 
  Verifying  : xorg-x11-utils-7.5-23.el7.x86_64                                                                                                   7/8 
  Verifying  : compat-libcap1-1.10-7.el7.x86_64                                                                                                   8/8 

Installed:
  oracle-database-preinstall-18c.x86_64 0:1.0-1.el7                                                                                                   

Dependency Installed:
  compat-libcap1.x86_64 0:1.10-7.el7   compat-libstdc++-33.x86_64 0:3.2.3-72.el7   ksh.x86_64 0:20120801-139.el7        libXv.x86_64 0:1.0.11-1.el7  
  libXxf86dga.x86_64 0:1.1.4-2.1.el7   libdmx.x86_64 0:1.1.3-3.el7                 xorg-x11-utils.x86_64 0:7.5-23.el7  

Complete!

安装数据库：

[root@enmodb1 ~]# yum -y install https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-18c-1.0-1.x86_64.rpm
Loaded plugins: fastestmirror
oracle-database-xe-18c-1.0-1.x86_64.rpm                                                                                        | 2.3 GB  00:33:09     
Examining /var/tmp/yum-root-EsjN01/oracle-database-xe-18c-1.0-1.x86_64.rpm: oracle-database-xe-18c-1.0-1.x86_64
Marking /var/tmp/yum-root-EsjN01/oracle-database-xe-18c-1.0-1.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-xe-18c.x86_64 0:1.0-1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

======================================================================================================================================================
 Package                                 Arch                    Version                  Repository                                             Size
======================================================================================================================================================
Installing:
 oracle-database-xe-18c                  x86_64                  1.0-1                    /oracle-database-xe-18c-1.0-1.x86_64                  5.2 G

Transaction Summary
======================================================================================================================================================
Install  1 Package

Total size: 5.2 G
Installed size: 5.2 G
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : oracle-database-xe-18c-1.0-1.x86_64                                                                                                1/1 
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure Oracle Database XE, optionally modify the parameters in '/etc/sysconfig/oracle-xe-18c.conf' and then execute '/etc/init.d/oracle-xe-18c configure' as root.
  Verifying  : oracle-database-xe-18c-1.0-1.x86_64                                                                                                1/1 

Installed:
  oracle-database-xe-18c.x86_64 0:1.0-1                                                                                                               

Complete!

配置数据库：

[root@enmodb1 ~]# /etc/init.d/oracle-xe-18c configure
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle Database XE.
Enter SYS user password: 
***********
Enter SYSTEM user password: 
************
Enter PDBADMIN User Password: 
**********
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
31% complete
34% complete
  38% complete
41% complete
43% complete
Completing Database Creation
47% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/XE.
Database Information:
Global Database Name:XE
System Identifier(SID):XE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/XE/XE.log" for further details.

Connect to Oracle Database using one of the connect strings:
     Pluggable database: enmodb1/XEPDB1
     Multitenant container database: enmodb1
Use https://localhost:5500/em to access Oracle Enterprise Manager for Oracle Database XE

连接数据库：

[oracle@enmodb1 ~]$ export ORACLE_SID=XE
[oracle@enmodb1 ~]$ export ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE
[oracle@enmodb1 ~]$ export PATH=$PATH:$ORACLE_HOME/bin
[oracle@enmodb1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Sat Feb 22 10:28:08 2020
Version 18.4.0.0.0

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


Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/opt/oracle/oradata/XE/system01.dbf
/opt/oracle/oradata/XE/sysaux01.dbf
/opt/oracle/oradata/XE/undotbs01.dbf
/opt/oracle/oradata/XE/pdbseed/system01.dbf
/opt/oracle/oradata/XE/pdbseed/sysaux01.dbf
/opt/oracle/oradata/XE/users01.dbf
/opt/oracle/oradata/XE/pdbseed/undotbs01.dbf
/opt/oracle/oradata/XE/XEPDB1/system01.dbf
/opt/oracle/oradata/XE/XEPDB1/sysaux01.dbf
/opt/oracle/oradata/XE/XEPDB1/undotbs01.dbf
/opt/oracle/oradata/XE/XEPDB1/users01.dbf

11 rows selected.

现在学习和接触 Oracle 数据库变得很简单！