2 Replies Latest reply on Aug 8, 2011 11:04 AM by teedub

    APEX Listener and RAC

    852592
      Is APEX Listener RAC-capable? Neither the Installation Guide nor the APEX RAC white paper provides information. Is there some experience installing APEX Listener within a Oracle 10.2 RAC environment?
      What would be the advantage / disadvantage?
        • 1. Re: APEX Listener and RAC
          Udo
          Hello,

          as far as I know, you can use the thin driver to connect to RAC. If I don't remember this wrong, you should be able to configure the URL like this:
          jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
          (ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))
          (ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521))
          (CONNECT_DATA=(SERVICE_NAME=service)))
          What would you like to compare the RAC-Connection used by the APEX Listener with to outline advantages/disadvantages?
          I think, the connection is not much different from the one you'd get when configuring a OHS that way. The EPG variant would be integrated in the RAC, but for fault tolerance you'd need some frontend server for node-failover anyway...

          -Udo
          • 2. Re: APEX Listener and RAC
            teedub
            This does work:

            jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=exadr01-vip.ccc.com.au)(PORT=1532))(ADDRESS=(PROTOCOL=TCP)(HOST=exadr02-vip.ccc.com.au)(PORT=1532))(CONNECT_DATA=(SERVICE_NAME=comntst.ccc.com.au)))

            comments by teedub on Aug 8, 2011 8:02 PM