on my machine ,in the same time,only two oracle instances can run on it,why?

[hongjing_zhang]

on my machine ,in the same time,only two oracle instances can run on it,why?

[Christian Gebhardt]

Hi
we need more information about machine (memory), oracle-version (32 or 64 bit).

One possible reason:
If you use oracle 32 bit (even on a 64-bit HPUX) you can only adress 1,76GB memory with all instances, so if three instances uses more than 1,76GB than the third instance doesn't come up.
The solution in this case is
- upgrade to oracle 64 bit
- using memory windows
You'll find many postings in this forum by searching "memory window"

Chris

[T G Manikandan]

It must be like Oracle cannot resource more memory from the system.

HOw are the kernel parameters tuned and what is the amount of memory on the machine?
check that your shared memory kernel parameter is ok to take the load.

What are the errors you are facing?



Thanks