ORA-00020:maximum number of processes (500) exceeded 错误解决方法
来源:互联网 发布:苹果手机数据恢复软件免费版 编辑:程序博客网 时间:2024/05/22 01:45
今天刚以上收到了系统预警短信,是OA的数据库系统,登录到服务器上,发现链接数据库报错。
[Oracle@oadb ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 21 10:38:28 2015Copyright (c) 1982, 2013, Oracle. All rights reserved.ERROR:ORA-00020: maximum number of processes (500) exceeded
解决方案:
在系统空闲时,修改系统参数,重启数据库。
SQL> alter system set processes=1000 scope=spfile; SQL>SHUTDOWN IMMEDIATE; SQL>STARTUP;
附录:
select count(*) from v$process --当前的连接数select value from v$parameter where name = 'processes' --数据库允许的最大连接数--查看当前有哪些用户正在使用数据SELECT osuser, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine from v$session a, v$sqlarea bwhere a.sql_address =b.address order by cpu_time/executions desc;
阅读全文
0 0
- ORA-00020:maximum number of processes (500) exceeded 错误解决方法
- ORA-00020:maximum number of processes (150) exceeded 错误解决方法
- ORA-00020:maximum number of processes (150) exceeded 错误解决方法
- ORA-00020: maximum number of processes (%s) exceeded 的解决方法
- ORA-00020: maximum number of processes (%s) exceeded 的解决方法
- 解决ORA-00020:maximum number of processes (150) exceeded 错误
- 记录一些意外:ORA-00020:maximum number of processes (1500) exceeded 错误解决方法
- ORA-00020: maximum number of processes (500) exceeded
- ORA-00020: maximum number of processes (%s) exceeded
- ORA-00020: maximum number of processes (%s) exceeded问题解决过程
- ORA-00020: maximum number of processes (150) exceeded
- ORA-00020: maximum number of processes (150) exceeded
- ORA-00020: maximum number of processes (150) exceeded
- ORA-00020: maximum number of processes (2000) exceeded
- ORA-00020: maximum number of processes (150) exceeded
- ORA-00020: maximum number of processes (1000) exceeded 故障一列
- ASM 异常 ORA-00020: maximum number of processes (100) exceeded
- ORA-00020: maximum number of processes (150) exceeded
- “封装”的简单实现
- MySQL数据库TDSQL架构分析及采用策略扩容流程
- LeetCode--Insert Interval
- Android DiskLruCache完全解析,硬盘缓存的最佳方案
- 一个实例讲解fastbins上的堆利用
- ORA-00020:maximum number of processes (500) exceeded 错误解决方法
- EhCache缓存介绍
- Spring-boot中读取config配置文件的两种方式
- SD卡驱动理论篇
- DC学院数据分析师(入门)学习笔记----基于网站API抓取《摔跤吧!爸爸》的豆瓣评分情况
- riscv安装tools的时候出现gitclone错误
- 几个常用的 Git 高级命令
- i++与++i的区别
- WebApi系列~开放的CORS,跨域资源访问对所有人开放