[ The imperialist Japanese military must officially acknowledge and apologize for the coercion of young women into sexual slaves. / 幼い女性を性の奴隷にした帝國主義日本軍の?制性を公式に認め、謝罪しなければならない. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [71]
02.File Book
File 자료실 [96]
Site Link [14]
개인폴더 [201]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [25]
MySQL [43]
DB2 [79]
ORACLE [3054]
PSQL [135]
CUBRID [5]
기타정보 [158]
운영체제 [607]
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, 조회 : 29,103

출처: 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.9.151


최길호
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 135
Admin  plsql run sql from column / 테이블에 저장된 SQL 실행 / print_table    최길호 2024/02/28 9
Admin  ORA-16198: LGWR received timedout error from KSR / 로그 기록    최길호 2024/02/23 8
Admin  ORA-02025: all tables in the SQL statement must be at the remote database    최길호 2024/02/20 12
Admin  (HS=OK) dblink windows listener stop/start hang    최길호 2024/02/15 6
Admin  TRIGGER ORA-00060: deadlock detected while waiting for resource / AUTONOMOUS_TRANSACTION    최길호 2024/02/14 6
Admin  PL/SQL error logging / autonomous_transaction / sqlerrm / ORA-04091    최길호 2024/02/08 20
Admin  ORA-00036: maximum number of recursive SQL levels (50) exceeded    최길호 2024/02/08 7
Admin  trigger ORA-04092: cannot COMMIT in a trigger / ORA-20000: Cannot drop object / RAISE_APPLICATION_ERROR / insert log    최길호 2024/02/07 4
Admin  IBM live migration / RAC 19c    최길호 2024/02/01 9
Troubleshoot  DDE: Problem Key 'ORA 600 [qosdExpStatRead: expcnt mismatch]' / _FIX_CONTROL / V$SYSTEM_FIX_CONTROL    최길호 2024/01/30 21
Backup and Recovery  dgmgrl / alter database activate standby database    최길호 2024/01/23 8
Admin  select CREATED,RESETLOGS_TIME,PRIOR_RESETLOGS_TIME,CONTROLFILE_CREATED,CONTROLFILE_TIME,VERSION_TIME from V$DATABASE    최길호 2024/01/23 8
Admin  recover standby database until time '2024/01/22 22:30:00';    최길호 2024/01/22 6
Admin  dgmgrl / alter database convert to snapshot standby [ flashback database ]    최길호 2024/01/22 10

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

Copyright 1999-2024 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 최길호
최근 게시물
03/04
[기타정보]
아두이노 wifi web test.
by 최길호
03/01
[기타정보]
아두이노 스마트하우스 V2.
by 최길호
02/28
[ORACLE]
plsql run sql from column / 테....
by 최길호