没有合适的资源?快使用搜索试试~ 我知道了~
Oracle_ORA-12518故障_处理
4星 · 超过85%的资源 需积分: 46 44 下载量 97 浏览量
2012-09-27
09:39:13
上传
评论
收藏 357KB PDF 举报
温馨提示
试读
7页
Oracle_ORA-12518故障_处理,希望在此与大家分享,能够在实际的工作中提高解决问题的能力
资源推荐
资源详情
资源评论
12-3-8 My Oracle Support | 知浏览器 | 550859.1
1/7https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigato…
TROUBLESHOOTING GUIDE TNS-12518 TNS listener could not hand off client connection [ID 550859.1]
修改时 29-SEP-2011 类型 TROUBLESHOOTING 状态 PUBLISHED
In this Document
Purpose
Last Review Date
Incion fo he Reade
Troubleshooting Details
Section I: Steps to approach ORA-12518/TNS-12518 Error:
Section II: Commonly Known Errors:
Error: 32: Broken pipe
Error: 11: Resource temporarily unavailable
Error: 12: Not enough space
Error: Connection Pooling limit reached
Error: 2: No such file or directory
Section III: Errors Specific to Windows
Error: 233: Unknown error
Error: 54: Unknown error
Applies to:
Oracle Net Services - Version: 9.2.0.1.0 to 11.2.0.3 - Release: 9.2 to 11.2
Information in this document applies to any platform.
Purpose
This article discusses about how to approach ORA-12518/TNS-12518 and troubleshoot it for the resolution.
Last Review Date
January 29, 2008
Incion fo he Reade
A Toblehooing Gide i poided o ai in debgging a pecific ie. When poible, diagnoic ool ae inclded in he docmen o ai
in oblehooing.
Troubleshooting Details
Section I: Steps to approach ORA-12518/TNS-12518 Error:
ORA-12518/TNS-12518 indicates a problem while listener hands off the client connection to the server process or dispatcher process.TNS-12518 is
logged in the listener log. The client might receive ORA-12518 or some other disconnection errors like ORA-12537. Once TNS-12518 is noted in the
listener log, follow the below steps to approach and resolve this error.
Let us have a small discussion about how actually database connections are made:
In Dedicated mode, database client contacts listener and supplies the SERVICE NAME of the database. Then listener spawns a dedicated server
process and hands off the client connection to this dedicated server process. TNS-12518 indicates a problem while handing off the client connection to
the server process.
In Shared Server mode, database client contacts listener and supplies the SERVICE NAME of the database. Then listener hands off the client
connection to one of the dispatcher configured for that service. TNS-12518 indicates a problem while handing off the client connection to the dispatcher
server process.
Though this error is logged in the listener log, the listener is just the messenger, ORA-12518/TNS-12518 is mostly related to RDBMS and OS
resources.
Step 1. Is listener version compatible to the database
Check if you are using compatible listener version for your database version.
If the database is 8i then use 8i or 9i listeners only. 10g listeners are not compatible to work with 8i databases.
For 9i databases, 9i or 10g listeners can be used.
For 10g databases, only 10g listeners can be used.
资源评论
- kongkongtz2013-04-14增加登录用户数,但32位跟64位一个可以,一个不行
- 小鬼LP2013-09-05按照这个反正我是没有解决,而且,这种方法只针对于32位的系统临时解决使用。不是长久之计。
xtjc365
- 粉丝: 0
- 资源: 6
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 我的自己111111111
- 判断一个数是否为质数以及通过C语言实现.docx
- IPv4-HEADER-03 测试数据
- 高级网络人才培训专家-X00070005 第32章 ISDN和DCC
- 高级网络人才培训专家-X00070004 第31章 配置帧中继
- IPv4-HEADER-02测试数据
- tensorflow-2.6.2-cp38-cp38-manylinux2010-x86-64.whl
- tensorflow-2.6.2-cp37-cp37m-win-amd64.whl
- RV180-Firmware-1.0.5.4.img
- 粒子群算法.docx 粒子群算法(Particle Swarm Optimization,PSO)是一种优化算法,受到鸟群或鱼
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功