Oracle 19c Database Configure the HTTPS Port for EM Express
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 過程配置的埠,請使用類似 的 URL。
如果在同一臺計算機上有多個要監視的資料庫例項,則每個例項需要使用不同的埠
一、CDB配置https埠的EM Express
1、檢查環境
[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-
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28373936/viewspace-2741024/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 12c EM Database ExpressDatabaseExpress
- Oracle 19C EMOracle
- oracle 重建EM databaseOracleDatabase
- ORACLE 12C EM ExpressOracleExpress
- Oracle 19c Database Management ToolsOracleDatabase
- 1 Oracle Database 19c 新特性OracleDatabase
- Sqlcl 連線Oracle DataBase 19cSQLOracleDatabase
- Oracle Database 19c安裝Sample SchemasOracleDatabase
- se://error/ Oracle 19c EM Exporess無法登陸ErrorOracle
- 4.4 為CDB配置EM ExpressExpress
- Oracle 19c Concepts(13):Oracle Database InstanceOracleDatabase
- Oracle 19c Concepts(01):Introduction to Oracle DatabaseOracleDatabase
- Oracle Database 19c中的自動索引OracleDatabase索引
- Oracle EM Express要求使用者名稱和密碼OracleExpress密碼
- express 配置httpsExpressHTTP
- 【EM】重新建立EM Database ControlDatabase
- Oracle EM Https WIndows不能訪問防火牆配置OracleHTTPWindows防火牆
- Oracle 12c Enterprise Manager Database ExpressOracleDatabaseExpress
- 安裝oracle 10g EM database controlOracle 10gDatabase
- EM 12c推送Agent出錯 - OMS_HOST and EM_UPLOAD_PORT is not availableAI
- Oracle 19c Concepts(00):Changes in This Release for Oracle Database ConceptsOracleDatabase
- Oracle OCP IZ0-053 Q660(Configure Flashback Database)OracleDatabase
- oracle 12c CDB企業管理器(EM Express)的配置方法OracleExpress
- Oracle 19c Concepts(19):Concepts for Database DevelopersOracleDatabaseDeveloper
- 【EM】通過portlist.ini檔案得到OEM Console HTTP Port和OEM Agent PortHTTP
- Linux下啟動Oracle database EM及isqlplus等命令LinuxOracleDatabaseSQL
- linux下配置oracle 10G EM Database ConsoleLinuxOracle 10gDatabase
- Oracle 19c Concepts(17):Topics for Database Administrators and DevelopersOracleDatabaseDeveloper
- Oracle 19c Concepts(18):Concepts for Database AdministratorsOracleDatabase
- 【kingsql分享】Oracle Database 19c的各種新特性介紹SQLOracleDatabase
- Oracle Database 19c(19.9) RAC On RedHat 8.3 Using VirtualBox and MacBookOracleDatabaseRedhatMac
- Oracle 19c透過recover standby database from service修復GAP案例OracleDatabase
- ORACLE EM recreateOracle
- 重建oracle EMOracle
- EM Express 常見問題 (文件 ID 2102453.1)Express
- 使用Express搭建https伺服器ExpressHTTP伺服器
- nginx: 400 Bad Request | The plain HTTP request was sent to HTTPS portNginxAIHTTP
- Oracle 19c DBA's Guide(01): Getting Started with Database AdministrationOracleGUIIDEDatabase