| confusion regarding instance [message #64551] |
Mon, 07 February 2005 21:14  |
Sanjeev Suri
Messages: 11
Registered: September 2004
|
Junior Member |
|
|
I am just a novice in oracle, I want to know the details regarding an instance.
Can a database can have multiple instances or an instance can have multiple databases.
Can a single oracle server has multiple databases and the instance of one database can access the other database.
Thanks
|
|
|
|
| Re: confusion regarding instance [message #64552 is a reply to message #64551] |
Mon, 07 February 2005 23:05  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
There is a 1:1 relationship between an instance and a database. The only exception is when you use RAC (Real Application Clusters), an Oracle Database Option. With RAC you can have multiple instances on different nodes of a clustered system that use the same database (N:1).
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
