Re: How to clear the ORA-03114 error

"Harry Sheng" <hsheng_at_innovance.com> wrote in message news:<aHIr7.62229$TW.338090_at_tor-nn1.netcom.ca>...
> Hi, group
>
> I am installing Oracle8.1.7 on Solaris 8.
> The installation goes smoothly. But I always get a "ORA-03114: Cann't
> connect to Oracle" error
> when I tries to create a starter database during the installation with OUI.
>
> The error with SVRMGRL is "ORA-03113: end-of-file on communication channel"
> error.set shmsys:shminfo_shmmax=4294967295
>
> How can I clear this error ?
>
> Thanks in advance.
>
> Harry

Harry,

I had exactly the same problem, and I finally found the problem: wrong kernel parameters.
For me setting the following parameters in /etc/system work:

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=200
set semsys:seminfo_semmns=350
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

Be very careful about seminfo_semmsl and seminfo_semmns: they have to be at least equal to NP+10 and 2*NP+10, where NP is the number of processes set in the
init*.ora file used, which is my case in set by the installer to 150. The example parameters in the documentation are too low. Received on Mon Oct 01 2001 - 11:31:38 CDT