|
|
Re: Multiple database with multiple instance on same machine [message #499778 is a reply to message #499774] |
Wed, 16 March 2011 03:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Its_me_ved
Messages: 979 Registered: October 2009 Location: India
|
Senior Member |
|
|
Thanks for your quick reply.
Did you mean that there can be multiple database version running with multiple instance version on a single
server provided there is enough resources? Is there any documentation with any example to read for this scenario?
Can there be any impact for having multiple database version running with multiple instance version on same machine?
Regards
Ved
|
|
|
|
|
|
|
|
|
|
Re: Multiple database with multiple instance on same machine [message #499966 is a reply to message #499965] |
Thu, 17 March 2011 00:35 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Its_me_ved
Messages: 979 Registered: October 2009 Location: India
|
Senior Member |
|
|
Thanks for the reply. Two or more instance same version.When you said same version what does this mean? Does this mean same database version?
You asked "But why do you want to create 2 or more instances for the same database on the same server?"
One of my friend asked me about this and asked for any link to prove it. No idea when its required for two database version.
May be so that if something happens to the first instance then one have to take it down the other instance keep running.
Quote:
I found a link where it is written,
"In Oracle, unless you are using Real Application Clusters, you have one instance per database. You can have multiple databases per a single Oracle home, hence, multiple instances per single Oracle home."
Source: http://dbaforums.org/oracle/index.php?showtopic=1609&mode=threaded&pid=6519
I will ask in which case it's required. Any documentation or link to follow.
I am a newbie in database server adminstation area. Your suggesion would help !!
Regards
Ved
[Updated on: Thu, 17 March 2011 01:19] Report message to a moderator
|
|
|
Re: Multiple database with multiple instance on same machine [message #499986 is a reply to message #499966] |
Thu, 17 March 2011 02:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Does this mean same database version?
Same Oracle binary version.
Your quote is quite clear:
In Oracle [...] you have one instance per database
If you are in RAC you can have 2 or more instances per database
This does not mean the instances are on the same server.
You can have multiple databases per a single Oracle home
You can have multiple instances per single Oracle home
This does not mean the instances are for the same database.
Regards
Michel
[Updated on: Thu, 17 March 2011 02:12] Report message to a moderator
|
|
|
|
|
Re: Multiple database with multiple instance on same machine [message #500004 is a reply to message #500001] |
Thu, 17 March 2011 03:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Its_me_ved
Messages: 979 Registered: October 2009 Location: India
|
Senior Member |
|
|
Quote:
You can have multiple databases per a single Oracle home
You can have multiple instances per single Oracle home
Can you please give me an example? Or any link where I can find this? I might mixed up things here!
Many thanks for the help! I think I am a bit confused with my understanding here.
What I understood is.. we can have different database in same server as below:
Oracle database 10.2.0.1--- two or more instance same version (does not necessarily on the same server)
Oracle database 11.2.0.1-- two or more instance same version
(does not necessarily on the same server)
Is it wrong? Any link that I need to follow? It would of great help!
Regards
Ved
[Updated on: Thu, 17 March 2011 03:46] Report message to a moderator
|
|
|
Re: Multiple database with multiple instance on same machine [message #500006 is a reply to message #500004] |
Thu, 17 March 2011 03:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Oracle database 10.2.0.1--- two or more instance same version (does not necessarily on the same server)
Oracle database 11.2.0.1-- two or more instance same version
(does not necessarily on the same server)
Is it wrong? Any link that I need to follow?
It is correct.
Quote:Any link that I need to follow?
Oracle documentation, Database Concepts and RAC book (which I don't recall the name you can easily find it in dicomentation book list).
Regards
Michel
|
|
|