Re: need some help with a bug

From: Rajeev Prabhakar <rprabha01_at_gmail.com>
Date: Wed, 3 Aug 2011 20:35:23 -0400
Message-ID: <CAPsSLA7UvNp4R-PJxN_jMai4qcZwOuPcMRW8xskZOWJTGpTitA_at_mail.gmail.com>

Absolutely, we had been facing it randomly for weeks during our rman backups (random servers/same catalog db) and the way we resolved it was by bumping up the shared pool.

On Wed, Aug 3, 2011 at 11:51 AM, 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-l

Received on Wed Aug 03 2011 - 19:35:23 CDT