Skip to main content

Posts

Showing posts from February, 2018

Oracle 11g socket timeout while working well locally via sqlplus

It was not a firewall or port blockage It was  a trace listener.log file increasing (5 Giga) ( it was located under  C:\app\admin_user_name\diag\tnslsnr\onlinesurvey\listener\trace) i have resolved this issue by 1- stop the listener      lsnrctl stop 2- shutdown db  sqlplus / as sysdba SHUTDOWN IMMEDIATE 3- rename the log    ( it should be listener.log file) 4- start db sqlplus / as sysdba STARTUP 5-start listner      lsnrctl start to stop listener log at all  i used this command lsnrctl set log_status off