This discussion is archived
3 Replies Latest reply: Oct 9, 2013 12:37 AM by Svetoslav Gyurov RSS

Rac One Node on Rac Servers

J.A. Explorer
Currently Being Moderated

Hi Xperts

 

We have this environment:
2 Rac Nodes 11.2.0.3 Enterprise on Oracle Linux 5.9 . 

 

We have one production Database on this Rac and the users ask to create two single instance on each node, something like this:
Node1 -> Rac Prod1,  Single Test
Node2-> Rac Prod2,  Single Dev

 

I want to create Rac One node for those Database (Dev, Test) and create New Diskgroups for ech database.

 

Can I install a Rac One node on those Server  with DBCA?
Do I nedd to Install new Database Software ?
Does the installed Rac have some affectation ?

 

I just want to be sure about this procedure, before to do anything.

 

Thank you

 

J.A.

  • 1. Re: Rac One Node on Rac Servers
    Svetoslav Gyurov Explorer
    Currently Being Moderated

    Hi J.A.

     

    Yes you can! However you need to install Grid Infrastructure (GI) in cluster on both nodes, then install database software. Either during software installation or after that, DBCA would allow you to create 1) Single instance, 2) RAC database, 3) RAC One Node database. Keep in mind that RAC One Node is an option (additional license) to the Enterprise Edition of Oracle Database.

     

    I've talked on that topic at the Bulgarian Oracle Users Group at 2011, here is the link to the presentation, you may find it useful. I might upload the videos as well if you need to have something like a proof of concept of just for your own:

    http://sve.to/download/1112/

     

    Also I would go with one disk group for both databases, as long as they share the same physical disks I don't see the point of doing that ? Having one diskgroup would allow you to utilize better you disk/space resources.

     

    The procedure would be:

    1. Install GI in cluster.

    2. Install software libraries.

    3. Patch up to 11.2.0.4.

    4. Create RAC One Node database using either command line or using Custom Template of DBCA.

     

    At the end of the day, if you have standard edition license you can still install GI in cluster and create single instance databases on each server. The downside of doing that is that you need to manually failover the database to remaining node in case of disaster.

     

    Regards,

    Sve

  • 2. Re: Rac One Node on Rac Servers
    J.A. Explorer
    Currently Being Moderated

    Thank you for the information, we will check about the licence

     

    Today I installed a Test enviroment, like the production enviroment: 2 Rac Nodes 11.2.0.3  with one database

     

    Then I installed one database Rac One Node with DBCA, but know I not able to find the utilities for Omotion. I find that for 11.2.0.1 there is a patch, but I am not able to find the patch for 11.2.0.3

     

    do you know the number of the patch ?

     

    Thank you

     

    J.A.

     


  • 3. Re: Rac One Node on Rac Servers
    Svetoslav Gyurov Explorer
    Currently Being Moderated

    Hi,

     

    Well, there is not utility omotion, they just call the technology for planned failover like that. To command RAC One Node you need to use srvctl utility. Documentation is good starting point:

    http://docs.oracle.com/cd/E11882_01/rac.112/e16795/onenode.htm

     

    Patches could be obtained from MOS (My Oracle Support), here are the numbers:

    Patch 10404530: 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER

    Patch 13390677: 11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER

     

    Sve

Legend

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