Quote:
Originally Posted by
Marika
Advice?
At the danger of disappointing you: not yet. This looks like an
interesting problem (in other words: you did nothing obvious wrong but it still doesn't work, so some culprit must exist but we don't know what it is) and it is time for serious debugging,
First, i googled the problem too and everywhere shared memory was mentioned. Have you had a look at the shared memory segments? You can do that with the
ipcs command. See the man page for details. If a process crashes it happens that shared memory segments allocated by that process remain allocated but are in fact unusable. In such a case you need to manually remove them (otherwise your memory is made smaller effectively) or reboot, which also gets rid of them.
I also found
this link which seems to be quite similar to your problem. Did you increase shared memory in the way the guy suggested? I also found
this link effectively saying the same thing.
Another thing i remembered: Oracle has 2 settings: SGA_TARGET and SGA_MAXSIZE. You need to set both of them.
I hope this helps.
bakunin