Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tracing?
Hi,
Widespread use of Oracle Trace can have a number of apparently mysterious side effects including:
Workaround
Two workarounds exist:
Workaround A - No Oracle Trace output required: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 1. Shut down all 7.3 databases and listeners. 2. Remove the Oracle Trace files: Unix NT ~~~~ ~~ cd $ORACLE_HOME/otrace/admin cd orant\otrace73\admin rm -f *.dat del*.dat
Reboot the NT server
Workaround B - Disable Oracle Trace on specific connections ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ NB: This workaround is not applicable to NT. 1. Shutdown and remove the trace configuration files as inWorkaround A.
2. Reinitialise the Oracle Trace files by typing 'otrccref' in the otrace/admin directory. 3. To disable Oracle Trace for a particular session set the environment variable EPC_DISABLED to TRUE. Eg: In a Bourne script: EPC_DISABLED=TRUE; export EPC_DISABLED In the C-Shell: setenv EPC_DISABLED TRUE 4. To set EPC_DISABLED=TRUE for SQL*Net connections you can modify the 'SID_LIST_listener' clause in the 'listener.ora' file andadd:
(ENVS='EPC_DISABLED=TRUE') to the SID_DESC for each 7.3 database. Add the entry AFTER the (ORACLE_HOME=...) clause. Eg: SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (SID_NAME=DB1) (ORACLE_HOME=/oracle/OFA_base/app/oracle/product/7.3.2) (ENVS='EPC_DISABLED=TRUE') ) (SID_DESC= (SID_NAME=DB2) (ORACLE_HOME=/oracle/OFA_base/app/oracle/product/7.3.2) (ENVS='EPC_DISABLED=TRUE') ) ) By using two listener processes you can have one SQL*Net aliaswhich allows tracing and another that has tracing disabled.
5. Restart and databases and SQL*Net listeners.
"The Views expressed here are my own and not necessarily those of Oracle Corporation"
"Ms. D.H. Harvey" <qq45_at_liverpool.ac.uk> wrote in message news:88jb5v$dpb$2_at_news.liv.ac.uk...
> SunOS 5.6 > > Oracle7 Server Release 7.3.4.0.1 - Production > With the distributed and replication options > PL/SQL Release 2.3.4.0.0 - Production > > In .../otrace/admin files collect.dat, process.dat & regid.dat > are growing ie some/all of our Oracle7 databases are oracle > tracing. Can't tell as these file don't give any clues. > > Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production > PL/SQL Release 8.0.5.0.0 - Production > > The .dat files as above exist in .../otrace/admin here but are not > growing ie not tracing. > > Have check oracle_trace_enable parameter for each database and it > is FALSE for all. > > Any pointers as to why O7 tracing and determining on which database/s > would be much appreciated. > > TIA HelenReceived on Fri Feb 18 2000 - 09:31:50 CST