Details

    • Type: Bug Bug
    • Status: Open
    • Priority: 2 Major 2 Major
    • Resolution: Unresolved
    • Affects Version/s: 1.6.6
    • Fix Version/s: 3.0
    • Component/s: Core
    • Labels:
      None
    • Terracotta Target:
      Pending

      Description

      We moved from Oracle 10g non-RAC to Oracle 11g RAC with multi-pools and loadbalancing on weblogic server.

      when we are brining up the app quartz is locking the db tables and weblogic going to STATE_ADMIN instead of going to RUNNING mode.

      Application wont come up.

      this worked fine on 10g .

        Issue Links

          Activity

          Hide
          James House added a comment -

          RAC has serious limitations when it comes to transactions and locking. For instance all work does as part of a single XA transaction has to be done on the same RAC node. RAC is really a joke in a lot of ways - first clue is that they have to give the product a name that tries to convince you it is "real application clustering" when it has such strong limitations.

          These limitations lead to people having to be rather creative in how they configure datasources in clustered WLS (for all applications, not just Quartz) because it is rather likely that two connections obtained from a datasource during a tx will NOT be to the same RAC node.

          That all said, there are a number of folks using Quartz 1.6.x and 1.8.x with Oracle RAC - there is not a fundamental problem with Quartz in this respect, just a matter of configuring Quartz with datasources that a sure to make proper/consistent use of RAC nodes.

          This old mail thread regarding RAC and Quartz may be of interest:

          http://markmail.org/message/72lqjw2qnb6re2ve

          also this doc has interesting info:

          http://download.oracle.com/docs/cd/E13222_01/wls/docs90/jdbc_admin/oracle_rac.html#1080524

          also googling for weblogic and oracle rac find all sorts of stuff.

          Show
          James House added a comment - RAC has serious limitations when it comes to transactions and locking. For instance all work does as part of a single XA transaction has to be done on the same RAC node. RAC is really a joke in a lot of ways - first clue is that they have to give the product a name that tries to convince you it is "real application clustering" when it has such strong limitations. These limitations lead to people having to be rather creative in how they configure datasources in clustered WLS (for all applications, not just Quartz) because it is rather likely that two connections obtained from a datasource during a tx will NOT be to the same RAC node. That all said, there are a number of folks using Quartz 1.6.x and 1.8.x with Oracle RAC - there is not a fundamental problem with Quartz in this respect, just a matter of configuring Quartz with datasources that a sure to make proper/consistent use of RAC nodes. This old mail thread regarding RAC and Quartz may be of interest: http://markmail.org/message/72lqjw2qnb6re2ve also this doc has interesting info: http://download.oracle.com/docs/cd/E13222_01/wls/docs90/jdbc_admin/oracle_rac.html#1080524 also googling for weblogic and oracle rac find all sorts of stuff.
          Hide
          James House added a comment -

          Document.

          Show
          James House added a comment - Document.
          Hide
          James House added a comment - - edited

          Made a short docs note for now, will try to improve when information can get better gathered and organized (it's hard to prescribe a particular setup when there are several ways to do it - some working, some not).

          Show
          James House added a comment - - edited Made a short docs note for now, will try to improve when information can get better gathered and organized (it's hard to prescribe a particular setup when there are several ways to do it - some working, some not).

            People

            • Assignee:
              James House
              Reporter:
              Anil Kumar
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: