Databases
StackOverflow2013
Postsdbo
POUsing ODBC Trace or Oracle Trace to find cause of error?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUsing ODBC Trace or Oracle Trace to find cause of error?
    primarykey
    data
    text
    <p>I have a third party Windows service which controls/monitors equipment and updates an Oracle database. Their services occasionally report an error about a row/column in the database being "bad" but do not give the underlying database error, and their services need to be restarted and everything is fine. The current suspicion is that something from our applications/services which read/write to those same tables/rows are interfering - i.e. some kind of blocking/locking. I suspect that there is some sort of leak in their system since it happens about once a week, but our systems never need any re-starting like this.</p> <p>I attempted to have the DBA run a trace run in Oracle (10g), but this managed to make our apps unable to access the Oracle database. Our systems access Oracle in .NET, either using the Oracle ODP client or Microsoft client (older programs) and on this same server (either web apps or services) or from other control workstations. The third-party services connects to Oracle via ODBC on this server. I also attempted to run a ODBC trace (since that would only be activity from the third-party service), but didn't get anything in the trace file at all.</p> <p>So I'm trying to find a way to either get ODBC tracing working or what I need to look out for so that the Oracle trace doesn't kill my server.</p> <p>I'm looking for the undserlying error which Oracle is returning to the thrid-party service so I can tell if we are interfering with their access to the data in some way.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USCade Roux
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUsing ODBC Trace or Oracle Trace to find cause of error?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POUsing ODBC Trace or Oracle Trace to find cause of error?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POUsing ODBC Trace or Oracle Trace to find cause of error?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COOuch! If Oracle trace stops you from using your DB then isn't that the place to start? You can prove you have a problem your end whereas you don't actually know whether the third party's error is their fault or "yours".
      singulars
      1. POUsing ODBC Trace or Oracle Trace to find cause of error?
      1. USBen
    2. COwhat third party doesn't give the underlying ORA error? This seems extremely suspect (either poorly written or its in some log somewhere)
      singulars
      1. POUsing ODBC Trace or Oracle Trace to find cause of error?
      1. UStbone
    3. COMaybe one of these answers will help: http://stackoverflow.com/questions/492705/is-there-any-way-to-log-all-failed-sql-statements-in-oracle-10g
      singulars
      1. POUsing ODBC Trace or Oracle Trace to find cause of error?
      1. USJon Heller
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload