Oracle 11g monitoring is slow due to problems with listening log files too large (under Windows)

Symptom: The Oracle database for the Windows operating system, which uses a sqlplus connection (without specifying the instance name), connects quickly, and it takes about thirty or forty seconds for the program to connect or to use the connection tool or to test the connection in net Manager (the program connection may fail).

It also takes thirty or forty seconds to pass the tsping localhost test.

Review the Monitoring warning log (which is described later in this article) with the following information:

<msg Time= ' 2017-05-16t16:57:51.811+08:00 'org_id= ' Oracle 'comp_id= ' Tnslsnr 'type= ' UNKNOWN ' Level= ' + 'host_id= ' Win-79c9vv1dm36 'host_addr= ' fe80::716b:a2ff:1445:5753%11 '> <txt>Tns-12560:tns:protocol Adapter Error Tns-00530:protocol adapter error 64-bit Windows error:53:unknown error TNS -12518:tns:listener could not hand off client connection Tns-12571:tns:packet writer failure Tns-12560:tns:proto Col Adapter Error Tns-00530:protocol adapter error 64-bit Windows error:54:unknown error</txt></msg>

View Code

The possible reason is that the listening log is too large (more than 4G).

Stop listening, delete the listening log (need to delete 4 directories of the log), turn on monitoring, the connection is slow problem resolution.

The Oracle 11g monitoring log directory location is as follows:

Alert Log directory:%oracle_home%\diag\rdbms\%sid%\%sid%\alert,%oracle_home%\diag\tnslsnr\% machine name%\listenrt\alert

Trace log directory:%oracle_home%\diag\rdbms\%sid%\%sid%\trace,%oracle_home%\diag\tnslsnr\% machine name%\listenrt\trace

Oracle 11g monitoring is slow due to problems with listening log files too large (under Windows)