ora-12500 : TNS:监听程序无法启动专用服务器进程
平台：
windows 2000 server
oracle 817
错误：
ora-12500 : TNS:监听程序无法启动专用服务器进程
这个错误是在TNsListener、oracleService已经启动的情况下出现的，查看服务的属性，可以看到状态是已启动.
查看操作系统事件日志，事件ID=7024 描述：
OracleServiceSES 服务因 183 服务性错误而停止。
应用程序日志：
事件 ID ( 0 )的描述(在资源( OracleServiceSes )中)无法找到。本地计算机可能没有必要的注册信息或消息 DLL 文件来从远端计算机显示消息。部分事件包含了下列信息: OracleServiceSes error: 183, CreateFileMapping.
请问是什么原因？
问题点数：50、回复次数：7Top
1 楼awu306（awu）回复于 2005-05-20 10:29:38 得分 0
进一步描述：
如果手动重启oracle Services,可以正常连接，但过了一、两天后又会再次发生这种情况Top
2 楼chinagaoyang（dvcd）回复于 2005-05-20 10:53:25 得分 10
关注
Top
3 楼cxn0808（cxn0808）回复于 2005-05-20 12:42:28 得分 10
查看alterSID.log文件，是否记录异常Top
4 楼awu306（awu）回复于 2005-05-20 14:20:45 得分 0
没有什么错误信息。 我上次修改过init文件的sort_area_size等参数，是不是以这有关？Top
5 楼zsfww1205（努力学习oracle）回复于 2005-05-20 14:27:51 得分 20
好象和最大连接进程数有关，你看看
Top
6 楼awu306（awu）回复于 2005-05-20 15:48:43 得分 0
这是最近一次出错前和重启服务后的全部日志信息： 我看不出有什么异常的地方
Fri May 20 15:07:45 2005
Thread 1 advanced to log sequence 13733
Current log# 2 seq# 13733 mem# 0: D:\ORACLE\ORADATA\SES\REDO02.LOG
Fri May 20 15:07:45 2005
ARC0: Beginning to archive log# 1 seq# 13732
ARC0: Completed archiving log# 1 seq# 13732
Dump file D:\oracle\admin\ses\bdump\sesALRT.LOG
Fri May 20 15:41:54 2005
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 1000
shared_pool_size = 92428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = D:\oracle\oradata\ses\control01.ctl, D:\oracle\oradata\ses\control02.ctl, D:\oracle\oradata\ses\control03.ctl
db_block_buffers = 192885
db_block_size = 8192
compatible = 8.1.0
log_archive_start = TRUE
log_archive_dest_1 = location=D:\oracle\oradata\ses\archive
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = ses
service_names = ses
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 965536
sort_area_retained_size = 965536
db_name = ses
open_cursors = 300
os_authent_prefix =
utl_file_dir = D:\oracle\oradata\ses
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = D:\oracle\admin\ses\bdump
user_dump_dest = D:\oracle\admin\ses\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Fri May 20 15:41:57 2005
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=14
Fri May 20 15:41:58 2005
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri May 20 15:41:58 2005
ARC0: Archival started
Fri May 20 15:41:58 2005
alter database mount exclusive
Fri May 20 15:42:04 2005
Successful mount of redo thread 1, with mount id 2656006156.
Fri May 20 15:42:04 2005
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri May 20 15:42:04 2005
alter database open
Beginning crash recovery of 1 threads
Fri May 20 15:42:05 2005
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 13733 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\SES\REDO02.LOG
Fri May 20 15:42:05 2005
Thread recovery: finish rolling forward thread 1
Thread recovery: 516 data blocks read, 475 data blocks written, 1768 redo blocks read
Crash recovery completed successfully
Fri May 20 15:42:05 2005
Thread 1 advanced to log sequence 13734
Thread 1 opened at log sequence 13734
Current log# 3 seq# 13734 mem# 0: D:\ORACLE\ORADATA\SES\REDO01.LOG
Successful open of redo thread 1.
Fri May 20 15:42:06 2005
SMON: enabling cache recovery
Fri May 20 15:42:06 2005
ARC0: Beginning to archive log# 2 seq# 13733
ARC0: Completed archiving log# 2 seq# 13733
Fri May 20 15:42:06 2005
SMON: enabling tx recovery
Fri May 20 15:42:16 2005
Completed: alter database open
Top
7 楼zhangqingeming（yanlo）回复于 2005-07-12 19:27:39 得分 10
让oracle service 自动启动．Top
相关问题
- 求救！ora-12500:TNS监听程序无法启动服务器进程
- ora-12500:TNS 监听程序无法启动专用服务器进程
- ORA-12500: TNS: 监听程序无法启动专用服务器进程
- ★★“ORA:12541:TNS 没有监听器” 的问题★★
- ORA－12541，tns，没有监听器。。。这个是什么错误啊？？？急急急！！！
- [Oracle][ODBC][Ora]ORA-12541: TNS:没有监听器是什么错误,如何解决?
- ORA-12500 : TNS监听程序无法启动专用服务器进程~ 急 帮个忙哦
- 如何查看oracle的监听进程？
- ORA-12541: TNS:没有监听器？？
- ORA-12541: TNS: 没有监听器
