Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9.2.0 Gentoo Linux - ORA 3113 on DB startup

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

From: anfo <root_at_nycap.rr.com>
Date: Tue, 11 Feb 2003 01:26:21 GMT
Message-ID: <1jY1a.32784$Xr1.7562447@twister.nyroc.rr.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US