ORA-12519: TNS:no appropriate service handler found 解决
来源:互联网 发布:debian centos 编辑:程序博客网 时间:2024/05/17 02:04
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;
- 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 解决
- Sql plus命令报command not found的解决笔记
- 闲谈StringBuilder
- 找工作中常见的PHP面试题及答案(2)
- oracle 在一个存储过程中调用另一个返回游标的存储过程
- C#遍历ComboBox
- ORA-12519: TNS:no appropriate service handler found 解决
- Error: ShouldNotReachHere() [整理]
- SPUtility
- 在XCODE中开发Iphone/Ipad 使用sqlite的Data Core框架.
- 郁闷的时候偷着乐
- 对象序列化
- Shell技巧:提示行魔术
- java 内部类
- 注解