TNSPING time out/響應慢,tnspingout

來源:互聯網
上載者:User

TNSPING time out/響應慢,tnspingout

E:\s01\app\oracle\product\11.2.0\dbhome_1\BIN>tnsping CENORCLTNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 25-MAY-2015 10:26:59Copyright (c) 1997, 2010, Oracle.  All rights reserved.Used parameter files:e:\s01\app\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.oraUsed TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = W01SQL0601.pharmatechs.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = cenorcl)))OK (266310 msec)

查了些資料後發現是listener.log超過4G就會出現這個問題,解決很簡單。
lsnnrctl stop
刪除listener.log
lsnrctl start
恢複正常。

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.