Oracle 18c XE RPM Installation on Oracle Linux 7.5

发布 : 2019-07-05 分类 : Oracle 浏览 :

通过rpm包来安装oracle express非常方便,有点一键安装的感觉。

XE版的限制

  • 3 Pluggable Databases
  • 2 CPUs for foreground processes
  • 2GB of RAM (SGA and PGA combined)
  • 12GB of user data on disk (irrespective of compression factor)

    环境

  • Oracle 18c 18.4 64bit
  • Oracle Linux 64bit
  • VMware Workstation Pro 15

    下载

    现阶段,oracle express 18c已经提供Windows和Linux的版本下载。
  • Oracle Express 18c RPM: 下载地址

    安装和配置Oracle Linux 7

    Oracle Linux安装见 Oracle Linux 7安装指南

安装Oracle Express 18c

准备工作

Oracle已经帮我们准备一个配置必要条件用的软件包oracle-database-preinstall-18c,包括了安装必要的软件包,创建用户,设置参数等等工作,很方便。

1
yum install -y oracle-database-preinstall-18c

Oracle软件安装

本例中,RPM包下载在/software中,用yum -y localinstall进行本地软件安装

1
yum -y localinstall oracle-database-xe-18c-1.0-1.x86_64.rpm

Alt text

Oracle数据库创建

Oracle环境变量配置

可以通过/etc/sysconfig/oracle-xe-18c.conf进行设置

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
[root@ora183 ~]# cat /etc/sysconfig/oracle-xe-18c.conf
#This is a configuration file to setup the Oracle Database.
#It is used when running '/etc/init.d/oracle-xe-18c configure'.

# LISTENER PORT used Database listener, Leave empty for automatic port assignment
LISTENER_PORT=

# EM_EXPRESS_PORT Oracle EM Express URL port
EM_EXPRESS_PORT=5500

# Character set of the database
CHARSET=AL32UTF8

# Database file directory
# If not specified, database files are stored under Oracle base/oradata
DBFILE_DEST=

# SKIP Validations, memory, space
SKIP_VALIDATIONS=false

创建数据库

开始创建

1
/etc/init.d/oracle-xe-18c configure

注意:别忘了在/etc/hosts里面设置IP,否则会出现如下报错
Alt text

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
[root@ora183 ~]# /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: ora183.oracle.com/XEPDB1
Multitenant container database: ora183.oracle.com
Use https://localhost:5500/em to access Oracle Enterprise Manager for Oracle Database XE

复制环境变量

从配置文件/etc/init.d/oracle-xe-18c中复制环境变量到~/.bash_profile

History

v1.0 2018.11.06
v1.1 2019.07.02
v1.2 2019.07.04

本文作者 : Shen Peng
原文链接 : http://yoursite.com/2019/07/05/Oracle-18c-XE-RPM-Installation-on-Oracle-Linux-7-5/
版权声明 : 本博客所有文章除特别声明外,均采用 CC BY-NC-SA 4.0 许可协议。转载请注明出处!

知识 & 情怀 | 二者兼得

微信扫一扫, 向我投食

微信扫一扫, 向我投食

支付宝扫一扫, 向我投食

支付宝扫一扫, 向我投食

留下足迹