Multiple instance problem on 11.0 and Oracle 8.1.7.0

[Tommy Brown]

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

[Jeanine Kone]

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]

Hi Tommy,

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

Rgds,
Jeff

[Jeanine Kone · Accepted solution]

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]

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

[Aashish Raj]

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]

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]

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]

Thanks, Brian here is the attached kmtune output.
Tommy

[Printaporn_1]

Hi Tommy,
Have you check the database alert log ,
there may be some information that lead us close to the problem.

[T G Manikandan]

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]

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

THanks

[T G Manikandan]

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

[Tommy Brown]

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