Re: Oracle 9.2.0 Gentoo Linux - ORA 3113 on DB startup

Sybrand,

Thank you for the reply, I will check this tomorrow. I know I never checked this in trying to resolve the problem After replying to Jaspers post my anal retentivness kicked in and I searched around again and came up with one other possibility from the otn forums:

[QUOTE]
The answer is trust SuSE, they support Oracle way, way better than Red Hat. On FTP.SUSE.COM under pub, then i386 then commerical I found a tiny RPM orarun9i.rpm. This RPM set your profile, startup (database), shutdown (database),
ORACLE_HOME and recommended kernel parameters (SHMMAX)

The 9.2.0 install flew on SuSE 8.0 personal without a hitch after running the
RPM I found the orarun9i.rpm file at:
/pub/suse/i386/supplementary/commercial/Oracle

[/QUOTE] This was in regard to the 3113 error on db create as well and did resolve her problem, I notice that this rpm also sets the kernel parameters so I am guessing you hit this spot on.

Thanks again & Best Regards,
anfo

"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message news:7bmd4vogcckj4k4uc56f561e0kg7q1u7k5_at_4ax.com...
> On Sun, 09 Feb 2003 22:09:16 GMT, "anfo" <root_at_nycap.rr.com> wrote:
>
> >Where I have a problem is in creating a second database
>
>
> Most likely your semmns parameter is incorrect.
> It has to be
> 2 * the total number of processes on all instances (as from the
> processes parameter) + 10 for each instance.
>
> Familiar cause for 3113, as Oracle will set up all semaphores as
> needed by the processes parameter
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sun Feb 09 2003 - 17:30:27 CST