6 Replies Latest reply: Mar 22, 2013 6:33 PM by user8929517 RSS

    PCP with RAC simulation of node affinity in EBS 12.0.6

    user8929517
      Hi ,
      We are on 12.0.6 with sindle node database with PCP configured.
      Migrating to 2 node RAC with 12.0.6 with PCP.

      Architecture is
      3 node application tier
      2 node RAC DB.

      all middlet tier services are enabled on the all 3 app nodes. concurrent managers are distrubuted across the 3 application nodes.

      Is any way that we can cofigure the managers running on a particular node should always connect to specific RAC instance.
      In 12.1.1 it is RAC affinity but in 12.0.6 how do we achvie it.

      Please advice. Your help is highlt appreciate.

      Thanks
      Jana.
        • 1. Re: PCP with RAC simulation of node affinity in EBS 12.0.6
          Srini Chavali-Oracle
          AFAIK, RAC affinity is not available in releases before 12.1.1

          How To Run a Concurrent Program Against a Specific RAC Instance with PCP/RAC Setup? [ID 1129203.1]

          However, a simulated workaround is available

          Method Of Always Running A Specific Concurrent Program On One Particular Node [ID 1070621.1]

          HTH
          Srini
          • 2. Re: PCP with RAC simulation of node affinity in EBS 12.0.6
            Hussein Sawwan-Oracle
            all middlet tier services are enabled on the all 3 app nodes. concurrent managers are distrubuted across the 3 application nodes.
            Do you have the same concurrent manager configured on every application tier node?
            Is any way that we can cofigure the managers running on a particular node should always connect to specific RAC instance.
            In 12.1.1 it is RAC affinity but in 12.0.6 how do we achvie it.

            Please advice. Your help is highlt appreciate.
            It is available in 12.1.1 and above.

            Why do you want to configure the manager to run on a particular application node and connect to specific RAC instance? How would you handle the situation when this RAC instance goes down?

            Thanks,
            Hussein
            • 3. Re: PCP with RAC simulation of node affinity in EBS 12.0.6
              user8929517
              Hi Hussein,
              The reason we would like to configure manager level is to distrubute the load with other activties. Even we heard that module wise configuration is possible but not sure how to configure it.

              Managers are distrubuted , same managers are not running on multiple nodes.

              Sorry for the delayed response. I was on weekly off.

              Thanks
              Jana
              • 4. Re: PCP with RAC simulation of node affinity in EBS 12.0.6
                user8929517
                also as mentioned by Srini, even Oracle as suggested the same method when I raise a SR,

                From note: 1070621.1

                What is being requested is called Request Instance Affinity or Node Affinity. This feature is available on EBS Release 12.1.1; see Note 566521.1 "Oracle Application Object Library Release Notes, Release 12.1.1" and Note 1129203.1 "How to run a concurrent program against a specific RAC instance with PCP/RAC setup?"

                This feature is not available on earlier releases of EBS, however. As per a Concurrent Processing Developer the same effects can be simulated:

                "If configured for RAC and the manager(s) connect to a specific instance ONLY (meaning not using _balance), then setup a manager to run on a particular node and connecting to a particular instance. That means, make certain the program runs on that manager only by inclusion / exclusion rules."


                Thanks
                Jana
                • 5. Re: PCP with RAC simulation of node affinity in EBS 12.0.6
                  Hussein Sawwan-Oracle
                  Hi Jana,
                  user8929517 wrote:
                  Hi Hussein,
                  The reason we would like to configure manager level is to distrubute the load with other activties. Even we heard that module wise configuration is possible but not sure how to configure it.

                  Managers are distrubuted , same managers are not running on multiple nodes.

                  Sorry for the delayed response. I was on weekly off.

                  Thanks
                  Jana
                  PCP and RAC should be able to distribute the load and you do not need to specify the instance to achieve that.

                  Can you please elaborate more on your existing PCP setup and what you are planning to achieve (setup/configuration wise) by using specific instance(s)?

                  Thanks,
                  Hussein
                  • 6. Re: PCP with RAC simulation of node affinity in EBS 12.0.6
                    user8929517
                    To Simply my question,
                    node affinity simulation on 12.0.6 on RAC, how to achieve it or what are the configurations that we need to make.
                    As mentioned earlier, This feature is not available on earlier releases of EBS, however. As per a Concurrent Processing Developer the same effects can be simulated:


                    Thanks
                    Jana