Home » RDBMS Server » Server Administration » multiple instances
multiple instances [message #228235] Mon, 02 April 2007 03:22 Go to next message
karismapanda
Messages: 58
Registered: January 2007
Member
Hi,
Can anyone please explain what is the difference between multiple instances on the same database and multiple databases on the same machine.
Regards,
Karisma
Re: multiple instances [message #228238 is a reply to message #228235] Mon, 02 April 2007 03:43 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,


multiple instances on the same database
Database ----> orcl
instance        |
          |     |    |
        node1  node2 node3



multiple databases on the same machine.
Database------->db01
instance------->db01
ORACLE_HOME=$ORACLE_BASE/db_1

Database----->db02    
instance----->db02
ORACLE_HOME=$ORACLE_BASE/db_2


Multiple Oracle Software on Some Machine
Oracle 10g
Oracle 9i
Oracle 8i

Every Software located separate Oracle_home.



Regards
Taj
Re: multiple instances [message #228240 is a reply to message #228235] Mon, 02 April 2007 04:01 Go to previous messageGo to next message
karismapanda
Messages: 58
Registered: January 2007
Member

Hi,

Thanks for your response.

As u told.......
multiple instances on the same database

Database ----> orcl
instance |
| | |
node1 node2 node3

Is it possible to have multiple instances without RAC?

Can you please explain what are these nodes and how do they work.

Thanks,
karisma
Re: multiple instances [message #228243 is a reply to message #228240] Mon, 02 April 2007 04:08 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Is it possible to have multiple instances without RAC?
NO,


Can you please explain what are these nodes and how do they work.
http://download-uk.oracle.com/docs/cd/B14117_01/rac.101/b10765/intro.htm#sthref28


http://www.oracle.com/technology/products/database/clustering/index.html


Regards
Taj
Re: multiple instances [message #228252 is a reply to message #228235] Mon, 02 April 2007 04:39 Go to previous message
karismapanda
Messages: 58
Registered: January 2007
Member
Thanks a lot
Karisma
Previous Topic: problem in tablespace
Next Topic: EXPORT using QUERY
Goto Forum:
  


Current Time: Sat Dec 03 14:12:34 CST 2016

Total time taken to generate the page: 0.12551 seconds