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

사용자

ID:
PW:

INDEX
01.게시판
게시판 [72]
02.File Book
File 자료실 [96]
Site Link [14]
개인폴더 [201]
03.Field Book
Altibase [19]
Tibero [31]
MS-SQL [32]
MySQL [47]
DB2 [79]
ORACLE [3209]
PSQL [143]
CUBRID [5]
기타정보 [194]
운영체제 [634]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

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

 회원가입

ORA-03114 TNS-12535 ORA-02068 ORA-03113 [ client >> sqlnet.ora >> SQLNET.EXPIRE_TIME=1 ]
최길호 [LIST]   2018-06-28 15:37:26, 조회 : 36,538
- Download #1 : error.20180628.jpg (27.1 KB), Download : 1


추가
***********************************************************************
Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for Linux: Version 10.2.0.5.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.5.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.5.0 - Production
  Time: 17-AUG-2024 19:16:44
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535
    TNS-12535: TNS:operation timed out
    ns secondary err code: 12560
    nt main err code: 505
    TNS-00505: Operation timed out
    nt secondary err code: 110
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.123)(PORT=54756))

## listener.log에서 연결 정보 찾기
grep "(HOST=192.168.123.123)(PORT=54756)" listener.log.20240818

17-AUG-2024 11:05:18 * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.123)(PORT=54756)) * establish
11:05 ~ 19:16 [ 작업후 idle time중 에러 발생 같다, 연결중 에러는 아닌듯 ]

조치
cat $ORACLE_HOME/network/admin/sqlnet.ora
# keepalive 같은 주기적인 ( 1분 간격 ) 연결 확인
SQLNET.EXPIRE_TIME=1

출처:
Alert Log Errors: 12170 TNS-12535/TNS-00505: Operation Timed Out (문서 ID 1628949.1)
https://blog.naver.com/hanccii/221040317227



추가
Alert Log Errors: 12170 TNS-12535/TNS-00505: Operation Timed Out (Doc ID 1628949.1)
SQLNET.EXPIRE_TIME 아래 내용 있음. 확인 필요.
alert log 확인
***********************************************************************
Fatal NI connect error 12170.
  VERSION INFORMATION:
        TNS for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production
        TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production
        Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production
  Time: 03-APR-2019 13:57:40
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535
TNS-12535: TNS:operation timed out
    ns secondary err code: 12560
    nt main err code: 505
TNS-00505: Operation timed out
    nt secondary err code: 78
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.123.123)(PORT=1031))
The "nt secondary err code" will be different based on the operating system:

Linux x86 or Linux x86-64: "nt secondary err code: 110"
HP-UX : "nt secondary err code: 238"
AIX: "nt secondary err code: 78"
Solaris: "nt secondary err code: 145"

[ 의미 없지만 해본다 ]
vi $ORACLE_HOME/network/admin/listener.ora
INBOUND_CONNECT_TIMEOUT_LISTENER=200
vi $ORACLE_HOME/network/admin/sqlnet.ora
SQLNET.INBOUND_CONNECT_TIMEOUT = 200
LSNRCTL> show INBOUND_CONNECT_TIMEOUT
LISTENER parameter "inbound_connect_timeout" set to 200

추가
SQLNET.EXPIRE_TIME=1 >> 효과 없음.
1. java client 만들어서 세션 연결후 에러 확인
2. sqlplus 연결후 에러 확인
3. 30분,2시간 간격으로 체크, 에러나면 재시도 해서 계속 로그에 저장.

추가
dblink check procedure
http://iotn.co.kr/power/zboard.php?id=9_1_bbs&no=2372

추가
ORA-02068: following severe error from DBLINK
ORA-03113: end-of-file on communication channel

파워빌더 개발
DB 11.2.0.4.0
alert.log [ client 에러 날때 같이 나지 않음 ]
***********************************************************************
Fatal NI connect error 12170.
  VERSION INFORMATION:
        TNS for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production
        TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production
        Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production
  Time: 27-JUN-2018 11:43:34
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535

TNS-12535: TNS:operation timed out
    ns secondary err code: 12560
    nt main err code: 505

TNS-00505: Operation timed out
    nt secondary err code: 78
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.xxx.xxx 에러 나는 IP만 주기적으로 보임 )(PORT=6671))
Wed Jun 27 12:54:33 2018
***********************************************************************

Alert Log Errors: 12170 TNS-12535/TNS-00505: Operation Timed Out (문서 ID 1628949.1)
# server side sqlnet.ora
SQLNET.EXPIRE_TIME=n  Where <n> is a non-zero value set in minutes.  
Once this change is in place, there is NO need to restart the listener or the database.  The change will be in place for all newly spawned server processes following the change.

SQLNET.EXPIRE_TIME can mimic data transmission between the server and the client during long periods of idle time.
In fact, some later firewalls and updated firewall firmware may not see DCD packets as a valid traffic possibly because the packets that DCD sends are actually empty packets.
Therefore, DCD may not work as expected and the firewall / switch may still terminate TCP sockets that are idle for the period monitored, even when DCD is enabled and working.
** RAC 사용시 RDBMS_HOME/network/admin/sqlnet.ora 편집


Fatal NI Connect Error 12170, 'TNS-12535: TNS:operation timed out' Reported in 11g Alert Log (문서 ID 1286376.1)
# message off?
# sqlnet.ora
DIAG_ADR_ENABLED = OFF
# listener.ora
DIAG_ADR_ENABLED_LISTENER = OFF


1차 조치
# sqlnet.ora
SQLNET.EXPIRE_TIME=1  # Where <n> is a non-zero value set in minutes.  
# listener.ora
HOST = 192.168.xxx.xxx
# tnsnames.ora
HOST = 192.168.xxx.xxx

oracle client : 10g [ 변경 없음 ]
PB O90 => O10 profile 변경후 운영.

resource_limit = FALSE [ default ]

http://iotn.co.kr/power/zboard.php?&id=9_1_bbs&no=119

http://iotn.co.kr/power/download.php?id=9_1_bbs&no=119&filenum=1
=====================================================================================
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\Tcpip\Parameters]
"KeepAliveTime"=dword:00180000
=====================================================================================
216.73.216.139


  LIST

제목 작성자 작성일 조회
Admin  [ 공지 ] 😃 ================ 필요 할때만 운영 합니다. 안되면 나중에 다시 방문 해주세요~. =================== 😅    최길호 2008/11/26 116
Admin  [ 필요 하신게 있으시면 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]    최길호 2006/07/14 136
Admin  impdp Slow While Creating Views / create view [ Event: single-task message ]    최길호 2025/07/04 3
Admin  select username,last_login from dba_users / UPDATE user$ SET spare6 = DECODE(to_char    최길호 2025/07/03 5
Admin  create type ORA-39083 ORA-02304    최길호 2025/07/03 6
Script  sms recovery check ORA-00278 정상 복구중.    최길호 2025/07/03 4
Admin  ORA-02019: connection description for remote database not found    최길호 2025/07/03 2
Admin  The clock on host node2 differs from mean cluster time by    최길호 2025/06/27 10
Admin  PRCD-1229 ORA-29701: unable to connect to Cluster Synchronization Service [ 19c grid - 12c SE2 rac ]    최길호 2025/06/26 6
Admin  opatch lsinventory [ LsInventorySession failed: Array index out of range: 0 ]    최길호 2025/06/26 4
Admin  Linux 9 oracle 12.2 install [ /usr/bin/ld: cannot find /usr/lib64/libpthread_nonshared.a ] [ linux 7, 8에서 설치후 사용은 가능 ]    최길호 2025/06/26 2
Admin  windows sqlplus "/as sysdba" ORA-01031: insufficient privileges    최길호 2025/06/16 9
Admin  ORA-00800: soft external error, arguments: [Set Priority Failed]    최길호 2025/06/12 11
Admin  grep /usr/bin/make $ORACLE_HOME/install/make.log [ EE / SE2 ]    최길호 2025/06/09 18
Admin  acfs asmcmd volcreate / srvctl add filesystem / acfsutil size / srvctl start filesystem    최길호 2025/06/05 15

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

Copyright 1999-2025 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 최길호
최근 게시물
07/04
[ORACLE]
impdp Slow While Creating View....
by 최길호
07/03
[ORACLE]
select username,last_login fro....
by 최길호
07/02
[운영체제]
rsync -auv.
by 최길호