Re: 11.2.0.3 Issues with Materialized Views post April PSU? (updated)

From: Ryan January <rjjanuary_at_multiservice.com>
Date: Fri, 30 Aug 2013 09:10:08 -0500
Message-ID: <5220A7C0.7040207_at_multiservice.com>

A correction to my prior email: We rolled back to the April PSU and verified functionality. It was the July PSU we were having issues with. We also found that we had a patch applied to 11.2.0.1 to resolve extremely similar issues. Once we upgraded past 11.2.0.1 it wasn't required.

It appears that this may be regression of a previously resolved bug. I've filed an SR, however we have yet to see any movement on it. Any info you have would be greatly appreciated.

Thanks again,
Ryan

On 08/29/2013 02:15 PM, Ryan January wrote:
> Has anyone experienced ORA-600's using materialized views on the April
> 2013 PSU? If so, did you find a work around? Were there any relevant
> MOS docs you may point me to?
>
> 11.2.0.3 RAC (3 node cluster / ASM storage) on RHEL 5 using the
> 2.6.39-400.109.5.el5uek kernel.
>
> After the April PSU we began having issues with ORA-600's with a
> multitude of differing first arguments. Oracle's lookup tool has
> found similar issues (while not exactly the same) and has listed them
> as being fixed in prior releases. Attached you'll find a very simple
> test case. One sample run is included below. I should also note that
> this first surfaced using fast refresh on commit, however it has also
> been verified to affect both full and fast refreshes using
> dbms_snapshot as well. This has been proven to be easily repeatable
> and surfaces when a refresh occurs after any uncommitted transaction
> on a table referenced within the view. After the error, and
> subsequent rollback, you'll notice I issue a second refresh that does
> complete successfully. Rolling back the patches also yields proper
> refresh behavior with uncommitted transactions.
>
> Thanks,
> Ryan
>
> <snip due to over quoting>
>
> ERROR at line 1:
> ORA-12008: error in materialized view refresh path
> ORA-00600: internal error code, arguments: [kkzgajdl_dltgen-0], [],
> [], [], [],
> [], [], [], [], [], [], []
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2765
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2745
> ORA-06512: at line 1
>
> SQL> exec dbms_snapshot.refresh('SIMPLE_MV');
>
> PL/SQL procedure successfully completed.
>

-- 


------------------------------------------------------------------
This email is intended solely for the use of the addressee and may
contain information that is confidential, proprietary, or both.
If you receive this email in error please immediately notify the
sender and delete the email..
------------------------------------------------------------------

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 30 2013 - 16:10:08 CEST