我们的Oracle系统 在运行一段时间后 客户端会登录不上,报ora-12500错误,我们的服务器的listener.log的内容如下,请高手指点一下该如何处理:
25-12月-2010 15:07:18 * (CONNECT_DATA=(SID=jsorcl)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\EasySCM\Machin.exe)(HOST=YCLCK15)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.10.213)(PORT=1493)) * establish * jsorcl * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12549: TNS:operating system resource quota exceeded
TNS-12560: TNS:protocol adapter error
TNS-00519: Operating system resource quota exceeded
32-bit Windows Error: 8: Exec format error
25-12月-2010 15:07:20 * (CONNECT_DATA=(SID=jsorcl)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\EasySCM\Machin.exe)(HOST=YCLCK15)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.10.213)(PORT=1494)) * establish * jsorcl * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12549: TNS:operating system resource quota exceeded
TNS-12560: TNS:protocol adapter error
TNS-00519: Operating system resource quota exceeded
32-bit Windows Error: 8: Exec format error
25-12月-2010 15:07:18 * (CONNECT_DATA=(SID=jsorcl)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\EasySCM\Machin.exe)(HOST=YCLCK15)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.10.213)(PORT=1493)) * establish * jsorcl * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12549: TNS:operating system resource quota exceeded
TNS-12560: TNS:protocol adapter error
TNS-00519: Operating system resource quota exceeded
32-bit Windows Error: 8: Exec format error
25-12月-2010 15:07:20 * (CONNECT_DATA=(SID=jsorcl)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\EasySCM\Machin.exe)(HOST=YCLCK15)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.10.213)(PORT=1494)) * establish * jsorcl * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12549: TNS:operating system resource quota exceeded
TNS-12560: TNS:protocol adapter error
TNS-00519: Operating system resource quota exceeded
32-bit Windows Error: 8: Exec format error
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.
Cause: The current user has exceeded the allotted resource assigned in the operating system.
Action: Acquire more operating system resource, or perform a different function.
session_per_user 加大你的profile里的这个值的大小,试下。。
---------查询session_per_user的大小
select *
from dba_profiles
where profile = (select profile from dba_users where username = '')
and resource_name = 'SESSIONS_PER_USER';
select current_utilization from v$resource_limit where resource_name='process';select count(*) from v$process