I'm attempting to disable sqlnet tracing.
I was getting error:
VERSION INFORMATION:
TNS for Solaris: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.2.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.2.0 – Production
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS:connection closed
TNS-12537: TNS:connection closed
ns secondary err code: 12560
ns main err code: 12537
opiodr aborting process unknown ospid (3776) as a result of ORA-609
after some research on turning tracing on is to put this in sqlnet.ora:
trace_level_server = 10
trace_file_server = server.trc
trace_directory_server = /u01/app/oracle/product/11202/network/admin/
Well, now it's producing too many trace files. I want to stop so i remove the above params from sqlnet.ora and restart listener. It's been a couple of hours and it's still generating following trace:
2014-08-20 16:01:25.599879 : -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
2014-08-20 16:01:25.599917 : Successful parameter table load
2014-08-20 16:01:25.599963 : -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
2014-08-20 16:01:25.600004 : SQLNET.ENCRYPTION_TYPES_SERVER = (3DES168)
2014-08-20 16:01:25.600041 : trace_level_server = 10
2014-08-20 16:01:25.600078 : SQLNET.INBOUND_CONNECT_TIMEOUT = 180
2014-08-20 16:01:25.600115 : trace_directory_server = /u01/app/oracle/product/11202/network/admin/
2014-08-20 16:01:25.600151 : trace_file_server = server.trc
2014-08-20 16:01:25.600187 : --- PARAMETER SOURCE INFORMATION ENDS ---
2014-08-20 16:01:25.600232 : --- LOG CONFIGURATION INFORMATION FOLLOWS ---
2014-08-20 16:01:25.600287 : Log stream will be "/u01/app/oracle/diag/rdbms/prod/PROD/alert/log.xml"
2014-08-20 16:01:25.600325 : Log stream validation not requested
2014-08-20 16:01:25.600361 : --- LOG CONFIGURATION INFORMATION ENDS ---
I have remove the trace level server, why is it still showing up?