Shared Server Connections Hung, Waiting on Virtual Circuit Status via Juniper Firewall
(Doc ID 1068158.1)
Last updated on JANUARY 21, 2025
Applies to:
Oracle Net Services - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]Oracle Database - Enterprise Edition - Version 19.21.0.0.0 and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Connections to database, via Juniper firewall, using the shared server connection model hanging, waiting on event "virtual circuit status". 10046 of hung session confirms followingReceived ORADEBUG command 'event 10046 trace name context forever, level 12' from process Unix process pid: 15410, image:
*** 2010-02-25 13:40:22.137
WAIT #4: nam='virtual circuit status' ela= 48691363 circuit#=65 status=2 p3=0 obj#=-1 tim=69157325240
*** 2010-02-25 13:40:34.568
Received ORADEBUG command 'unlimit' from process Unix process pid: 15410, image:
Received ORADEBUG command 'dump errorstack 3' from process Unix process pid: 15410, image:
v$session information shows the process is active*** 2010-02-25 13:40:22.137
WAIT #4: nam='virtual circuit status' ela= 48691363 circuit#=65 status=2 p3=0 obj#=-1 tim=69157325240
*** 2010-02-25 13:40:34.568
Received ORADEBUG command 'unlimit' from process Unix process pid: 15410, image:
Received ORADEBUG command 'dump errorstack 3' from process Unix process pid: 15410, image:
Other symptons might include application log for the connections showing the errors
ORA-1041 "internal error. hostdef extension doesn't exist"
ORA-3113 "end-of-file on communication channel"
ORA-3114 "not connected to ORACLE"
ORA-3113 "end-of-file on communication channel"
ORA-3114 "not connected to ORACLE"
Changes
Juniper firewall upgradeCause
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 |