My Oracle Support Banner

Troubleshooting Why EM Express is not Working (Doc ID 1604062.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.

Purpose

 This Note is Created to Troubleshoot EM Express not working issues and also lists EM Express known issues and bugs.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 1- Review the Basic EM Express Configuration
 2- Make Sure the XML Database option is installed and valid
 3- Make Sure that the Listener Register the XML DB :
 4- Make sure the SYSTEM account are not Locked or Expired :
 5- Connect to the XDB service as the SYSTEM user
 6- Try Different Browsers (IE,Chrome,FireFox) and/or Try To Disable all Browser Addons and/or Try old versions of Browsers which were available at db release
 7- Check if Flash Plugin is Enabled
 Web browsers Requirements
 From Firefox
 From Google Chrome
 8- Check The Alert Log file and Listener Log file for errors logged around the time of launching the URL for EM Express
 
 9- Check the listener end points of the XML DB HTTP server
 10- Wallet file permissions when RDBMS sits on top of GI with role separation -- This case is only applicable to UNIX platform.
 11- Known errors which can affect EM Express :
 ORA-00600: internal error code, arguments: [kziaulslt: lid], [1821]
 ORA-00600: internal error code, arguments: [kziaulslt: lid], [1818]
 Bug 16527374 : CDB:ORA-07445:EM EXPRESS HOME GOT IO ERROR
 Connection Fail : Connection with database failed. Database instance might be down. Try again once it is up
 Detail : [IOErrorEvent type='ioError' bubbles=false cancelable=false eventPhase=2 text='Error #2032']
 ORA-07445: exception encountered: core dump [qervwRowProcedure()+] [SIGSEGV] [ADDR:0x5] [PC:0xB5C0C21] [Address not mapped to object]
 ORA-07445: exception encountered: core dump [qervwFetch()+] [ACCESS_VIOLATION] [ADDR:0x8] [PC:0x1464D2038] [UNABLE_TO_READ] []
after successfully login to EM Express the chart of [Resources] & [SQL Monitor] Charts can not be loaded , and stays loading forever

 Bug 16102371 : EM EXPRESS URL DOES NOT WORK
 Bug 16219867 : EM Express URL displayed by the DBCA summary may not work
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.