This discussion is archived
3 Replies Latest reply: Oct 8, 2013 3:27 PM by J.A. RSS

Single Node RAC on 11.2.0.3

mail.madhankumar Newbie
Currently Being Moderated
Hi All,
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 created one query

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...
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...
  • 1. Re: Single Node RAC on 11.2.0.3
    LaserSoft Journeyer
    Currently Being Moderated
    Hi Friend

    Point 1 : Omtion utility will not come with Oracle Binaries. We have to download the separate patch for that.

    Patch is : p9004119_112010_<OS>
    example : p9004119_112010_LINUX

    To use Oracle RAC One Node Utilities, you must apply patch 9004119 to your 11.2.0.1 database home.

    NOTE: You must have Oracle RAC software home on any node in the cluster where you could relocate (using Omotion) the Oracle RAC One Node instance or where it could failover to if the original node fails. You will be asked for this candidate list of nodes during the initialization of Oracle RAC One Node.

    Solution is :

    *1. Download the above patch*
    *2. Download the this document - "ug_raconenode-2009.pdf" (Step By St*ep Document)

    Thanks
    LaserSoft
  • 2. Re: Single Node RAC on 11.2.0.3
    mail.madhankumar Newbie
    Currently Being Moderated
    Hi,
    My DB Version is 11.2.0.3 , how can i apply patch 11.2.0.1 version.

    i think i should implement FAN Technology.. to get HA without loss of users work.. if you aware of FAN implementation tell me..
  • 3. Re: Single Node RAC on 11.2.0.3
    J.A. Explorer
    Currently Being Moderated


    HI

     

    I have same situation, I have Rac One Node and I am not able to find the RAC One Node utilities patch.

     

    I know that patch 9004119 its for 11.2.0.1, but where is the patch for 11.2.0.3 ?

     

    Thank you in advance

     

    J.A.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points