2 Replies Latest reply on Nov 2, 2018 9:14 PM by AndyPol

    ORDS - Borrowed Connections, Available Connections, Maximum Connections

    AndyPol

      Hi

       

      I'm a bit confused... my APEX application (APEX 5.1, ORDS on Tomcat, ORACLE 11.2) time to time returns 503. IN catalina.out I found this error:
      *** Error: Could not obtain a database connection because all connections in the pool: |apex|| were in use. Borrowed Connections: 44 Available Connections: 56 Maximum Connections: 100 ***

       

      I can't understand this error, available is 56 so why it can't obtains connection ?


      Regards

       

       

      Andrzej

        • 1. Re: ORDS - Borrowed Connections, Available Connections, Maximum Connections
          Pierre Yotti

          AndyPol wrote:

           

          Hi

           

          I'm a bit confused... my APEX application (APEX 5.1, ORDS on Tomcat, ORACLE 11.2) time to time returns 503. IN catalina.out I found this error:
          *** Error: Could not obtain a database connection because all connections in the pool: |apex|| were in use. Borrowed Connections: 44 Available Connections: 56 Maximum Connections: 100 ***

           

          I can't understand this error, available is 56 so why it can't obtains connection ?

           

           

          Can you give more Informations about the ORDS defaults.xml File. I think you should update that file and make the best settings for your Environment.

           

          That is whay we use and it works fine

           

           

          <entry key="error.maxEntries">50</entry>
          <entry key="jdbc.DriverType">thin</entry>
          <entry key="jdbc.InactivityTimeout">1800</entry>
          <entry key="jdbc.InitialLimit">6</entry>
          <entry key="jdbc.MaxConnectionReuseCount">10000</entry>
          <entry key="jdbc.MaxLimit">40</entry>
          <entry key="jdbc.MaxStatementsLimit">10</entry>
          <entry key="jdbc.MinLimit">6</entry>
          <entry key="jdbc.auth.enabled">true</entry>
          <entry key="jdbc.statementTimeout">900</entry>
          <entry key="log.logging">false</entry>
          <entry key="log.maxEntries">50</entry>
          

           

           

          You should also take a look here

          https://ora-00001.blogspot.com/2015/07/installing-oracle-xe-ords-and-apex-on-centos-linux-part-four.html?m=1

          https://docs.oracle.com/cd/E37099_01/doc.20/e25066/config_file.htm#AELIG7202

          http://krisrice.io/2012-05-14-apex-listener-jdbcsecurity-setup/

          • 2. Re: ORDS - Borrowed Connections, Available Connections, Maximum Connections
            AndyPol

            Hi Alli

             

            Here you go

            <entry key="cache.caching">false</entry>
            <entry key="cache.directory">/tmp/apex/cache</entry>
            <entry key="cache.duration">days</entry>
            <entry key="cache.expiration">7</entry>
            <entry key="cache.maxEntries">500</entry>
            <entry key="cache.monitorInterval">60</entry>
            <entry key="cache.procedureNameList"/>
            <entry key="cache.type">lru</entry>
            <entry key="db.hostname">localhost</entry>
            <entry key="db.port">1521</entry>
            <entry key="db.sid">orclprod</entry>
            <entry key="debug.debugger">false</entry>
            <entry key="debug.printDebugToScreen">false</entry>
            <entry key="error.keepErrorMessages">true</entry>
            <entry key="error.maxEntries">50</entry>
            <entry key="jdbc.DriverType">thin</entry>
            <entry key="jdbc.InactivityTimeout">1800</entry>
            <entry key="jdbc.InitialLimit">8</entry>
            <entry key="jdbc.MaxConnectionReuseCount">1000</entry>
            <entry key="jdbc.MaxLimit">100</entry>
            <entry key="jdbc.MaxStatementsLimit">50</entry>
            <entry key="jdbc.MinLimit">5</entry>
            <entry key="jdbc.statementTimeout">900</entry>
            <entry key="log.logging">false</entry>
            <entry key="log.maxEntries">50</entry>
            <entry key="misc.compress"/>
            <entry key="misc.defaultPage">apex</entry>
            <entry key="security.disableDefaultExclusionList">false</entry>
            <entry key="security.maxEntries">2000</entry>