Re: ORA-01031 Errors in Oracle Client for Third-Party Application
Date: Thu, 5 Jul 2012 02:16:12 +0000 (UTC)
Message-ID: <pan.2012.07.05.02.16.11_at_gmail.com>
On Wed, 04 Jul 2012 13:38:00 -0700, basis_consultant_at_hotmail.com wrote:
> Hi,
>
> However, one specific step in the application (Regenerating a lot of
> information) does not work. The application logs indicate ORA-01031
> errors, but no information as to the privileges missing, the Oracle
> user, etc..
>
> Our DBA indicated that he cannot find any more information in the Oracle
> traces,
>
> Is there anything that I can do on the client side to generate more
> information as to the cause of the ORA-01031 errors?
>
>
> Thanks,
> QZ
This doesn't have anything to do with ODAC or even Windows. This error is an Oracle server error, caused by a security violation. Something is not set up properly.
Tell your DBA to trace the error:
SQL> ALTER SYSTEM SET EVENTS='1031 TRACE NAME ERRORSTACK FOREVER, LEVEL
12';
System altered.
Every occurrence of 1031 from that point on will produce a detailed trace, including the session user and SQL statement that is causing the error. The trace can be turned off like this:
ALTER SYSTEM SET EVENTS='1031 TRACE NAME ERRORSTACK OFF'; System altered.
Elapsed: 00:00:00.00
SQL>
-- http://mgogala.byethost5.comReceived on Wed Jul 04 2012 - 21:16:12 CDT