Re: Oracle on Linux. HAS LGWR ERROR!!!

I called Oracle Tech. support and they sent it to me....Don't know if it is available via some other method.
Jim

Mark Malakanov wrote:

> Where can I get this patch?
>
> James A. Littlefield <jal_at_alum.mit.edu> wrote in message
> news:37679E24.FDC65430_at_alum.mit.edu...
> > There is a patch for this problem which you can get from Oracle. Refer
> to Bug
> > 882446. This patch claims to open the files with O_SYNC.
> >
> > Jim
> >
> >
> > Mark Malakanov wrote:
> >
> > > I refused to use Oracle8.0.5.1 on LinuxRH2.6.
> > >
> > > The cause is in a bug in LGWR process. Oracle does not write the
> internal
> > > data into a current redo log file. Result is a loosing one or several
> latest
> > > commited transactions if server (software or hardware fails).
> > >
> > > I checked it a lot of times in different circumstances. You can do it
> > > easily.
> > >
> > > CREATE TABLE TEST (C char(10));
> > >
> > > INSERT INTO TEST VALUES ('A');
> > > COMMIT;
> > >
> > > And here you may to do software or hardware shutdown (crush model) from
> > > SHUTDOWN ABORT up to power off.
> > >
> > > Try to SELECT * FROM TEST;
> > > when Oracle will started nex time.
> > > I saw nothing!!! No record inserted.
> > > Remember - all commited transactions must be saved any way!
> > >
> > > I and other experienced Unix/Oracle people as Michael
> > > .ishamael@erroneous.demon.co.uk , see http://technet.oracle.com
> > > Oracle on Linux discussion) made the "strace" on LGWR process. Strace
> shows
> > > no flush activity after commit. Also current redo log file is opened
> without
> > > SYNC flag.
> > >
> > > Therefore I do not recommend use Oracle/Linux on production base.
> > >
> > > May be in commercial version this problem is fixed. I played trial
> version
> > > of Oracle8.0.5 (upgraded to 8.0.5.1) Server (not Enterprise Edition).
> > >
> > > Best regards.
> > > Mark
> > >
> > > Smita Sathe wrote in message <376551C1.37A7B855_at_bnl.gov>...
> > > >Has anybody used Linux machine for installing Oracle 8 or Oracle 8i
> > > >server in Produnction environment ? What is your experience ? How is
> > > >Oracle Support ? Are there any problems?
> > > >
> > > >Thanks in advance,
> > > >
> > > >smita
> > > >smita_at_bnl.gov
> > > >
> >
> >
> >
Received on Tue Jun 22 1999 - 05:48:41 CDT