2 INSTANCES IN ONE M/C?

[ggnanaraj]

Hi

Recently I was asked in an interview, if u can have 2 instances running in one m/c at the same time?

Can u answer, please?

Thanks

ggnanaraj

[marist89]

What is an m/c?

[sreddy]

What is the m/c ? Machine ? you mean Box ?

If so, what OS ? Yes! you can have as many as you want if you have resources on the box. I have 8 instance running on Solaris 2.6 box.

[ggnanaraj]

Thanks for the reply.

What I now infer is that it is possible to have more than 1 instance running on the same machine(m/c) at the same time. So each instance can have its own database(s) also running? right?

What about NT os?

Thanks.

[sreddy]

instance/database------> Normal configuration
instances/database----> OPS(Oracle Parrallel Server)

[nabaig]

Sure, Even in NT if you enough memory, you can support more than one instances.

Nizar

[lnr]

U can always no of instances u want ,i had discussion reg this recently

Thanks
lnr

[sonaliak]

I have a basic question...
Here is the text from tnsnames.ora file.

ORCL1.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = NMP)(SERVER = tree)
(PIPE = ORAPIPE))
(CONNECT_DATA = (SID = TEST))
)

orcl2.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = NMP)(SERVER = tree)
(PIPE = ORAPIPE))
(CONNECT_DATA = (SID = SUP))
)

As you can see these 2, orcl1 and orcl2 are on the same server.
are SUP and TEST the instance names ?
are orcl1 and orcl2 different databases on same server ?

Thanks
Sonali

[sreddy]

orc1, orc2 are the service names(connection strings) to connect to databases SUP and TEST. You can have 10 services names starting from orc01 to orc10...pointing to SUP/TEST.

You are confused with service names and database names. tnsnames.ora deals with service names.

[Felix]

Hi,

You can have any number of instances, for memory resource, you can create one home and create multiple instance in that home, The name will be different. And for accessing the instance, use the sid name.

With regards