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

We resolved the issue (It was on the application side), without tracing through the ORA-01031 error.

Thanks for your time,
QZ

On Wednesday, 4 July 2012 22:16:12 UTC-4, Mladen Gogala wrote:
> 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

On Wednesday, 4 July 2012 22:16:12 UTC-4, Mladen Gogala wrote:
> 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

On Wednesday, 4 July 2012 22:16:12 UTC-4, Mladen Gogala wrote:
> 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

On Wednesday, 4 July 2012 22:16:12 UTC-4, Mladen Gogala wrote:
> 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 Tue Jul 10 2012 - 12:03:04 CDT