时间戳

首页 > 解决方案 > 为什么 Oracle 数据库跟踪文件中出现 TNS 错误

oracle - 为什么 Oracle 数据库跟踪文件中出现 TNS 错误

问题描述

我有一个在 oracle 11G 中运行的数据库。它的跟踪文件中有以下错误。它是否会影响任何性能或导致任何缓慢？

Fatal NI connect error 12537, connecting to:
 (LOCAL=NO)

  VERSION INFORMATION:
    TNS for Solaris: Version 11.2.0.4.0
    Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.4.0
    TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.4.0
  Time: 04-SEP-2019 07:00:01
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12537

TNS-12537: TNS:connection closed
    ns secondary err code: 12560
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
opiodr aborting process unknown ospid (13538) as a result of ORA-609
Wed Sep 04 07:03:24 2019
ORA-01555 caused by SQL statement below (SQL ID: f467srusn1111, Query Duration=0 sec, SCN: 0x0c93.05004d3a):
SELECT OBJECT_ID, SUBPROGRAM_ID, OWNER, OBJECT_NAME, PROCEDURE_NAME, OVERLOAD, OBJECT_TYPE FROM DBA_PROCEDURES WHERE (OBJECT_ID, SUBPROGRAM_ID) IN ((:1 ,:2 ),(:3 ,:4 ),(:5 ,:6 ),(:7 ,:8 ),(:9 ,:10 ),(:11 ,:12 ),(:13 ,:14 ),(:15 ,:16 ),(:17 ,:18 ),(:19 ,:20 ))
Wed Sep 04 07:59:00 2019
ORA-01555 caused by SQL statement below (SQL ID: f467srusn1111, Query Duration=0 sec, SCN: 0x0c93.05004d3a):
SELECT OBJECT_ID, SUBPROGRAM_ID, OWNER, OBJECT_NAME, PROCEDURE_NAME, OVERLOAD, OBJECT_TYPE FROM DBA_PROCEDURES WHERE (OBJECT_ID, SUBPROGRAM_ID) IN ((:1 ,:2 ),(:3 ,:4 ),(:5 ,:6 ),(:7 ,:8 ),(:9 ,:10 ),(:11 ,:12 ),(:13 ,:14 ),(:15 ,:16 ),(:17 ,:18 ),(:19 ,:20 ))
Wed Sep 04 08:00:01 2019
}

标签： oraclesolaristns

解决方案

该问题是由错误 ora-1555 引起的。当您的回滚段中没有足够的空间时，会引发 ora-1555。您需要检查回滚段/撤消的配置。

推荐阅读