http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [69]
02.File Book
File 자료실 [95]
Site Link [18]
개인폴더 [195]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2917]
PostgreSQL [103]
기타정보 [151]
운영체제 [584]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: ORACLE

 회원가입

WARNING: inbound connection timed out (ORA-3136)
최길호 [LIST]   2008-07-04 14:58:56, 조회 : 28,889

출처: 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 ]
3.239.112.140


최길호
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
2008-07-09
11:58:49



  LIST

제목 작성자 작성일 조회
Admin  [ 공지 ] 😃 서비스 시간 08:00 ~ 23:00 / 안되면 나중에 다시 방문 해주세요~.😅    최길호 2008/11/26 113
Admin  [ 필요 하신게 있으시면 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]    최길호 2006/07/14 134
Troubleshoot  acfsutil size: ACFS-03006: smallest size, without loss of data,    최길호 2022/11/23 5
WebLogic  jsp error 위치 확인 [ debug ]    최길호 2022/11/04 18
WebLogic  Error 500--Internal Server Error / Cookie 쿠키 관련    최길호 2022/11/03 14
WebLogic  Error 404--Not Found / 에러 처리    최길호 2022/11/01 16
WebLogic  wls no-stage mode source 수정 바로 반영    최길호 2022/11/01 10
WebLogic  weblogic 80 port    최길호 2022/10/26 11
Troubleshoot  sqlldr LOBFILE ORA-01460    최길호 2022/10/19 13
Admin  TNS-12508: TNS:listener could not resolve the COMMAND given    최길호 2022/10/01 22
Troubleshoot  ORA-39059: dump file set is incomplete / ORA-39246: cannot locate master table within provided dump files    최길호 2022/09/30 25
Troubleshoot  select 에러 없고 view 통하면 ORA-01031: insufficient privileges    최길호 2022/09/27 22
Admin  SQL> connect ORA-12532: TNS:invalid argument ORA-12154: TNS:could not resolve the connect identifier specified    최길호 2022/09/23 25
Script  1분이상 실행중인 SQL / long time sql / kill session    최길호 2022/09/07 37
Troubleshoot  Solaris ORA-27125: unable to create shared memory segment / SVR4 Error: 22: Invalid argument    최길호 2022/09/06 41
WebLogic  weblogic web.xml / DataSource JNDI / oracle jdbc    최길호 2022/09/05 36
WebLogic  weblogic reset admin password    최길호 2022/09/05 35
WebLogic  wls 12.2.1.4 install memo    최길호 2022/09/03 38
Script  lgsms 메세지 send script    최길호 2022/08/31 36

    목록보기   다음페이지 1 [2][3][4][5][6][7][8][9][10]..[146]   [다음 10개]
       

Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
2021/06/30
윈도우 서버에서 sqlplus .... ORA-...
by 최길호
2021/06/30
ORA-28500: connection from O...
by 최길호
2019/05/02
pkg 확인 SELECT * FROM AL...
by 최길호
최근 게시물
11/23
[ORACLE]
acfsutil size: ACFS-03006: sma....
by 최길호
11/07
[운영체제]
Job for sshd.service failed be....
by 최길호
11/04
[ORACLE]
jsp error 위치 확인 [ debug ].
by 최길호