oracle实例无法启动，已启动服务器会死机

显示全部楼层 · 2010-5-13 09:34:23

在Windows Server 2003的服务中启动Oralceservicesid时，无法启动，提示错误为：“无法启动OracleServicesid”.服务并未返回错误，这可能是windows内部错误或服务内部错误，如果问题持续存在，请与系统管理员联系”的弹出框。
oracle 日志文件如下：
Dump file d:\oracle\admin\ora92\bdump\alert_ora92.log
Mon Feb 01 13:36:02 2010
ORACLE V9.2.0.6.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Mon Feb 01 13:36:02 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.6.0.
System parameters with non-default values:
processes
= 150
timed_statistics = TRUE
shared_pool_size = 301989888
sga_max_size
= 1603349612
large_pool_size
= 8388608
java_pool_size = 33554432
control_files
= D:\oracle\oradata\ora92\CONTROL01.CTL, D:\oracle\oradata\ora92\CONTROL02.CTL, D:\oracle\oradata\ora92\CONTROL03.CTL
db_block_size
= 8192
db_cache_size
= 1082130432
compatible
= 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain
=
instance_name
= ora92
dispatchers
= (PROTOCOL=TCP) (SERVICE=ora92XDB)
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\ora92\bdump
user_dump_dest = D:\oracle\admin\ora92\udump
core_dump_dest = D:\oracle\admin\ora92\cdump
sort_area_size = 524288
db_name
= ora92
open_cursors
= 300
star_transformation_enabled= FALSE
query_rewrite_enabled= FALSE
pga_aggregate_target = 403701760
aq_tm_processes
= 1
PMON started with pid=3
DBW0 started with pid=4
LGWR started with pid=5
CKPT started with pid=6
SMON started with pid=7
RECO started with pid=8
CJQ0 started with pid=9
QMN0 started with pid=10
Mon Feb 01 13:36:06 2010
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Feb 01 13:36:07 2010
alter database mount exclusive

有没有办法启动数据库库后导出数据文件？

千问 · 2010-5-13 09:34:23

没有启动，谈何导出。
你的日志后面还有信息么

千问 · 2010-5-13 09:34:23

请去你的ORACLE_BASE/admin/orcl/bdump/alert_orcl.log
把alert_sid.log文件拷贝上来

千问 · 2010-5-13 09:34:23

日志后面没有其他信息，几次重启但在日志写出来的同样的内容

千问 · 2010-5-13 09:34:23

手动一步一步启动，看看

千问 · 2010-5-13 09:34:23

set ORACLE_SID=
sqlplus / as sysdba
startup mount;
alter database open;
看过程中有没有问题。