This discussion is archived
5 Replies Latest reply: Jan 21, 2013 4:07 PM by 985110 RSS

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

985110 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points