Oracle Enterprise Manager Database Express (EM Express)

介绍

EM Express 是 oracle 内置（安装就有）的 web 端管理工具。它只有在数据库启动后才能使用，也没法通过它来启停数据库。还有其他比如开启归档日志等功能也没法通过它去操作。但是它的功能还是很强大的，至少覆盖 oracle 数据库管理工作的 70% 的工作。可以作为了解 oracle 的辅助工具。

开启

# 查看开放的端口
select dbms_xdb_config.gethttpport() from dual;
select dbms_xdb_config.gethttpsport() from dual;

# 开启端口（可以只开启一个）
SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);
SQL> exec DBMS_XDB_CONFIG.SETHTTPPORT(5502);


[oracle@testserver ~]$ sqlplus  / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Nov 30 11:05:37 2023

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select dbms_xdb_config.gethttpsport() from dual;


DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
                             0


SQL>
SQL>  select dbms_xdb_config.gethttpport() from dual;

DBMS_XDB_CONFIG.GETHTTPPORT()
-----------------------------
                            0

SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);

PL/SQL procedure successfully completed.

SQL> exec DBMS_XDB_CONFIG.SETHTTPPORT(5502);

PL/SQL procedure successfully completed.

SQL>