OERR: ORA-12519 TNS:no appropriate service handler found
来源:互联网 发布:直通车优化助手 编辑:程序博客网 时间:2024/05/16 10:41
今天下午,开发人员突然说不能连接数据库了,提示相关的错误
OERR: ORA-12519 TNS:no appropriate service handler found
客户端连接间歇性失败,报错ORA-12519
Cause: the listener could not find any available service handlers that are
appropriate for the client connection.
Action: run "lsnrctl services" to ensure that the instance(s) have registered
with the listener, and are accepting connections. 检查lsnrctl service ,instance已经注册,
状态显示ready时,可以连接。
When the listener believes the current number of connections has reached maximum load,
it may set the state of the service handler for an instance to "blocked" and begin refusing
incoming client connections with either of the following errors: ora-12519 or ora-12516
采用服务动态注册的方式,由PMON 通过SERVICE_UPDATE 来得到目前连接情况,但SERVICE_UPDATE 有时间间隔,
所以,listener显示的连接数和当前实际的连接数可能不同。
查询解决方法:
查看一下数据库现有的进程数,是否已经达到参数processes的大小。
1.select count(*) from v$process; 取得数据库目前的进程数。
2.select value from v$parameter where name = 'processes'; 取得进程数的上限。
3.如已达到上限,修改initSID.ora中的processes的大小。
4.重新启动数据库到nomount状态下,执行create spfile from pfile; 并startup open。
查询数据库自启动以来最大的并发数量
select * from v$license
------ end -------
- OERR: ORA-12519 TNS:no appropriate service handler found
- OERR: ORA-12519 TNS:no appropriate service handler found
- OERR: ORA-12519 TNS:no appropriate service handler found
- OERR: ORA-12519 TNS:no appropriate service handler found
- OERR: ORA-12519 TNS:no appropriate service handler found
- ORA-12519、TNS-12519: TNS:no appropriate service handler found
- ORA-12519: TNS:no appropriate service handler found 解决
- ORA-12519: TNS:no appropriate service handler found
- ORA-12519 TNS:no appropriate service handler found
- ORA-12519: TNS:no appropriate service handler found 解决
- ORACLE:出错 ORA-12519, TNS:no appropriate service handler found
- ORA-12519: TNS:no appropriate service handler found 解决
- ORA-12519, TNS:no appropriate service handler found
- ORA-12519, TNS:no appropriate service handler found
- ORA-12519: TNS:no appropriate service handler found 解决
- ORA-12519:TNS:no appropriate service handler found 的解决方法
- ORA-12519:TNS:no appropriate service handler found 解决
- ORA-12519: TNS:no appropriate service handler found 解决
- 接口隔离原则(ISP)
- Apache HTTP Server 'ap_pregsub()' Function Local Privilege Escalation Vulnerability
- 原理图学习(点读笔调试)
- Android编程之横屏竖屏
- web1.0和web2.0
- OERR: ORA-12519 TNS:no appropriate service handler found
- Sencha touch 对store操作心得——Sencha Touch 数据层篇 Store
- Oracle 存储过程
- C#编写基于.Net IOCP的高性能服务器
- Citrix Provisioning Services 'streamprocess.exe' Component Remote Code Execution Vulnerability
- 玩转pandaboard之初体验
- Linux主机驱动与外设驱动分离思想--宋老师的文章学习
- 使用var关键字定义变量是一个好习惯
- 走近Cortex-M3(3)--寄存器知识