ORA-12537: TNS:connection closed连接关闭,Oracle报错处理
来源:互联网 发布:中文模糊匹配软件 编辑:程序博客网 时间:2024/05/21 09:06
1. 报错信息ORA-12537: TNS:connection closed连接关闭
[oracle@pldb236 admin]$ rlwrap sqlplus powerdesk/pd141118@PD236SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 23 14:16:31 2015Copyright (c) 1982, 2009, Oracle. All rights reserved.ERROR:ORA-12537: TNS:connection closedEnter user-name:
检查监听正常,oracle服务也是正常启动的,但是登录不进去。
[oracle@jcapp ~]$ tnsping PD236TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 05-DEC-2017 16:57:47Copyright (c) 1997, 2009, Oracle. All rights reserved.Used parameter files:/opt/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.oraTNS-03505: Failed to resolve name[oracle@jcapp ~]$
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
ok可以连接上了,问题初步解决
3,不过3分钟后,又不行了,登录不上去。
去查看lsnrctl状态:
[oracle@pldb236 bin]$ lsnrctl status
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
看到后台alert的日志报错如下:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
解决方案1:
lsnrctl stop 5分钟后,再lsnrctl start起来,问题解决了,是应用程序一直不停的连接数据库,占满了连接池导致的。
解决方案2:
查看oracle的连接数,果然为150
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
分析原因:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
修改配置文件:
- 1
- 2
- 3
- 4
- 5
改动连接数,并且写入参数文件
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
关闭重启oracle实例,启动就可以看到最大连接数已经变成了500,问题解决
问题解决。阅读全文
0 0
- ORA-12537: TNS:connection closed连接关闭,Oracle报错处理
- Oracle连接关闭分析 Diagnosing the ORA-12537: TNS: connection closed error
- ORA-12537: TNS:connection closed
- ORA-12537: TNS: connection closed
- ORA-12537: TNS:connection closed
- ORA-12537: TNS:connection closed
- ORA-12537: TNS:connection closed
- ORA-12537: TNS:connection closed
- sqlplus连接oracle12c集群报错:ORA-12537: TNS:connection closed
- 监听报错 TNS-00525: Insufficient privilege for operation 11gR2 + 连接报错ORA-12537: TNS:connection closed
- Oracle 11gR2 RAC 数据库不能连接(ORA-12537: TNS:connection closed)的解决
- Oracle 11gR2 RAC 数据库不能连接(ORA-12537: TNS:connection closed)的解决
- Oracle 11gR2 RAC 数据库不能连接(ORA-12537: TNS:connection closed)的解决
- Oracle 11gR2 RAC 数据库不能连接(ORA-12537: TNS:connection closed)的解决
- Oracle Study之--ORA-12537(TNS:connection closed) 错误案例
- TNS-12537: TNS:connection closed
- 11G RAC 权限不对登陆时遇到监听报错:ORA-12537 TNS:connection closed/TNS-12518
- TNS-12547: TNS:lost contact TNS-12537: TNS:connection closed as a result of ORA-609
- Caused by: java.lang.UnsupportedOperationException: Can't convert to dimension: type=0x1
- Android源码解析之Dalvik虚拟机的启动过程分析
- sphinx根据python注释生成文档
- 笔记45 | 代码性能优化建议[转]
- Android中TextView中部分文字有不同颜色的实现
- ORA-12537: TNS:connection closed连接关闭,Oracle报错处理
- 【Scikit-Learn 中文文档】内核近似
- Linux下" >/dev/null 2>&1 "相关知识说明
- JDK 9 发布仅数月,为何在生产环境中却频遭嫌弃?
- JZOJ 5489. 【清华集训2017模拟11.28】海明距离
- mybatis
- 前缀表达式
- 【Scikit-Learn 中文文档】随机投影
- thinkphp将excel 数据导入数据库表phpexce