General
cancel
Showing results for 
Search instead for 
Did you mean: 

Running Multiple Oracle Instances

Edward Wynn
Advisor

Running Multiple Oracle Instances

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.
5 REPLIES
Alexander M. Ermes
Honored Contributor

Re: Running Multiple Oracle Instances

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
CHRIS ANORUO
Honored Contributor

Re: Running Multiple Oracle Instances

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.
When We Seek To Discover The Best In Others, We Somehow Bring Out The Best In Ourselves.
John Palmer
Honored Contributor

Re: Running Multiple Oracle Instances

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
Honored Contributor

Re: Running Multiple Oracle Instances

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...
If I had only read the instructions first??
Edward Wynn
Advisor

Re: Running Multiple Oracle Instances

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