Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question.

Asked: November 22, 2016 - 11:58 am UTC

Last updated: February 06, 2019 - 9:39 am UTC

Version: 11g

Viewed 10K+ times! This question is

You Asked

Hi,

Can we create a Multiple Instances on Single Database,If we Can Create Will we Face Any issues with that multiple instance architecture?

Thank you.

and Chris said...

You've just described Oracle Real Application Clusters (RAC) ;)

This enables you to have multiple instances point at a single database. Installing and configuring it is very different to single instance.

If you want to know more, check out the following links:

http://docs.oracle.com/database/121/TDPRC/toc.htm
http://www.oracle.com/technetwork/database/options/clustering/rac-wp-12c-1896129.pdf
http://www.oracle.com/technetwork/database/options/clustering/rac-ds-12c-1898881.pdf

Rating

  (1 rating)

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

Comments

A reader, February 06, 2019 - 1:46 am UTC

My doubt seems silly but i would like to know can we create multiple instances pointing to a single database on single machine?

Chris Saxon
February 06, 2019 - 9:39 am UTC

You mean can you create many RAC instances on one server that use the same database?

As the docs say:

You cannot run more than one instance of the same database on the same node.

https://docs.oracle.com/en/database/oracle/oracle-database/18/racad/administering-database-instances-and-cluster-databases.html#GUID-3A46DC3A-6D07-402D-BC09-CD33E6E8484B

So no, this isn't something you should do.
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.