Enterprise Manager (EM) Database Express 是一个轻量级管理工具。该工具可为单个Oracle DB（或数据库集群）提供基于 Web 的现成管理解决方案，包括性能监视、配置管理、管理、诊断和优化。 EM Database Express 的目标是公开随数据库安装提供的主要 Enterprise Manager 数据库功能，其开发成本较低并且在数据库中占用的空间很少。 EM Database Express 占用的空间很少，只有 50-100 MB。它使用最低限度的 CPU 和内存开销在数据库内运行，因为数据库仅运行 SQL 调用，而在浏览器中执行 UI 呈现。 EM Express UI 使用基于 Web 的控制台与 XML DB 中提供的内置 Web 服务器进行通信。处理来自控制台的请求时，是 EM Express servlet 在处理这些请求，包括验证、会话管理、压缩和高速缓存。该 servlet 处理报告的请求并返回由 Web 浏览器呈现的 XML页面。通常每个页面只有一个请求，以减少与数据库之间的往返次数。
在Oracle Database 12c及以上版本， EM Database Control 不再可用，由 EM Database Express取代。 EM Database Express 可在 Database Configuration Assistant (DBCA) 中通过一次单击来进行配置。 EM Database Express 要求安装 XMLDB 组件。
SQL> col COMP_NAME for a50 SQL> col VERSION for a30 SQL> col status for a20 SQL> select comp_name,version,status from dba_registry order by status; COMP_NAME VERSION STATUS -------------------------------------------------- ------------------------ Oracle Real Application Clusters 19.0.0.0.0 OPTION OFF Oracle Database Vault 19.0.0.0.0 VALID JServer JAVA Virtual Machine 19.0.0.0.0 VALID Oracle XDK 19.0.0.0.0 VALID Oracle Database Java Packages 19.0.0.0.0 VALID OLAP Analytic Workspace 19.0.0.0.0 VALID Oracle XML Database 19.0.0.0.0 VALID Oracle Workspace Manager 19.0.0.0.0 VALID Oracle Text 19.0.0.0.0 VALID Oracle Multimedia 19.0.0.0.0 VALID Spatial 19.0.0.0.0 VALID Oracle OLAP API 19.0.0.0.0 VALID Oracle Label Security 19.0.0.0.0 VALID Oracle Database Catalog Views 19.0.0.0.0 VALID Oracle Database Packages and Types 19.0.0.0.0 VALID 15 rows selected.
要在数据库中激活 EM Database Express，请验证 DISPATCHERS 初始化参数是否已至少为使用 TCP 协议的 XMLDB 服务配置了一个分派程序。使用 DBMS_XDB_CONFIG.setHTTPsPort（使用 SSL 进行保护）或DBMS_XDB_CONFIG.setHTTPPort 过程配置在服务器上使用的端口。如果您配置了 安全连接，请使用URL 连接到 EM Database Express 控制台。如果您是使用 setHTTPPort 过程配置的端口，请使用类似 http://hostname:5500/em的 URL。 如果在同一台计算机上有多个要监视的数据库实例，则每个实例需要使用不同的端口 一、CDB配置https端口的EM Express1、检查环境
[oracle@db19do01 soft]$ . oraenv ORACLE_SID = [cdb19c] ? The Oracle base remains unchanged with value /u01/app/oracle [oracle@db19do01 soft]$ ps -ef|grep tns root 33 2 0 Dec09 ? 00:00:00 [netns] oracle 19358 8281 0 13:45 pts/0 00:00:00 grep --color=auto tns oracle 23103 1 0 00:04 ? 00:00:02 /u01/app/oracle/product/12.2.0.3/db_1/bin/tnslsnr LISTENER -inherit
2、检查监听状态
[oracle@db19do01 soft]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 10-DEC-2020 13:45:30 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=db19do01.example.com)(PORT=1525))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 31-JUL-2020 10:09:51 Uptime 132 days 3 hr. 35 min. 38 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/12.2.0.3/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/db19do01/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db19do01.example.com)(PORT=1525))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1525))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=db19do01.example.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/cdb19c/xdb_wallet))(Presentation=HTTP)(Session=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=db19do01.example.com)(PORT=5502))(Security=(my_wallet_directory=/u01/app/oracle/admin/cdb19c/xdb_wallet))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s). Instance "cdb19c", status READY, has 1 handler(s) for this service... Service "9b1087a6acc04dc2e05386d0a8c02562" has 1 instance(s). Instance "cdb19c", status READY, has 1 handler(s) for this service... Service "cdb19c" has 1 instance(s). Instance "cdb19c", status READY, has 1 handler(s) for this service... Service "cdb19cXDB" has 1 instance(s). Instance "cdb19c", status READY, has 1 handler(s) for this service... Service "nocdb19" has 1 instance(s). Instance "nocdb19", status READY, has 1 handler(s) for this service... Service "nocdb19XDB" has 1 instance(s). Instance "nocdb19", status READY, has 1 handler(s) for this service... Service "xfpdb" has 1 instance(s). Instance "cdb19c", status READY, has 1 handler(s) for this service... The command completed successfully
3、检查dispatchers参数
[oracle@db19do01 soft]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 1 11:00:18 2020 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
4、为CDB配置5500端口
SQL> select dbms_xdb_config.gethttpsport FROM DUAL; GETHTTPSPORT ------------ 0 SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500); PL/SQL procedure successfully completed. SQL> select dbms_xdb_config.gethttpsport FROM DUAL; GETHTTPSPORT ------------ 5500 SQL> show parameter dispatchers NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dispatchers string (PROTOCOL=TCP) (SERVICE=cdb19c XDB) max_dispatchers integer
登录EM Express
EM Database Express
主页提供了有关数据库实例状态和活动的整体视图。
EM Database Express
基于数据库中的通用报告框架而构建。因此，
EM
DatabaseExpress
只有在数据库打开时才可用。不能使用
EM Database Express
来启动数据库。二、PDB配置https端口为5502的EM
[oracle@db19do01 soft]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 10 11:01:57 2020 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> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 XFPDB MOUNTED SQL> alter pluggable database xfpdb open; Pluggable database altered. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 XFPDB READ WRITE NO SQL> alter session set container=xfpdb; Session altered. SQL> select dbms_xdb_config.gethttpsport FROM DUAL; GETHTTPSPORT ------------ 0 SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5502); PL/SQL procedure successfully completed.
-The end-
![20201215]记录工作中的错误.txt](/d/file/efpub/2026/03-03/small11b68f5890cfe5dcaa64689aa1133fb71772525877.jpg "20201215]记录工作中的错误.txt")
