首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >为什么Oracle数据库跟踪文件中出现TNS错误

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

Stack Overflow用户
提问于 2019-09-09 00:14:18
回答 1查看 789关注 0票数 0

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

代码语言:javascript
复制
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
}
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2019-09-09 02:45:17

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

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/57843619

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档