11G新的日志信息体系导致ALERT日志报出TNS信息

11G新的日志信息体系导致ALERT日志报出TNS信息
现象：alert日志报出很多的tns信息：
The alert log raise error:
TNS-12535: TNS:operation timed out
 ns secondary err code: 12560
 nt main err code: 505

TNS-00505: Operation timed out
 nt secondary err code: 110
 nt OS err code: 0
 Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.21.24.6)(PORT=39039))
Tue Apr 16 08:33:56 2013


***********************************************************************

Fatal NI connect error 12170.

 VERSION INFORMATION:
 TNS for Linux: Version 11.1.0.6.0 - Production
 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.6.0 - Production
 TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.6.0 - Production
 Time: 16-APR-2013 08:33:56
 Tracing not turned on.
 Tns error struct:
 ns main err code: 12535

TNS-12535: TNS:operation timed out
 ns secondary err code: 12560
 nt main err code: 505

TNS-00505: Operation timed out
 nt secondary err code: 110
 nt OS err code: 0
 Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.21.24.6)(PORT=39041))
Tue Apr 16 08:33:56 2013


***********************************************************************

Fatal NI connect error 12170.

 VERSION INFORMATION:
 TNS for Linux: Version 11.1.0.6.0 - Production
 Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.6.0 - Production
 TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.6.0 - Production
 Time: 16-APR-2013 08:33:56
 Tracing not turned on.
 Tns error struct:
 ns main err code: 12535

TNS-12535: TNS:operation timed out
 ns secondary err code: 12560
 nt main err code: 505

TNS-00505: Operation timed out
 nt secondary err code: 110
 nt OS err code: 0
 Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.21.24.6)(PORT=39043))

分析：
From document:
These time out related messages are mostly informational in nature. The messages indicate the specified client connection (identified by the 'Client address:' details) has experienced a time out.
If you want to find out which connection has experienced a time out, you need to check the listener.log.

You may choose to revert from the new Automatic Diagnostic Repository (ADR) method to prevent the Oracle Net diagnostic details from being written to the alert log(s) by setting the following Oracle Net configuration parameters:
To revert to Oracle Net Server tracing/logging, set following parameter in the server's sqlnet.ora :

DIAG_ADR_ENABLED = OFF

Also, to back out the ADR diag for the Listener component, set following parameter in the server's listener.ora:

DIAG_ADR_ENABLED_<listenername> = OFF

 - Where the <listenername> would be replaced with the actual name of the configured listener(s) in the listener.ora configuration file. For example, if the listener name is 'LISTENER', the parameter would read:

DIAG_ADR_ENABLED_LISTENER = OFF

-Reload or restart the TNS Listener for the parameter change to take effect.

For detailed information, please check below note
Fatal NI Connect Error 12170, 'TNS-12535: TNS:operation timed out' Reported in 11g Alert Log [ID 1286376.1]

解决办法：
1.在sqlnet.ora中添加DIAG_ADR_ENABLED = OFF，再reload监听即可。
或者
2.在listener.ora中添加DIAG_ADR_ENABLED_<listenername> = OFF，再reload监听即可。