My Oracle Support Banner

EM Express: Listener Hangs Intermittently in Environment Where EM Express Using HTTPS (Doc ID 2492032.1)

Last updated on NOVEMBER 02, 2020

Applies to:

Oracle Net Services - Version 12.1.0.2 and later
Information in this document applies to any platform.
This issue is limited in scope to a situation where a TCPS handler is registered against the DB Listener.
Lsnrctl services or status would a TCPS handler:
Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=my_db_host)(PORT=5501))(Security=(my_wallet_directory=/u01/app/oracle/admin/MY_DB/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Symptoms

The listener is hung and may be throwing numerous errors in the listener log that indicate a problem with a TCPS handler for HTTP.

http * (ADDRESS=(PROTOCOL=tcps)(HOST=MY_HOST)(PORT=54240)) * handoff * http * 12518

A LSNRCTL services check would show both TCP and TCPS handlers like:

Listening Endpoints Summary...
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=1521)))
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=1522))) 
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=<hostname>)(PORT=5501))(Security=(my_wallet_directory=/u01/app/oracle/admin/<instance>/xdb_wallet))(Presentation=HTTP)(Session=RAW))

 

This problem may occur after running any Security Scan on the listener process.

The listener log might show either or both of the following indicating an issue with the HTTP handler:

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=<hostname>)(PORT=5501))(Security=(my_wallet_directory=/u01/app/oracle/admin/xdb_wallet))(Presentation=HTTP)(Session=RAW))


30-AUG-2018 05:15:04 * http * (ADDRESS=(PROTOCOL=tcps)(HOST=<hostname>)(PORT=36150)) * handoff * http * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12547: TNS:lost contact
  TNS-12560: TNS:protocol adapter error
  TNS-00517: Lost contact

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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