Single Node RAC on 11.2.0.3

[mail.madhankumar]

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...

[Tim...]

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...

[mail.madhankumar]

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..

[Tim...]

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...