Re: Stupid Question: Be Kind

> ora-3113 at startup is almost always caused by inappropiate shared
> memory parameters in the kernel for the Oracle memory parameters in
> $ORACLE_HOME/dbs/initPROD.ora
> Usually this is caused by insufficient semaphores (the SEMMNS
> parameter) This parameter needs to be 2 * processes in init.ora + 10
> If you have 100+ processes defined in initPROD.ora (processes = <n>),
> cut the number of processes down and retry. Otherwise, change the
> SEMNS parameter recompile the kernel and reboot.

If you don't want to recompile the kernel or just test new settings you can change SEMMNS and other parameters (before starting Oracle) with

echo <your values go here> > /proc/sys/kernel/sem

Look at your Linux distrubution documentation which values have to be at which position in the file.

Regards,

Knut Received on Mon Apr 15 2002 - 03:22:14 CDT