Single Node RAC on 11.2.0.3

Questions relating to Oracle Real Application Clusters (RAC) and Clusterware.

Moderator: Tim...

Single Node RAC on 11.2.0.3

Postby mail.madhankumar » Wed Dec 05, 2012 1:59 pm

Hi Tim,
i have implemented Rac One node with two machine(dbtest01,dbtest02) in 11.2.0.3 Redhat 5.3 one for online another one for offline. i have created TAF also.

dbtest01 is online and create one query
Code: Select all
DECLARE
  i number(36):=1;
 begin
      while(i<10000000)
  loop
     dbms_output.put_line(i);
    i:=i+1;
  end loop;
  end;

i executed above query for test and i made relocate database using srvctl utility to dbtest02 machine.

session is relocated successfully with new session id...
above query getting stop in 25000 itself.
i want to make it continue that process... that is the high availability rite..
also i tried to find Omotion utility in all the path.. couldn't find it... where will it be..
i want to relocate all the session without losing work.

from application i am getting disconnect after relocation.. application server need to restart to get work again...
mail.madhankumar
Senior Member
 
Posts: 87
Joined: Tue May 15, 2012 2:47 pm

Re: Single Node RAC on 11.2.0.3

Postby Tim... » Wed Dec 05, 2012 6:27 pm

Hi.

RAC one-node and omotion do not do anything magic for you. If you want your application to see the switch as seemless, your application must be written properly to receive and interprest FAN messages and take the appropriate action, like rerun the failed statements.

The test you did, just running a bit of PL/SQL, will never failover as you require. Instead, the application sending it to the server will need to recognize the failure (using FAN messages) and resend the task to the failover instance, making the user think it never failed (except maybe it seems like an extra-long elapsed time).

As for the location of omotion, I've never used it so I can't rightly say. I guess you should do a search on the filesystem for it.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17950
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Single Node RAC on 11.2.0.3

Postby mail.madhankumar » Wed Dec 05, 2012 6:57 pm

Hi Tim,
Thanks for reply.. can you help to implement FAN Method ..
i have implemented existing configuration with jboss server... it's getting down when i relocation db server.. i need to restart application server to bring it again..
Please provide documents to implement..
mail.madhankumar
Senior Member
 
Posts: 87
Joined: Tue May 15, 2012 2:47 pm

Re: Single Node RAC on 11.2.0.3

Postby Tim... » Wed Dec 05, 2012 7:11 pm

Hi.

This is a coding issue, not a DBA issue. The application needs to be written to understand FAN. I guess you need to get your developers to check out the Oracle documentation on this feature.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17950
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle RAC and Clusterware

Who is online

Users browsing this forum: No registered users and 1 guest