During database creation, DBCA enables Enterprise Manager Express (EM Express) for being created CDB, not for PDB. We have to enable it by ourselves. In this post, you can see steps that you should take to start EM express which is dedicated for a CDB/PDB.
Acess URL : https://hostname-or-ipaddress:5501/em
Function used :
1. https
2. http
[oracle@west01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Aug 11 13:31:02 2020
Version 19.8.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> select dbms_xdb_config.gethttpsport() from dual;
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
0
SQL> exec dbms_xdb_config.sethttpsport(5500);
PL/SQL procedure successfully completed.
SQL> select dbms_xdb_config.gethttpsport() from dual;
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
5500
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 WORAVRPDB1 READ WRITE NO
SQL> alter session set container=WORAVRPDB1;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
WORAVRPDB1
SQL> select dbms_xdb_config.gethttpsport() from dual;
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
0
SQL> exec dbms_xdb_config.sethttpsport(5501);
PL/SQL procedure successfully completed.
SQL> select dbms_xdb_config.gethttpsport() from dual;
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
5501
EM Express 19c Flash-Based
Since Oracle database 19c, we have a new UI of Enterprise Manager Express (EM Express) which is based on Java JET technology.
I installed Oracle 19c database. I logged as System user into Enterprise Manager. I want to create new user and set permissions to him, but the Server tab is missing. There is only Performance tab.
As you can see, some functions we used in EM Express 12c are not available anymore in the new UI. On the positive side, it responds very fast, very express. But maybe it's too simplified to be useful for DBA. Luckily, we can revert the UI back to flash-based.
SQL> @?/rdbms/admin/execemx emx
Session altered.
no rows selected
old 1: select nvl( '&1','omx') p1 from dual
new 1: select nvl( 'emx','omx') p1 from dual
P1
---
emx
PL/SQL procedure successfully completed.
Session altered.
After that, please re-logon to make it work.
To go back to Java JET based UI, you can do this:
SQL> @?/rdbms/admin/execemx omx
Session altered.
no rows selected
old 1: select nvl( '&1','omx') p1 from dual
new 1: select nvl( 'omx','omx') p1 from dual
P1
---
omx
PL/SQL procedure successfully completed.
Session altered.
https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/getting-started-with-database-administration.html#GUID-F1C3023C-35DC-4086-A63F-F58F3FFC2923
