Multiple instances on one box gives errors [message #52447] |
Mon, 22 July 2002 22:10 |
Stephen Marwick
Messages: 2 Registered: July 2002
|
Junior Member |
|
|
Hi all,
this is probably a simple (common?) problem.
I'm trying to run two Oracle instances on the one Unix machine. My problem is that I can only run one of them at any one time. If I try to start one of them while the other is running Oracle returns the following:
ora-24323: Value not allowed
ora-03113: end-of-file on communication channel
This occurs at instance startup (ie startup nomount).
I'm using two separate initSID.ora files, and both work fine on their own. I'm starting each instance in a separate window with the same environment, except for the ORACLE_SID environment variable which is set to the appropriate database name.
The machine has about 1Gb RAM, plus 1.5Gb swap, so according to the installation manual I should have enough resources to run. (They're only small developmental databases.)
I'm obviously doing something wrong, but I can't work out what.
Also, I do actually need two separate instances/databases, not just separate schemas.
Any suggestions would be most appreciated.
Thanks,
Stephen.
|
|
|
|