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 Wed Jun 16 1999 - 22:57:44 CDT
