Re: MTS with Oracle XA trc files

If you are generating enough TRC files to fill up the disk, then you need to parse all of the TRC files and determine all of the ORA errors that are being generated.

If ORA-00942 is the only error being generated, then the view that "does not exist" is most often V$XATRANS - you need to give it public select rights.

FWI, most ORA-00942 errors specifically indicate which table or view is not accessible.

Mike

dcameron_at_horizon.bc.ca wrote in message <80hhtl$vue$1_at_nnrp1.deja.com>...
>While MTS is runing, we get a new Oracle XA TRC file in the system32
>directory. These files eventually fill up the disk and cause us
>problems. The contents of file are:
>
>
>ORACLE XA: Version 8.0.5.0.0. RM name = 'Oracle_XA'.
>233651.88:101.101.1: ORA-00942: table or view does not exist
>233651.88:101.101.1: xaorecover: xaofetch rtn -3.
>
>OK, fine, it tells me that a table does not exist, but which one? This
>is MTS using Oracle, and I do not have access to the code.
>
>Any Ideas?
>
>Thanks
>Don
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sat Nov 20 1999 - 15:12:03 CST