Oracle Database Express Edition (XE)配置与部署

获取下载安装包

https://www.oracle.com/cn/database/technologies/xe-downloads.html

https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/index.html

1
2
3
4

---

安装.rpm安装包

cd /usr/local/src
wget https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-21c-1.0-1.ol7.x86_64.rpm
wget https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-21c-1.0-1.el7.x86_64.rpm
1
2
3

yum -y install bind-utils glibc-devel ksh nfs-utils policycoreutils-python psmisc smartmontools sysstat unzip xorg-x11-utils xorg-x11-xauth

rpm -ivh oracle-database-preinstall-21c-1.0-1.el7.x86_64.rpm 

rpm -ivh oracle-database-xe-21c-1.0-1.ol7.x86_64.rpm
1
2
3
4
5

---

配置初始化数据库

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

---

设置Oracle用户环境变量

su - oracle
 
vim .bashrc
export ORACLE_HOME=/opt/oracle/product/21c/dbhomeXE
export ORACLE_SID=XE
export CHARSET=AL32UTF8
export PATH=$PATH:$ORACLE_HOME/bin
 
source .bashrc
1
2
3
4
5
6
7
8
9

---

连接数据库

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 21.0.0.0.0 - Production on Thu Oct 5 21:19:33 2023
Version 21.3.0.0.0

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


Connected to:
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
1
2
3
4
5
6
7
8
9
10
11

---

查询数据库信息

SQL> col name for a30
SQL> select con_id,name,open_mode from v$pdbs;

    CON_ID NAME                           OPEN_MODE
---------- ------------------------------ ----------
         2 PDB$SEED                       READ ONLY
         3 XEPDB1                         READ WRITE
1
2
3
4
5
6
7

---

DBeaver连接OracleXE

# 关闭防火墙
service firewalld stop
1
2