Oracle: Oracle Enterprise Manager Express 12.2 Setup

Product: Oracle Enterprise Manager Express
Version: 12.2.0.1
Oracle Document URL: https://docs.oracle.com/database/121/ADMQS/GUID-BA75AD46-D22E-4914-A31E-C395CD6A2BBA.htm

Followed above Oracle Enterprise Manager Express 12.1 documentation to check my Oracle 12.2 EM Express login issue, and found the workaround.

Problem #1: Chrome blocks Adobe Flash content, so Oracle EM Express login screen won't appear
Solution: Uses IE 11 in Windows 10

Problem #2: Accessing http://hostname:8080 consistently getting prompt with That server also reports: "XDB" and cannot login as SYSTEM as SYS users

Solution: Change http://hostname:8080/em, which contains the extra "/em"

Problem #3: HTTP port is not configured, but only HTTPS. I prefer HTTP for ease of troubleshooting, and not to maintain self-signed SSL cert
Solution:

1. Login to sqlplus as system, and run following:

exec DBMS_XDB_CONFIG.SETHTTPSPORT(8080);

2. Stop Listener

lsnrctl stop

3. Start Listener

lsnrctl start

4. Checks listener is showing extra entry for port 8080

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=8080))(Presentation=HTTP)(Session=RAW))

Problem 3: EM Express keeps prompting me with a dialog box with credential to XDB
Solution:

1. Login to sqlplus as system, and run following

exec dbms_xdb_config.setglobalportenabled(TRUE);

2. Restart Oracle database

3. Access http://hostname:8080/em and unable to login with following XDB login screen and able to see the login screen

Issue resolved