Re: MTS with Oracle XA trc files

 Don,
 I just worked through this one myself. The problem is that the xa.sql  script from Oracle left out the creation of a public synonym and granting of
 access to the xa views. You need to do this and ensure that you have  relinked the Oracle executables on your server. Also check that your  distributed options are set correctly in the oracle.ini.

 To keep from filling the disk with trace files. On the web server in  c:\orant\network\admin edit the sqlnet.ora file  ensure you have the following lines

 CLIENT_TRACE_DIRECTORY = .....   {enter a non-C: drive if you have one)
 CLIENT_LOG_DIRECTORY = ......   {enter a non-c: drive if you have one}
 CLIENT_TRACE_LEVEL = OFF

 That should help. If you need more information in the trace files the  trace level is actually a number from 1 to 16 with 16 being the most  detailed. This will generate 20 MB in minutes so I would avoid it. You  might want to experiment with the levels to see which ones you want for  what info. You can change these settings on the fly. They are read  everytime the app tries to access the database. Also, be aware that there
 are a number of patches for MTS from microsoft (it leaks memory like sh.t!)
 If you have svc pak 5 you have most of the fixes but there is still one that
 is available as a patch for the mtx.exe that will be included in svc pak 6.

 Regards
 Jack Richter

Michael D. Long <lead_dog_at_bellsouth.net> wrote in message news:o6EZ3.17453$Pc6.242734_at_news2.mia...
>
> 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 Thu Jan 06 2000 - 22:46:02 CST