This discussion is archived
2 Replies Latest reply: Nov 15, 2012 8:51 AM by jgarry RSS

Single Instance v/s RAC database installation.

ocpdev Newbie
Currently Being Moderated
Hi all,
Pl guide me which type of above Installation suites me and why?
We are migrating from Oracle 8i application to 11gr2. We have one Ibm Server with client PCs'.
Thanks in Advance!
  • 1. Re: Single Instance v/s RAC database installation.
    973259 Newbie
    Currently Being Moderated
    Hi ,

    This depends on the requirement of yours.

    If, your application would require the High availability, then it would be better to go for RAC. You can refer to the below doc for advantages of using RAC -

    http://www.oracle.com/technetwork/database/clustering/overview/twp-rac11gr2-134105.pdf

    If, your application would suffice single instance , then please go for single instance database and do not waste the resources.

    Upgrade Path -

    1) From 8i (>8.1.7.4) to 10g(>= 10.2.0.2)
    2) From 10.2.0.2 to 11.2.0.3
    3) Then apply latest PSU 4.

    Many Thanks,
    RaaM's.

    Edited by: raams on Nov 15, 2012 7:48 PM
  • 2. Re: Single Instance v/s RAC database installation.
    jgarry Guru
    Currently Being Moderated
    If your application is poorly written (from a modern perspective, this is implicit in that RAC white paper), RAC will make it worse. I would look carefully at something that has been around that long: are there many hints? Is it even using the cost based optimizer? Is it designed relationally for performance? Who wrote the app? With which tools?

    There are white papers floating about that tell you what to expect from the optimizer when upgrading from 9 to 10 and when upgrading from 10 to 11, you might look at those and take another look at what your application expects.

    Yes, your requirements should control the decision, but your existing application needs to have a say so you can know how to get there. It's entirely possible a jump from 8 to 11 will let the app will work better simply from more modern hardware, but if it is actively counter to basic relational assumptions, it could go haywire.

Legend

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