Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9.2.0 Gentoo Linux - ORA 3113 on DB startup
I am using the RedHat7.2 distribution default smp kernel. The system is a
Dell 6300 quad 550-2mb xeon/4GB RAM/16GB Raid 5 array (s/w & h/w are on
"approved" list). None of these suggestions worked for me so far, I
increased shmmax from 1GB to 2 GB, didnt help initially. Once I took down
the Running instance and the Orion appserver (an early 9iAS from ironflare)
the system still had a large amount of shared mem allocated to oracle, after
I manually removed the segments, I was able to create the new instance with
no problems. This did get me thinking about the Java implementation as I
noticed almost every oracle tool/utility is java based. I have the blackdown
jre1.1.8_v3, I am wondering if using the same 1.3.1_05 version that the app
server is using might help. I am also going to update the kernel to the
latest stable branch and build a custom, Ill try this next weekend and post
back if I find anything useful.
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
news:pan.2003.02.10.21.54.25.384358_at_yahoo.com.au...
> On Mon, 10 Feb 2003 22:13:12 +0100, Jasper wrote:
>
> > 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 ?
> >
>
> It works fine (sort of... see posts elsewhere for minor niggles) with
> 2.4.18 (Red Hat 8.0) and 2.4.19 (Mandrake). Certainly no 3113's.
>
> With Red Hat, I had to make a minor adjustment that I'd never come across
> before (but that's only because I was a Windows user until the weekend!):
> namely, edit /etc/sysctl.conf and add the lines
>
> # Shared memory limit
> kernel.shmmax = 1073741824
>
> I know you're not using Red Hat, but you might find
> http://thomasfly.com/Oranux/Oracle9i.htm helpful... I did on Mandrake, for
> example. And it's where I got the sysctl.conf tip from, which made a
> difference.
>
> Regards
> HJR
>
>
>
Received on Mon Feb 10 2003 - 19:26:21 CST