8.1.7.3 Bugs

Rich Jesse wrote:
>>

The reason I ask is that there are some ORA-7445 bugs in 8.1.7.2 when using CURSOR_SHARING=FORCE that are supposed to be fixed in 8.1.7.3.

Also, is ANYONE using 8.1.7.3 on Solaris? Any problems? This is the first I've heard of downgrading from .3 to .2. Of course, it's as I'm prepping patching some Solaris8 boxes to .3 from .0. Figures.
>>

I don't know if this is the bug originally referred to in the thread about downgrading from 8.1.7.3 to 8.1.7.2, but bug 2290607 (last updated May 6, 2002) is filed against 8.1.7.3. on Solaris.

QUERY WITH STAR_TRANSFORM CRASHES WITH ORA-3113, ORA_7445 The cause is apparently having STAR_TRANSFORMATION_ENABLED=TRUE set in init.ora. The work-around is to set it to false (which we don't want to do because we're a datawarehouse).

This appears to be a duplicate of bug 1038883; this has crashed our database a few times - we're on 8.1.6.0 on Solaris 2.7. There is also some confusion about which version has fixed this bug. The release note for patchset 8.1.6.3 says bug 1038883 is fixed in 8.1.6.3; yet the bug report for 1038883 says it

isn't fixed until 8.1.7.0. Now it appears to have surfaced again under a 
new bug number in 8.1.7.3, which makes me wonder if it's fixed in any version
between 8.1.6.0 and 8.1.7.3.

Which is worse:
  bug in 8.1.7.2 caused by cursor_sharing=force   bug in 8.1.7.3 caused by start_tranformation_enabled=true?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Becker
  INET: beckerb_at_mfldclin.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).