oracle 18c em express tips

[email protected]> select dbms_xdb_config.gethttpport() from dual;

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

[email protected]> exec DBMS_XDB_CONFIG.SETHTTPPORT(2200);

PL/SQL procedure successfully completed.

[email protected]> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);

PL/SQL procedure successfully completed.

[email protected]> select dbms_xdb_config.gethttpport() from dual;

DBMS_XDB_CONFIG.GETHTTPPORT()
-----------------------------
						 2200

[email protected]> select dbms_xdb_config.gethttpsport() from dual;

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

[email protected]> 
[email protected]> desc resource_view
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 RES                                                XMLTYPE(XMLSchema "http://xm
													lns.oracle.com/xdb/XDBResour
													ce.xsd" Element "Resource")
 ANY_PATH                                           VARCHAR2(4000)
 RESID                                              RAW(16)

[email protected]> select comp_name, version, status from dba_registry where comp_id = 'XDB';

COMP_NAME
--------------------------------------------------------------------------------
VERSION                        STATUS
------------------------------ --------------------------------------------
Oracle XML Database
18.0.0.0.0                     VALID


[email protected]> select owner, object_name, object_type, status from dba_objects where status = 'INVALID' and owner in ('SYS', 'XDB');

no rows selected

[email protected]> 

[email protected]> show parameter shared_servers

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
max_shared_servers                   integer
shared_servers                       integer     1
[email protected]> show parameter dispatchers

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dispatchers                          string      (PROTOCOL=TCP) (SERVICE=PRODCD
												 B1XDB)
max_dispatchers                      integer
[email protected]> 

[email protected]> set pagesize 1000
[email protected]> select USERNAME,NAME,ACCOUNT_STATUS,LOCK_DATE from cdb_users u,v$containers c where u.CON_ID=c.CON_ID and USERNAME ='SYSTEM' ;

USERNAME
--------------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
ACCOUNT_STATUS                   LOCK_DATE
-------------------------------- ---------
SYSTEM
PDB1
OPEN

SYSTEM
CDB$ROOT
OPEN


[email protected]> 

[email protected]> SELECT 'https://'||SYS_CONTEXT('USERENV','SERVER_HOST')||':'||dbms_xdb_config.gethttpsport()||'/em/' from dual;

'HTTPS://'||SYS_CONTEXT('USERENV','SERVER_HOST')||':'||DBMS_XDB_CONFIG.GETHTTPSP
--------------------------------------------------------------------------------
https://vedb:5500/em/

[email protected]> 
[email protected]> !lsnrctl status

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 03-AUG-2018 04:32:37

Copyright (c) 1991, 2018, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vedb.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date                03-AUG-2018 04:23:15
Uptime                    0 days 0 hr. 9 min. 22 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u02/app/oracle/product/18.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u02/app/oracle/diag/tnslsnr/vedb/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vedb.localdomain)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=vedb.localdomain)(PORT=5500))(Security=(my_wallet_directory=/u02/app/oracle/admin/PRODCDB1/xdb_wallet))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vedb.localdomain)(PORT=2200))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "71d0d407a00a472ae0536538a8c0bb43" has 1 instance(s).
  Instance "PRODCDB1", status READY, has 1 handler(s) for this service...
Service "PRODCDB1" has 1 instance(s).
  Instance "PRODCDB1", status READY, has 1 handler(s) for this service...
Service "PRODCDB1XDB" has 1 instance(s).
  Instance "PRODCDB1", status READY, has 1 handler(s) for this service...
Service "pdb1" has 1 instance(s).
  Instance "PRODCDB1", status READY, has 1 handler(s) for this service...
The command completed successfully

[email protected]> 

Advanced/Add Exception.../Confirm Security Exception

Do not provide the container name in "Container Name" field while logging in. This would allow you to connect to the EM Express console.
Otherwise, there will be an error for the logging.

Do not provide the container name in "Container Name" field while logging in. This would allow you to connect to the EM Express console.

Troubleshooting Why EM Express is not Working (Doc ID 1604062.1)
https://support.oracle.com/epmos/faces/DocumentDisplay?id=1604062.1