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

Thanks for the answers guys.

My answers :

I've checked <all> kernel parameters. Rebooting would not be necessary because I
can write the new params in /proc/sys/kernel and they will be effective immediately.

Also tried the orarun9i script, no luck either.

I've fiddled around with my init.ora, increasing/decreasing sga size, processes, etc, no luck.

I'm using kernel 2.4.20 btw, what kernel version are you guys using ?

Any more ideas ?

Thanks, Jasper

"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message news:92eeeff0.0302091958.199145f2_at_posting.google.com... > "anfo" <root_at_nycap.rr.com> wrote in message news:<nwB1a.1404$9U3.631_at_twister.nyroc.rr.com>...
> > 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
> >

>
>
> Last week I installed 9iR2 and created 3 instances (Dev, Prod and
> test) on RedHat 7.3 without any problems. The only problem I
> encountered was downloading and deflating the 3 .gz files from the OTN
> and that too was a Netscape issue. I was kinda impressed with RedHat
> 7.3 for not giving me any hiccups. I however, created the databases
> from scripts alone + I made sure to setup the kernel paramerets
> according to the Oracle docs and add for two extra instances.
>
> As others have mentioned above, make sure to set all kernel parameters
> and not just shmmni and shmmax.
>
> Regards
> /Rauf Sarwar