Re: ORA-01031 Errors in Oracle Client for Third-Party Application

From: Mladen Gogala <gogala.mladen_at_gmail.com>
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.com
Received on Wed Jul 04 2012 - 21:16:12 CDT

Original text of this message