Re: Strange ORA-01031 Error

  • From: Michael Dinh <mdinh235@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 6 Nov 2012 20:51:30 -0800

Just wanted to provide an update should anyone encounter the same issue.
The bug is fixed in 11.2.3.4 PSU and also interim patch available for
various versions.
13080778<https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?id=13080778.8>ORA-942
/ ORA-1031 / corruption for SQL using same object name in multiple schemas




On Tue, Nov 6, 2012 at 6:20 AM, Michael Dinh <mdinh235@xxxxxxxxx> wrote:

> Hello,
>
> I have been experiencing ORA-01031 insufficient privileges from
> application using Weblogic (WLS) connected as the schema owner.
>
> Database is 11.2.0.3 the SQL itself does not fail when execute from
> SQL*Plus and only fails when execute from the application using WLS.
>
> Restarting the database resolved the issue one time but it's reoccurring.
> Any help to identify the issue is greatly appreciated and I will be
> creating SR as well.
>
> Thanks Michael.
>


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


Other related posts: