Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple instance problem on 11.0 and Oracle 8.1.7.0

SOLVED
Go to solution
Tommy Brown
Respected Contributor

Multiple instance problem on 11.0 and Oracle 8.1.7.0

We are trying to migrate from 8.0.5 Oracle on 10.20 to a new server running 11.0 and 8.1.7.0. When we try to bring up another instance, we get the error:
"ORA-13113: end-of-file on communication Channel".
We believe we have set the Kernel Params (attached) according to release notes.. Any one have suggestions??
Thanks,
Tommy
I may be slow, but I get there !
13 REPLIES
Jeanine Kone
Trusted Contributor

Re: Multiple instance problem on 11.0 and Oracle 8.1.7.0

In my experience, ORA-03113 is usually a networking error (often relating to session timeouts in our environment). I would double check the sqlnet setup.

You mentioned getting this error upon database startup - at exactly what point do you get the message. Have you checked for any trace files that might have been generated?
Jeff Schussele
Honored Contributor

Re: Multiple instance problem on 11.0 and Oracle 8.1.7.0

Hi Tommy,

Are you using a different port for the listener on that 2nd instance?

Rgds,
Jeff
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
Jeanine Kone
Trusted Contributor
Solution

Re: Multiple instance problem on 11.0 and Oracle 8.1.7.0

Just as another option - I checked on MetaLink and there are several messages pertaining to this same problem. The solution revolved around increasing the kernel parameters (for example semaphores (semmns specifically) and processes). Or, reducing the resources used by the databases.

Sorry to be vague, but I honestly don't know too much about the kernel parameters myself...
Tommy Brown
Respected Contributor

Re: Multiple instance problem on 11.0 and Oracle 8.1.7.0

Jeff and Jeanine, THanks for your responses. We have a single instance operational. On the other server, we have 8 instances running on a single listner. The error occurs when a second instance is started. The database spaces create with out any problem. We cannot start them to run concurrently.
Tommy
I may be slow, but I get there !
Aashish Raj
Valued Contributor

Re: Multiple instance problem on 11.0 and Oracle 8.1.7.0

Are you able to indiviadully bring up both the instances when the other instance is down.

If yes, then you need to increase shmmax,semmns parameters.

Also the sum of SGA of two oracle instances can not exceed 1.75 GB.

Thanks
AR
Dave Chamberlin
Trusted Contributor

Re: Multiple instance problem on 11.0 and Oracle 8.1.7.0

There are many possibilities. Things I would check for include:
Make sure you have enough RAM, as called for by the initORA parameters for the SGA and db_block_buffers. Are you running 32 bit or 64 bit oracle? Also - check your .profile for instance specific environment variables.
Brian Crabtree
Honored Contributor

Re: Multiple instance problem on 11.0 and Oracle 8.1.7.0

Can you post an output from a "kmtune"? The output you listed has odd sizing listed, and doesn't list all of the kernel parameters that there are. The "kmtune" command will output all of the kernel parameters for a system.

Thanks,

Brian
Tommy Brown
Respected Contributor

Re: Multiple instance problem on 11.0 and Oracle 8.1.7.0

Thanks, Brian here is the attached kmtune output.
Tommy
I may be slow, but I get there !
Printaporn_1
Esteemed Contributor

Re: Multiple instance problem on 11.0 and Oracle 8.1.7.0

Hi Tommy,
Have you check the database alert log ,
there may be some information that lead us close to the problem.
enjoy any little thing in my life
T G Manikandan
Honored Contributor

Re: Multiple instance problem on 11.0 and Oracle 8.1.7.0

I probably think that the shared memory,semaphore segments are not cleaned properly.

Bring down all the instances of oracle.

#ipcs
to view the shared memory and semaphore segments owned by oracle user.

#ipcrm -s
#ipcrm -m

REmove all the entries that are used by the oracle user.
Now bring up the instances.

Please post your results.


Thanks
T G Manikandan
Honored Contributor

Re: Multiple instance problem on 11.0 and Oracle 8.1.7.0

Did you check the alert log file for messages.
Post the messages from the alertlog file .

THanks
T G Manikandan
Honored Contributor

Re: Multiple instance problem on 11.0 and Oracle 8.1.7.0

What is oracle user group name in your new installed machine.

Tommy Brown
Respected Contributor

Re: Multiple instance problem on 11.0 and Oracle 8.1.7.0

What we found was:
The Sem* parameters were not configured correctly. We replicated the settings from the "old" server since it was of similar memory/cpu config. That appeared to resolve the multiple instance difficulties.
Thanks to all who have submitted responses.
Tommy
I may be slow, but I get there !