| Connect Tow Server Of The Same DataFile (4 Merged) [message #482261] |
Wed, 10 November 2010 11:49  |
raul33
Messages: 26
Registered: October 2008
Location: jordan
|
Junior Member |
|
|
Dear All
I have Tow Virtual Servers (Connect As Cluster) in the Same Computer The Files In the Drive C Different (of the Tow Servers) And Others Like (e,f,q) The Same Files
And There is Database of both Servers That Have Same Name Let say orcl and both database Have same Schema let Say sch
How I can Share The Data when i am insert to table. in the schema sch in the server A i can see Same Data That I have Inserted In the Schema sch in the server B
Can I Connect To The Same Datafile Of Both Servers
Thanks In Advance.
|
|
|
|
|
|
| Re: Connect Tow Server Of The Same DataFile [message #482278 is a reply to message #482265] |
Wed, 10 November 2010 15:19  |
John Watson
Messages: 8880
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
It is important to be precise in your use of words when discussing Oracle. Perhaps I can help by explaining some terminology?
An Oracle instance is memory structures and processes: it exists in your RAM and CPU. An Oracle database is files on disc. An Oracle server is a database opened by one (or more) instances. I think that what you are asking is whether two instances, on two machines, can open one database on a shared disc. The answer is "yes": this is called a RAC database.
However, a RAC is not something that a novice DBA can manage easily, and you probably do not want to do that.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
