OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » multiple instances

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

multiple instances [message #228235]

Mon, 02 April 2007 03:22

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

Report message to a moderator

Re: multiple instances [message #228238 is a reply to message #228235]

Mon, 02 April 2007 03:43

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

Report message to a moderator

Re: multiple instances [message #228240 is a reply to message #228235]

Mon, 02 April 2007 04:01

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

Report message to a moderator