Re: 9.2.0.4 experiences

I plan to apply patchset 9204 for my 9203 rac and found a lot of problems in metalink, so be careful applying that PATCHSET.So I stop.

here is the list:

1.OUI bug. Must install OUI 2.2.0.18 before patch the database.

2.OUI bug. OUI do not install OUI to other nodes in a RAC system. You   must install OUI manually on other rac node.

3.It introduced other bugs,

    1.Corrupt OLAP data dictionary.

    2.Linux: Error Reading OCFS Quorum File When Starting ORACM after       upgrade to 9204(OCFS bug again)

    3.OERI[KCBGTCR_1] selecting from COMPRESSED IOT after UPGRADE from       8.1.7 to 9.2

    4.Unix: Incorrect kdd.o shipped with 9.2.0.4 Patch Set (I did not       find that file in my 9203 linux/solaris box)

4. Bugs introduced by 9.2.0.4

3119025 Dump in KKOGTP possible from CBO when CHECK CONSTRAINTS exist---- Seems terrible

2799028 ENH: Remove Functional Index need for QUERY_REWRITE / QUERY_REWRITE_ENABLED Of course, I have patched my testdb from 9201 to 9204 without noticable problems. But for production ,please be careful:)

--
Posted via http://dbforums.com