Uploaded image for project: 'Reported Issues'
  1. Reported Issues
  2. RI-18

Oracle driver does not clean up or reuse resources when a logon fails.

    XMLWordPrintable

    Details

    • Type: Maintenance
    • Status: Fixed (View Workflow)
    • Resolution: Unresolved
    • Labels:
      None
    • Old bug number:
      31592
    • environment:
      Hide

      Uniface: All versions
      Operating System: All
      Database: Oracle

      Show
      Uniface: All versions Operating System: All Database: Oracle
    • 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)))

        Attachments