Re: need some help with a bug
- From: Rajeev Prabhakar <rprabha01@xxxxxxxxx>
- To: andrew.kerber@xxxxxxxxx
- Date: Wed, 3 Aug 2011 20:35:23 -0400
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@xxxxxxxxx>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.'
>
Other related posts:
