1. 首先查看监听状态,如果监听没有启动需要先启动监听
[oracle@Oracle12C ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 13-JAN-2022 02:12:50
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Oracle12C)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 01-NOV-2021 15:30:04
Uptime 72 days 10 hr. 42 min. 46 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/Oracle12C/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Oracle12C)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s). /* service "orclXDB"是Oracle9i后创建数据库 时默认包含的XML DB特性,提供http、 https、ftp等服务 */
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@Oracle12C ~]$
2. 在SQLplus下查看XDBhttp端口或XDBhttps端口的状态
[oracle@Oracle12C ~]$ sqlplus sys/oracle as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Thu Jan 13 02:18:55 2022
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 // 0表示没有设置端口
SQL> select dbms_xdb_config.getHttpPort() from dual;
DBMS_XDB_CONFIG.GETHTTPPORT()
-----------------------------
0
// 0表示没有设置端口
SQL>
3. 配置OEM-express通过https或http的访问端口
SQL>
SQL> exec dbms_xdb_config.setHttpsPort(8089);
PL/SQL procedure successfully completed.
SQL> exec dbms_xdb_config.setHttpPort(8090);
PL/SQL procedure successfully completed.
SQL>
4. 检查端口设置是否成功
SQL> exec dbms_xdb_config.setHttpsPort(8089);
PL/SQL procedure successfully completed.
SQL> exec dbms_xdb_config.setHttpPort(8090);
PL/SQL procedure successfully completed.
SQL> select dbms_xdb_config.getHttpsPort() from dual;
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
8089
SQL> select dbms_xdb_config.getHttpPort() from dual;
DBMS_XDB_CONFIG.GETHTTPPORT()
-----------------------------
8090
SQL>
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@Oracle12C ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 13-JAN-2022 02:32:35
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Oracle12C)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 01-NOV-2021 15:30:04
Uptime 72 days 11 hr. 2 min. 31 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/Oracle12C/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Oracle12C)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
/* 监听中新增了内容 */
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=Oracle12C)(PORT=8089))(Security=(my_wallet_directory=/u01/app/oracle/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Oracle12C)(PORT=8090))(Presentation=HTTP)(Session=RAW))
/* 多了上面两行 */
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@Oracle12C ~]$
5. 通过浏览器访问https://数据库服务器IP:8089/em/login 和 http://数据库服务器IP:8090/em/login 分别验证