| anand |
Posted: Apr 28, 2008 07:17:15 AM |
Total Post: 8
Joined: Apr, 2008
|
can database hav multiple instance?? if so how to access particular instance?? i read in documnt only in RAC v can hav multipl insatnce for t database with seperat memory. N one more think can v hav two listeners for t database?
M confused n m new to tis dba plz help me.... Thank u!! |
|
|
 Murtuja |
| Posted: Apr 28, 2008 07:20:11 AM |  |
|
Total Post: 857
Joined: Jan, 2006
|
Hi,
First of all you have to write your question properly.Chat language is
not allowed in forums.
|
|
|
|
|
| anand |
| Posted: Apr 28, 2008 07:23:37 AM | |
|
Total Post: 8
Joined: Apr, 2008
|
SORRY!!!
can database have multiple instance?? if so how to access particular instance?? i read in documnt only in RAC we can have multiple insatnce for the database with seperate sga. and one more think can we have two listeners for the database?
I aM confused and i am new to this dba please help me.... Thank u!!
|
|
|
|
|
| Murtuja |
| Posted: Apr 28, 2008 07:27:14 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
In RAC Environment,You can have multiple Instance running on one database.And Eaxh instance have their own listener so you can have multiple listener.
RAC in simple terms...It's Oracle Database running on multiple servers and each server have one instance and listener.
|
|
|
|
|
| anand |
| Posted: Apr 28, 2008 07:34:27 AM | |
|
Total Post: 8
Joined: Apr, 2008
|
Thanks a lot!! but still i have doubt so only in RAC we can hav multi instance??
|
|
|
|
|
| Murtuja |
| Posted: Apr 28, 2008 07:45:41 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Yes,You are correct.You can't have multiple instance without RAC.
|
|
|
|
|
| Napster |
| Posted: Apr 28, 2008 08:08:36 AM | |
|
Total Post: 29
Joined: Apr, 2008
|
Hi Anand,
This link will tell you a lot about RAC
http://www.oracle.com/technology/products/database/clustering/index.html
This site gives you a lot of info since you said your new to Oracle
Regards
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: Apr 28, 2008 11:35:20 PM | |
|
Total Post: 135
Joined: Apr, 2008
|
Without RAC you can have multiple instance in a single server !
you have to set unique SID for each oracle instance and when you connect that instance you need to use the SID
and again you can install different version of oracle (say 9i & 10g) in a single matchine......... :(
Regards
http://sharear.blogspot.com/
|
|
|
|
|
| Murtuja |
| Posted: Apr 29, 2008 01:50:08 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi Hasan,
We can have Multiple Database running on single server.But for each database we can have maximum one instance only.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
