From:

问题：Fatal NI connect error 12170.

VERSION INFORMATION:
        TNS for Linux: Version 11.2.0.1.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 13-DEC-2013 20:27:20
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

解决问题

								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_ = OFF
							
								   - Where the  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.
							
									、解决问题
								
																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_ = OFF
															
																   - Where the  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.http://www.xifenfei.com/1812.html