ORA-12500:监听进程保留连接失败

[aalan]

有时候能连上，大多数时候连不上，有很多用户在连。现在该咋办呀？

[aalan]

以前在AIX上是好的，搬到win2000上就不行了，有关系吗？

[daydayupliq]

数据库是什么版本呢？

[aalan]

数据库是8.1.7

[daydayupliq]

ORA-12500: TNS:listener failed to start a dedicated server process


Cause: The process of starting up a dedicated server process failed. The executable could not be found or the environment may be set up incorrectly.

Action: Turn on tracing at the ADMIN level and reexecute the operation. Verify that the ORACLE Server executable is present and has execute permissions enabled. Ensure that the ORACLE environment is specified correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being called may not be installed on the local hard drive. Please check that the correct Protocol Adapter are successfully linked. If error persists, contact Oracle Customer Support.
另外：
在别处查到：
ORA-12500, 00000, "TNS:listener failed to bequeath connection"
Cause: The nsbequeath() API failed to pass a handle to child.
Action: Check the SID and privileges for the user.

[逢桥夜泊]

查看listener.ora 和 tnsnames.ora

[shouym]

连接进程太多了，超过设定的数量

[datafrog]

可能是你的sga区分配有问题，给的太大系统不能管理，导致连上数据库，你适当的更改sga区，不要太大了，在没有达到你给你上限的时候就连不上的

[xieyongan]

适当调整SGA

[daydayupliq]

实际是如何解决的呢？
谢谢！