WARNING: inbound connection timed out (ORA-3136)

http://iotn.co.kr/power/zboard.php?id=9_1_bbs&no=939 최길호  2008-07-04 14:58:56, 조회 : 2,514 출처: http://forums.oracle.com/forums/thread.jspa?messageID=1612957&tstart=0 "WARNING: inbound connection timed out (ORA-3136)"은 client에서 Oracle에 접속시  SQLNET.INBOUND_CONNECT_TIMEOUT에 기술된 시간에 인증을 받을수 없는 경우에 발생 합니다. SQLNET.INBOUND_CONNECT_TIMEOUT은 기본적인 값이 60 SEC 이며 정의된 시간에 인증이 않되면 alert log file에 "WARNING: inbound connection timed out (ORA-3136)"를 발생 합니다. AIX Oracle 10.2.0.2  alert.log ================================================= WARNING: inbound connection timed out (ORA-3136) 조치 ================================================= $ORACLE_HOME/network/admin/sqlnet.ora SQLNET.INBOUND_CONNECT_TIMEOUT=0 or lsnrctl =================================================================================== LSNRCTL> show inbound_connect_timeout Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Linux4U2_DB)(PORT=1521))) LISTENER parameter "inbound_connect_timeout" set to 60        <<<< 60 sec The command completed successfully LSNRCTL> set inbound_connect_timeout 0 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Linux4U2_DB)(PORT=1521))) LISTENER parameter "inbound_connect_timeout" set to 0        <<<< Change Value The command completed successfully test =================================================================================== Linux env not exist sqlnet.ora file [Linux4U2_DB :/home/gh]$ ls $ORACLE_HOME/network/admin/sqlnet.ora ls: /oracle/product/10.2/network/admin/sqlnet.ora: No such file or directory LSNRCTL> show inbound_connect_timeout Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Linux4U2_DB)(PORT=1521))) LISTENER parameter "inbound_connect_timeout" set to 0 The command completed successfully LSNRCTL> set inbound_connect_timeout 60 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Linux4U2_DB)(PORT=1521))) LISTENER parameter "inbound_connect_timeout" set to 60 The command completed successfully LSNRCTL> stop LSNRCTL> start LSNRCTL> show inbound_connect_timeout Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Linux4U2_DB)(PORT=1521))) LISTENER parameter "inbound_connect_timeout" set to 0 The command completed successfully inbound_connect_timeout = 0 [ default ]

최길호 oracle 10.2  LISTENER parameter "inbound_connect_timeout" set to 10  telnet loclhost 1521  [10초 경과]  Connection closed by foreign host.  listener.log  =======================================================================  TNS-12525: TNS:listener has not received client's request in time allowed  TNS-12535: TNS:operation timed out  TNS-12606: TNS: Application timeout occurred 반응형