Shulou(Shulou.com)06/02 Report--

Oracle business system can not connect, check the network, check interception, no problem, tnsping is no problem, but can not connect, do not think about it. Look at the alert log and report an error as follows

Fatal NI connect error 12537, connecting to:

(LOCAL=NO)

VERSION INFORMATION:

TNS for 64-bit Windows: Version 11.2.0.1.0-Production

Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0-Production

Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0-Production

Time: 09-March-2018 16:55:48

Tracing not turned on.

Tns error struct:

Ns main err code: 12537

TNS-12537: TNS: connection closed

Ns secondary err code: 12560

Nt main err code: 0

Nt secondary err code: 0

Nt OS err code: 0

Opiodr aborting process unknown ospid (4564) as a result of ORA-609

Trying all kinds of methods is not done, and listening starts and stops very slowly.

Check the size of the listening log at the following location:

$ORACLE_BASE\ diag\ tnslsnr\\ listener\ trace\ listener.log--4G size

Official statement:

The platform on which the BUG problem occurs

Oracle Net Services-Version 11.1.0.7 to 11.2.0.4 [Release 11.1 to 11.2]

Microsoft Windows (32-bit)

Microsoft Windows x64 (64-bit)

This issue is limited to the Windows OS.

Checked for relevance on 14-OCT-2013

Solution: turn off listening and writing logs

Script:

LSNRCTL > set current_listener

LSNRCTL > set log_status OFF

LSNRCTL > save_config

Or, rename listener.log and restart the service. OK. Be happy.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.