Running Multiple Oracle Instances

[Edward Wynn]

Hi,

I have created 2 instances under Oracle 8.1.7 HP-UX 11 and am trying to get them both started. I can start either database on its own without problems, but as soon as I try to start the second database (after changing oracle_sid I start svrmgr and do connect internal then startup) I get the following error:

SVRMGR> startup
ORA-03113: end-of-file on communication channel

As I can start this database if the other one is not running I think that there must be something worng with my Unix environment - has anyone any ideas.

Thanks in advance, Eddie
PS - I even tried using dbstart - output is attached FYI.

[Alexander M. Ermes]

Hi there.
You should check your kernel parameters.
Your SHMMAX should be larger than 1 GB.
Pls check also for HP patch PHSS_22478.
Try to get the installation guide from Oracle TechNet or Metalink. The Installation Guide there is for Oarcle 8.1.5 ithink, but the parameters in this will be ok.
Rgds
Alexander M. Ermes

[CHRIS ANORUO]

As you are running 8.1.7 on 64-bit HP-UX 11 you may utilise HP ?Memory
Windows? software to create multiple SGAs, each of which can be upto 1.75GB
in size.
Check Large SGA support for HP, Memory Windows, for a more details.
HP-UX patches and an Oracle 8.1.7 patch are required. Note that the Oracle
patch will NOT be backported to earlier releases.
Have a thorough look at this attached doc.

[John Palmer]

Hi,

I suspect that this is related to memory.

- What are the SGA sizes of your two databases?
- Is shmmax configured large enough to cope with both SGA's?
- Do you have sufficient swap space to cope with both SGA's etc.

Hope this helps.

John

[Joseph C. Denman]

I have recieved end-of-communication channel myself many times. Most of the time it is when I have restored from a backup and the permissions on the oracle datafiles are incorrect. Check the ownership and permissions of the datafiles.

Joe...

[Edward Wynn]

Thanks for all the suggestions, the problem is now solved - I was advised to increase SEMMNS to 500 (instead of Oracle's recommended value of 200) and this solved the problem.


Cheers, Eddie