EM Express: Listener Hangs Intermittently in Environment Where EM Express Using HTTPS
(Doc ID 2492032.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Net Services - Version 12.1.0.2 and laterInformation 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 |