Details
-
Type: Maintenance
-
Status: Fixed (View Workflow)
-
Resolution: Unresolved
-
Labels:None
-
Old bug number:31592
-
environment:
-
Patch version:MF01,X803,MG03
Description
Summary:
When the ORA connector tries to log on to Oracle and the logon fails for
whatever reason, e.g. invalid password, the allocated handles and
sessions are not freed. A network connection to the server remains,
and an Oracle process remains running. These resources are not re-used
by the next logon. When this happens often, it can cause
resource depletion and trigger various error messages.
Symptoms:
Client error messages like
ORA-12518: TNS:listener could not hand off client connection
ORA-12516: TNS:listener could not find available handler with matching protocol
Lots of Oracle processes like
oracle 10103 1 0 10:08:26 ? 0:00 oraclemvprod (LOCAL=NO)
or
oracle 13703 13698 0 15:14 ? 00:00:00 oracleo1120z
DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))