Hi,

I installed a third party application in a Windows 7 server. That
application uses a corporate Oracle 11
database.

On the Windows server, as per the recommendation of the vendor's
application, I installed ODAC,
and configured the client connection to Oracle 11.

There are 2 Oracle users for the application, each using its own
schema. (The users have
full DML and DDL privileges for their respective schemas).

The connection to Oracle works; I can login using Sqlplus, the
application succeessfully installed and loads
data, etc..

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

On Wed, 04 Jul 2012 13:38:00 -0700, basis_consultant (AT) hotmail (DOT) com wrote:


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

Thanks Mladen.

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


On Wednesday, 4 July 2012 22:16:12 UTC-4, Mladen Gogala wrote:


On Wednesday, 4 July 2012 22:16:12 UTC-4, Mladen Gogala wrote: