Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: help: too many trc files

Re: help: too many trc files

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Tue, 09 Nov 1999 08:01:07 -0500
Message-ID: <38281B13.AE8404EA@Unforgettable.com>


Vincenzo Frezza wrote:
>
> Help! I am running SQL*NET on a windows NT Server which is also running SQL
> Server 7.3.4. When I start the Distributed Transaction Coordinator, Sql*NET
> is generating about 1 errors per second in the system32 directory. Here is
> what the error says in the error log file:
>
> FileName:xa_ba7fd222-ebc5-11d2-80ad-009027464eeb040599.trc and the filename
> increments with a guid.
>
> 193025.80:113.113.23:
> ORACLE XA: Version 7.3.4.0.0. RM name = 'Oracle_XA'.
>
> 193025.80:113.113.23:
> xaofetch: XAER_RMERR; upipse rtn ORA-942; sql_stmt=SELECT k2gtifmt,
> k2gtitid_ext, k2gtibid FROM sys.v$xatrans$
>
> 193025.80:113.113.23:
> ORA-00942: table or view does not exist
>
> 193025.80:113.113.23:
> xaorecover: xaofetch rt
>
> What the heck is going on? anyone know???
>
> Thanks in advance.
> Vincenzo

First of all, the program that is trying to access oracle does not have proper permissions on some table. In addition, it looks like the trace level
in sqlnet.ora is set too high. Received on Tue Nov 09 1999 - 07:01:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US