How to Configure OEM Express Oracle 12c

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

该文详细介绍了如何在Oracle数据库12c环境中，针对CDB1和PDB1配置OracleEnterpriseManagerExpress(OEMExpress)。首先，通过查询确认OEMExpress是否已配置，然后分别设置CDB和PDB的HTTP及HTTPS端口，最后，登录并验证OEMExpress的配置结果。

摘要由CSDN通过智能技术生成

Goal:Configure OEM Express for both CDB(CDB1) and PDB(PDB1)

Version		: 12.2.0.1.0
OS    	 	: Red Hat Enterprise Linux Server release 7.9
IP     		: 192.168.8.130
CDB NAME	: CDB1
PDB NAME	: PDB1

1.Introduction

Oracle Enterprise Manager Express is a Web-based interface for managing an Oracle database 12c. 
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@ol7 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Feb 8 21:25:17 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> show con_name;

CON_NAME
------------------------------
CDB$ROOT
SQL> 
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> 
SQL> show con_name;

CON_NAME
------------------------------
CDB$ROOT
SQL> 
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 PDB3 			  READ WRITE NO
SQL>           
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 PDB4 to run on ports: HTTPs 5500 and HTTP 5510

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

[oracle@ol7 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Feb 8 21:30:48 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> set pagesize 200
SQL> set linesize 200
SQL> 
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> 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> 
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> 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://ol7:5500/em 
http://ol7:5510/em

6. Configure OEM Express for PDB1

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

SQL> 
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 PDB3 			  READ WRITE NO
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> 
SQL> 
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> 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