How to Enable Oracle Enterprise Manager Express 19c

DB架构

于 2023-01-31 22:13:14 发布

阅读量673

点赞数

分类专栏： DBA Installations 文章标签： oracle express 数据库

本文链接：https://blog.csdn.net/u011868279/article/details/128824187

版权

DBA 同时被 2 个专栏收录

183 篇文章 12 订阅

订阅专栏

Installations

16 篇文章 0 订阅

订阅专栏

1. Introduction

Oracle Enterprise Manager Express is a Web-based interface for managing an Oracle database 19c. 
Used to perform basic administrative tasks such as 

- Managing users
- Managing memory
- Managing storage
- Managing database initialization parameters
- Monitor performance
- View SQL Tuning Advisor information
- Verify status information container database and pluggable databases.

2. Verify OEM Express already configured or not for CDB1

If returned port number is 0, it means that EM Express is not configured for that particular container.

[oracle@oracle-db-19c ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jan 31 21:21:27 2023
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 con_name;

CON_NAME
------------------------------
CDB$ROOT
SQL> select DBMS_XDB_CONFIG.GETHTTPPORT() from dual;

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

SQL> select DBMS_XDB_CONFIG.GETHTTPSPORT() from dual;

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

SQL>

3. Verify OEM Express already configured or not for PDB1

SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT
SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 PDB2                           READ WRITE NO
         5 CNDBAPDB                       MOUNTED
         6 CNDBAPDB3                      MOUNTED
         7 CNDBAPDB2                      MOUNTED
         8 CNDBAPDB4_FRESH                MOUNTED
         9 CNDBAPDB6                      MOUNTED
SQL> alter session set container=PDB1;

Session altered.

SQL> show con_name;

CON_NAME
------------------------------
PDB1
SQL> select DBMS_XDB_CONFIG.GETHTTPPORT() from dual;

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

SQL> select DBMS_XDB_CONFIG.GETHTTPSPORT() from dual;

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

SQL>

4. Configure OEM Express for CDB (HTTPs & HTTP)

We are configuring EM Express for PDB1 to run on ports: HTTPs 5500 and HTTP 5510

[oracle@oracle-db-19c ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jan 31 21:23:24 2023
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> select name, cdb, con_id from v$database;

NAME                        CDB           CON_ID
--------------------------- --------- ----------
CDB1                        YES                0

SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> set pagesize 200
SQL> set linesize 200
SQL> select instance_name, status, con_id from v$instance;

INSTANCE_NAME                                    STATUS                                   CON_ID
------------------------------------------------ ------------------------------------ ----------
cdb1                                             OPEN                                          0

SQL> show parameter dispatchers

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
dispatchers                          string                            (PROTOCOL=TCP) (SERVICE=cdb1XD
                                                                       B)
max_dispatchers                      integer
SQL> prompt Execute the DBMS_XDB.setHTTPSPort procedure to set the HTTPS port 5500
Execute the DBMS_XDB.setHTTPSPort procedure to set the HTTPS port 5500
SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);

PL/SQL procedure successfully completed.

SQL> prompt Execute the DBMS_XDB.setHTTPPort procedure to set the HTTP port 5510 for EM Express
Execute the DBMS_XDB.setHTTPPort procedure to set the HTTP port 5510 for EM Express
SQL> exec DBMS_XDB_CONFIG.SETHTTPPORT(5510);

PL/SQL procedure successfully completed.

SQL> 
SQL> select DBMS_XDB_CONFIG.GETHTTPPORT() from dual;

DBMS_XDB_CONFIG.GETHTTPPORT()
-----------------------------
                         5510

SQL> select DBMS_XDB_CONFIG.GETHTTPSPORT() from dual;

DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
                          5500

SQL>

5. Login to EM Express for CDB

https://oracle-db-19c:5500/em

http://oracle-db-19c:5510/em

6. Configure OEM Express for PDB1

We are configuring EM Express for PDB1 to run on ports: HTTPs 5501 and HTTP 5511

[oracle@oracle-db-19c ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jan 31 21:56:40 2023
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 con_name;

CON_NAME
------------------------------
CDB$ROOT
SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 PDB2                           READ WRITE NO
         5 CNDBAPDB                       MOUNTED
         6 CNDBAPDB3                      MOUNTED
         7 CNDBAPDB2                      MOUNTED
         8 CNDBAPDB4_FRESH                MOUNTED
         9 CNDBAPDB6                      MOUNTED
SQL> alter session set container=PDB1;

Session altered.

SQL> show con_name;

CON_NAME
------------------------------
PDB1
SQL> prompt execute the DBMS_XDB.setHTTPSPort procedure to set the HTTPS port 5501
execute the DBMS_XDB.setHTTPSPort procedure to set the HTTPS port 5501
SQL> 
SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5501);

PL/SQL procedure successfully completed.

SQL> 
SQL> prompt execute DBMS_XDB.setHTTPPort procedure to set the HTTP port 5511 for EM Express
execute DBMS_XDB.setHTTPPort procedure to set the HTTP port 5511 for EM Express
SQL> 
SQL> exec DBMS_XDB_CONFIG.SETHTTPPORT(5511);

PL/SQL procedure successfully completed.

SQL> 
SQL> 
SQL> select DBMS_XDB_CONFIG.GETHTTPPORT() from dual;

DBMS_XDB_CONFIG.GETHTTPPORT()
-----------------------------
                         5511

SQL> select DBMS_XDB_CONFIG.GETHTTPSPORT() from dual;

DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
                          5501

SQL>

7. Login to EM Express for PDB1