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

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 15 1999 - 11:13:33 CDT