Oracle-L: Be careful applying patchset 9204

From: zhu chao <chao_ping_at_vip.163.com>
Date: Thu, 04 Sep 2003 09:44:28 -0800
Message-ID: <F001.005CECAD.20030904094428@fatcity.com>

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:)

Regards
zhu chao
msn:chao_ping_at_163.com
www.cnoug.org

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: zhu chao
INET: chao_ping_at_vip.163.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Sep 04 2003 - 12:44:28 CDT