2 Replies Latest reply: Mar 22, 2013 10:39 PM by user12288492 RSS

    RAC with Dbnode1 and Dbnode2

    RanjeetSohale
      I have RAC with Dbnode1 and Dbnode2 and my application submit job in Dbnode1 .job is running and Dbnode1 is down .
      It possible running Job automatically move on the Dbnode2 .

      1 App1 and App2 node /DBNode2 and DBNode1 node are running.
      2 Application batch submit successfully from Appnod1/DBnode1 and DBNode1 goes down in middle of the batch.
      3 Pending Job will not switch automatically on DBnode2.
        • 1. Re: RAC with Dbnode1 and Dbnode2
          Levi Pereira
          995587 wrote:
          I have RAC with Dbnode1 and Dbnode2 and my application submit job in Dbnode1 .job is running and Dbnode1 is down .
          It possible running Job automatically move on the Dbnode2 .

          1 App1 and App2 node /DBNode2 and DBNode1 node are running.
          2 Application batch submit successfully from Appnod1/DBnode1 and DBNode1 goes down in middle of the batch.
          3 Pending Job will not switch automatically on DBnode2.
          Yes... It complete possible, but your application need support Oracle RAC.



          Client Failover Best Practices for Highly Available Oracle Databases: Oracle Database 11g Release 2
          http://www.oracle.com/technetwork/database/features/availability/maa-wp-11gr2-client-failover-173305.pdf

          Application Failover with Oracle Database 11g
          http://www.oracle.com/technetwork/database/app-failover-oracle-database-11g-173323.pdf

          How to develop it:
          Transparent Application Failover in OCI
          http://docs.oracle.com/cd/E14072_01/appdev.112/e10646.pdf
          • 2. Re: RAC with Dbnode1 and Dbnode2
            user12288492
            Yes, iti is possible. All you need to do is to
            - create a service with preferred node as Dbnode1 and available node as Dbnode2.
            - Create a job class JC which maps to above service
            - Assign your job to the job class (JC) created above

            Now, when DBnode1 is down,
            - service fails over to Dbnode2
            - All the jobs belonging to the job class JC failover to Dbnode2 along with the service

            Hope it helps

            Regards
            Anju Garg