3 Replies Latest reply on Aug 20, 2004 7:24 AM by Stefan Heckler

    Oracle database cluster

    Stefan Heckler Novice

      Hi,
      I would like to start with Oracle 9.2 (JBoss 3.2.1) and connect to a Oracle database cluster.

      How to configure JBoss to switch between 2 oracle instances, if one of them is shut down?

      Thanks
      Stefan

        • 1. Re: Oracle database cluster
          Stefan Schmidt Newbie

          Assuming you mean Oracle RAC (previously known as Parallel Server), you'll need to use the OCI JCDBC driver (aka "thick" JDBC driver) and have an appropriate tnsnames-configuration. When setup correctly, this makes the jdbc driver choose an available database server at connect-time.
          Oracle's so called "Transparant Application Failover" (TAF) in read/write-transactions doesn't come for free as it requires programmatic support in the application.
          Anyway, consult with your DBA about tnsames and check the Oracle documentation.

          • 2. Re: Oracle database cluster
            Stefan Heckler Novice

            Yes I mean RAC. If I understand You correctly, I just have to specify an other JDBC driver in the oracle-ds.xml? And then the failover logig comes from the driver?
            This would be fine for me!

            • 3. Re: Oracle database cluster
              Stefan Heckler Novice

               

              "schmidts" wrote:
              Assuming you mean Oracle RAC (previously known as Parallel Server), you'll need to use the OCI JCDBC driver (aka "thick" JDBC driver) and have an appropriate tnsnames-configuration. When setup correctly, this makes the jdbc driver choose an available database server at connect-time.
              Oracle's so called "Transparant Application Failover" (TAF) in read/write-transactions doesn't come for free as it requires programmatic support in the application.
              Anyway, consult with your DBA about tnsames and check the Oracle documentation.


              By now I would like to use "Transparant Application Failover" (TAF)
              What programmatic support do You mean?

              Im am using the following connection URL <connection-url>jdbc:oracle:oci:@CMD-DBR1</connection-url>
              with the following TNSNAMES Entry:

              RWCO_DBS =
              (DESCRIPTION =
              (FAILOVER = ON)
              (LOAD_BALANCE = ON)
              (ADDRESS_LIST =
              (ADDRESS = (PROTOCOL = TCP)(HOST = rwco_dbs1)(PORT = 1521))
              (ADDRESS = (PROTOCOL = TCP)(HOST = rwco_dbs2)(PORT = 1521))
              )
              (CONNECT_DATA =
              (SERVICE_NAME = eedb)
              (FAILOVER_MODE =
              (TYPE = SELECT)
              (METHOD = PRECONNECT)
              (RETRIES = 20)
              (DELAY = 3)
              )
              )
              )

              and JBoss (3.2.5) uses direct JDBC calls (ServerLogon Modul, SecurityProxy etc.), CMP- and BMP-Beans to access the database.