Skip to Main Content
  • Questions

  • Can we have multiple versions of Oracle database instance in 11gR2 RAC

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Ramaswamy.

Asked: May 07, 2012 - 3:52 pm UTC

Last updated: April 04, 2019 - 4:16 am UTC

Version: 11.2.0.3

Viewed 1000+ times

You Asked

We would like to install 2 11.2 database and one 10.2 database in 11GR2 RAC.
Is this possible?

• Can we run all 3 instances on a Single RAC 11.2 Cluster? Will this complicate backup/recovery?

Thanks

and Tom said...

You can - however - you probably should not.

One of the reasons you run RAC is to provide for higher availability. Nothing can kill that as fast as having many instances on a host.

You'll need to use CPU instance caging to restrict each instance to some portion of the machine - so as to avoid having one instance take over the machine. You'll have to be careful with IO as you don't have an IO resource manager (unless you are using exadata/zfs/pillar storage).

It won't complicate backup and recovery - each database will be independent - it'll just complicate day to day life.

Rating

  (3 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Multiple versions

Greg, May 08, 2012 - 4:58 pm UTC

Tom,
I think that Ramaswamy meant that question as running 1 instance per machine, but having different versions of the software accessing one database. Such as in the 11g RAC Admin guide 1-9:

"If you are running Oracle RAC 10g and Oracle RAC 11g in the same cluster, you must be running Oracle Clusterware 11g (only)."

But then, sometimes I need to take what I think with a grain of salt...
Tom Kyte
May 10, 2012 - 2:51 am UTC

I disagree with you on that one.

We would like to install 2 11.2 database and one 10.2 database in 11GR2 RAC.
Is this possible?

three databases = three instances.

You'll have the 11g clusterware - but three instances of Oracle for three databases.

Which is the least bad option?

Daniel Ramos, April 03, 2019 - 1:20 pm UTC

Hi.
We are migrating our rac infrastructure from 12.1 to 18C.
Whe have an old application that we have to maintain for some time.
This application can't connect to 18 ( Bug 26092744 - ORA-03137: MALFORMED TTC PACKET FROM CLIENT REJECTED).
We only have license for the 2 nodes rac.
This isn't a hi level availavility aplication nor does it have a grear cost on cpu or io usage.

What should we do?
Can we install an oracle 12.1 in other user in one rac node?
Can we do an 12.1 rac installation?

Which is the least bad option?

Thanks for your time.
Connor McDonald
April 04, 2019 - 4:16 am UTC

You say

This isn't a hi level availavility aplication nor does it have a grear cost on cpu or io usage.


then I would just install a small single instance (non-RAC) 12.1 database on the same hardware (hence no license implications) and just use that. No need for RAC if you don't have stringent availability needs for that application


Daniel Ramos, April 04, 2019 - 1:43 pm UTC

I'll do it.

thanks!!!
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.