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

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 - 07:52:52 CDT