Re: need some help with a bug
Date: Thu, 4 Aug 2011 08:16:54 +0800
Message-ID: <CAMNBsZuzttM7xzxSG1ZA0YGkQvo7o14XWQ+P6qc9duC7yX1W=g_at_mail.gmail.com>
Hmm. Manifestation of a bug that has been around since 9.2 --- under different Bug#s in each release. (Some of them being Wrong Results bugs).
Qualifying an object by schema name is a workaround but does Oracle believe that it is easy to change all the application code? This also makes consolidation harder to test and implement.
Hemant K Chitale
http://hemantoracledba.blogspot.com
sent from my smartphone
On 3 Aug 2011 23:53, "Andrew Kerber" <andrew.kerber_at_gmail.com> wrote:
> We are getting hit in 11.2.0.2 on Sun-sparc 64 with behavior that appears
to
> be caused by a bug that was supposed to have been fixed in 11.2.0.2. The
> bug is described below. Bug number is 9577583. Has anyone seen this or
> have a work around? Right now we are flushing our shared pool about every
5
> minutes to work around it. We have a sev 1 sr open with Oracle, but this
is
> the third day with no solution from them so far.
> *Description*
>
> ORA-942, or other unexpected errors, can occur when running in a setup
> where multiple schemas have identical objects and users are only expected
> to access objects in their own schemas.
>
> The problem can cause a SQL built for a given user to incorrectly
> have dependency / translation / access table entries for other
> users objects:
> - If there is no permission on those objects then various errors can
occur.
> - If the current user does have permission on those objects then SQL may
> execute using objects from the wrong schema leading to wrong results
> or logical data corruption.
>
> This problem can also lead to various dumps when executing PLSQL
> especially when the PLSQL is executed from RMAN or Internal Errors
> due to memory corruptions.
>
> Rediscovery Notes:
> A library_cache dump of the problem cursor shows that the child
> cursor has incorrect entries in the dependency table.
>
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 03 2011 - 19:16:54 CDT