5 Replies Latest reply: Jan 21, 2013 6:07 PM by 985110 RSS

    Does apex listener 2 EA have a maximum amount of DB's?

    985110
      Hi,

      We have been using the APEX listener 2.0 EA, and have configured at least 4 databases against the listener( default + 3)

      We are now trying to add 2 more databases, but no matter what we do we cannot connect ot the new ones?

      Is there a limit of how many you can configure?

      We would have 6 now (default + 5) , but the last 2 are not working.

      We get the following in the access log and in the browser

      Access Log shows
      The access log at /data1/software/oracle/product/as11g_pfrd_dev/user_projects/domains/PFRD_Domain/servers/WLS_APEX/logs/access.log shows:
      10.101.51.54 - - [14/Jan/2013:15:36:05 +1030] "GET /apex/apex_r12ebsuat1/apex HTTP/1.1" 302 371
      10.101.51.54 - - [14/Jan/2013:15:36:19 +1030] "GET /apex/apex_r12ebsuat2/apex HTTP/1.1" 302 371
      10.101.51.54 - - [14/Jan/2013:15:36:35 +1030] "GET /apex/apex_r12ebspoc/apex HTTP/1.1" 302 371
      10.101.51.54 - - [14/Jan/2013:15:36:49 +1030] "GET /apex/apex_r12ebsdev/apex HTTP/1.1" 503 6279
      10.101.51.54 - - [14/Jan/2013:15:37:22 +1030] "GET /apex/apex_r12ebsptch/apex HTTP/1.1" 503 6279

      Note that, ebsuat1, ebsuat2, ebspoc work and ebsdev and ebsptch dont work.

      Trying to access the apex applicaitons from the browser on
      http://phxoradevas10.someplace.com:7785/apex/apex_r12ebsdev/apex

      gives us the following error



      Failure of server APACHE bridge:

      --------------------------------------------------------------------------------
      No backend server available for connection: timed out after 10 seconds or idempotent set to OFF.


      Regards
        • 1. Re: Does apex listener 2 EA have a maximum amount of DB's?
          Colm Divilly-Oracle
          There is no limit on the number of databases supported, can you share your url-mapping.xml file?
          • 2. Re: Does apex listener 2 EA have a maximum amount of DB's?
            985110
            Sure thing.

            Here it is.

            <?xml version="1.0" encoding="UTF-8"?>
            <pool-config xmlns="http://xmlns.oracle.com/apex/pool-config">
            <pool base-path="/apex_r12ebsuat2" name="ebsuat2" updated="2012-11-07T03:24:47.032Z"/>
            <pool base-path="/apex_r12ebsuat1" name="ebsuat1" updated="2013-01-14T00:50:04.831Z"/>
            <pool base-path="/apex_r12ebspoc" name="ebspoc" updated="2013-01-14T03:18:36.469Z"/>
            <pool base-path="/apex_r12ebsdev" name="ebsdev" updated="2013-01-14T04:42:41.519Z"/>
            <pool base-path="/apex_r12ebsptch" name="ebsptch" updated="2013-01-14T04:52:15.057Z"/>
            </pool-config>
            • 3. Re: Does apex listener 2 EA have a maximum amount of DB's?
              Colm Divilly-Oracle
              Thanks,
              I'll attempt to replicate the issue.

              Regards,
              Colm
              • 4. Re: Does apex listener 2 EA have a maximum amount of DB's?
                Colm Divilly-Oracle
                Can you do a dir/ls on your conf/ folder and upload the results.

                Thanks,
                Colm
                • 5. Re: Does apex listener 2 EA have a maximum amount of DB's?
                  985110
                  oracle@phxoradevas10:pfrd_dev> cd apex_config/
                  oracle@phxoradevas10:pfrd_dev> ls
                  apex apex_backup_working.tar apex_working_6112012.tar
                  oracle@phxoradevas10:pfrd_dev> cd apex
                  oracle@phxoradevas10:pfrd_dev> ls
                  bdb defaults.xml url-mapping.xml
                  conf defaults.xml.20121220 url-mapping.xml.20130114
                  oracle@phxoradevas10:pfrd_dev> cd conf/
                  oracle@phxoradevas10:pfrd_dev> ls -ltr
                  total 66
                  -rw-r--r-- 1 oracle dba 1623 Jan 14 15:21 apex.xml
                  -rw-r--r-- 1 oracle dba 1620 Jan 14 15:21 apex_al.xml
                  -rw-r--r-- 1 oracle dba 1628 Jan 14 15:21 apex_rt.xml
                  -rw-r--r-- 1 oracle dba 1608 Jan 14 15:21 ebsuat2.xml
                  -rw-r--r-- 1 oracle dba 1620 Jan 14 15:21 ebsuat2_al.xml
                  -rw-r--r-- 1 oracle dba 1628 Jan 14 15:21 ebsuat2_rt.xml
                  -rw-r--r-- 1 oracle dba 1608 Jan 14 15:21 ebsuat1.xml
                  -rw-r--r-- 1 oracle dba 1620 Jan 14 15:21 ebsuat1_al.xml
                  -rw-r--r-- 1 oracle dba 1628 Jan 14 15:21 ebsuat1_rt.xml
                  -rw-r--r-- 1 oracle dba 1607 Jan 14 15:21 ebspoc.xml
                  -rw-r--r-- 1 oracle dba 1620 Jan 14 15:21 ebspoc_al.xml
                  -rw-r--r-- 1 oracle dba 1628 Jan 14 15:21 ebspoc_rt.xml
                  -rw-r--r-- 1 oracle dba 1607 Jan 14 15:21 ebsdev.xml
                  -rw-r--r-- 1 oracle dba 1620 Jan 14 15:21 ebsdev_al.xml
                  -rw-r--r-- 1 oracle dba 1628 Jan 14 15:21 ebsdev_rt.xml
                  -rw-r--r-- 1 oracle dba 417 Jan 14 15:21 ebsptch.xml
                  -rw-r--r-- 1 oracle dba 256 Jan 14 15:21 ebsptch_al.xml
                  -rw-r--r-- 1 oracle dba 264 Jan 14 15:21 ebsptch_rt.xml