ORA-12519: TNS:no appropriate service handler found 解决
来源:互联网 发布:php bootstrap 编辑:程序博客网 时间:2024/06/07 02:04
ORA-12519: TNS:no appropriate service handler found 解决
有时候连得上数据库,有时候又连不上.
可能是数据库上当前的连接数目已经超过了它能够处理的最大值.
select count(*) from v$process --当前的连接数select value from v$parameter where name = 'processes' --数据库允许的最大连接数
修改最大连接数:
alter system set processes = 300 scope = spfile;
重启数据库:
shutdown immediate;
startup;
--查看当前有哪些用户正在使用数据
SELECT osuser, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine
from v$session a, v$sqlarea b
where a.sql_address =b.address order by cpu_time/executions desc;
0 0
- 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 解决
- 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 解决
- 解决ORA-12519: TNS:no appropriate service handler found问题
- ORA-12519: TNS:no appropriate service handler found 解决
- Linux 下Oracle 手工create database 脚本和步骤
- 292 Nim Game
- 15 选择正确的线程模型
- @PathVariable和@RequestParam
- 1043. Is It a Binary Search Tree (25)
- ORA-12519: TNS:no appropriate service handler found 解决
- 【SSH项目实战】国税协同平台-24.条件查询分析与实现
- 制作一个类似登录界面的窗体(无最大最小化栏)
- 16 从EventLoop取消注册和重新注册
- iOS 8.0 之后相册授权直接跳转到设置
- 医药采购之采购单修改
- android屏幕适配
- ipcs查看消息队列命令
- Android之Activity生命周期