Home » RDBMS Server » Networking and Gateways » TRACE_LEVEL_SERVER=off (windows)
TRACE_LEVEL_SERVER=off [message #550123] Fri, 06 April 2012 03:26 Go to next message
sandeip
Messages: 23
Registered: May 2011
Location: pune
Junior Member
Hi all,
I am having 11.2.0.1.0 database with windows2k3 OS.

For ORA-609 error i have started server side tracing by adding TRACE_LEVEL_SERVER=16,TRACE_LEVEL_DIRECOTRY=D:\TRACE\,and DIAG_ADR_ENABLED=off in sqlnet.ora file and i reload the listener.

Now i want to stop tracing so i have tried TRACE_LEVEL_SERVER=off but it wouldnot work. After that i remove TRACE_LEVEL_SERVER=16,TRACE_LEVEL_DIRECOTRY=D:\TRACE\ from sqlnet.ora file and reload the listener but trace file generation is going on D:\TRACE\.

Please help me to stop server side tracing.

Report message to a moderator

Re: TRACE_LEVEL_SERVER=off [message #550128 is a reply to message #550123] Fri, 06 April 2012 03:56 Go to previous messageGo to next message
John Watson
Messages: 8963
Registered: January 2010
Location: Global Village
Senior Member
Quote:
TRACE_LEVEL_DIRECOTRY=D:\TRACE\
This did not enable tracing. It would need to be TRACE_DIRECTORY_SERVER. So I think you are editing the wrng file.

Report message to a moderator

Re: TRACE_LEVEL_SERVER=off [message #550133 is a reply to message #550128] Fri, 06 April 2012 04:04 Go to previous message
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
In addition, the parameter name is wrong (mistyped).

Regards
Michel

[Updated on: Fri, 06 April 2012 04:05]

Report message to a moderator

Previous Topic: Oracle Transparent Gateway fails on AS400
Next Topic: License required to use OID 11g?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 19 23:14:26 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.