Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > body text

ORA-00020错误思考

WBOY
Release： 2016-06-07 16:44:40
Original
1139 people have browsed it

今天例行检查一个历史库DB，发现alert.log里面有一条ldquo;ORA-00020: maximum number of processes (150) exceededrdquo;，这

今天例行检查一个历史库DB，发现alert.log里面有一条“ORA-00020: maximum number of processes (150) exceeded”，这是一个低级且常见的错误！

主要原因：DB进程数目超过限制大小

因为DB是历史库数据，2011年在设置时考虑到安全，才设置150为最大，随后发邮件给开发，做再次提醒，除了应用访问外，，禁止TOAD,PLSQL等直连数据库

补充资料

1：Oracle官方文档解释

ORA-00020

2.正常DB该参数如果设置小了，有可能程序用户访问DB时会在登录时报如下报错：“ORA-12537: TNS:connection closed”

Oracle 11g 在RedHat Linux 5.8_x64平台的安装手册

Linux-6-64下安装Oracle 12C笔记

在CentOS 6.4下安装Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虚拟机中安装步骤

Debian 下 安装 Oracle 11g XE R2

本文永久更新链接地址：

linux

Related labels：
or database
source：php.cn
Previous article：Win7 64bit版本下安装Oracle 11g OS权限处理 Next article：查看Oracle 32位还是64位(x86 or x64)
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1899
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
10
2067
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1739
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1642
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1653
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template