求助!ORACLE 无法启动问题,有启动日志。

[复制链接]
查看11 | 回复4 | 2006-9-4 01:02:51 | 显示全部楼层 |阅读模式
Dump file F:\oracle\admin\hnyd\bdump\hnydALRT.LOG
Sat Sep 16 09:51:35 2006
ORACLE V9.0.1.1.1 - Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 9.0.1.1.1.
System parameters with non-default values:
processes
= 400
timed_statistics = TRUE
shared_pool_size = 117440512
large_pool_size
= 48097152
java_pool_size = 58720256
control_files
= F:\oracle\oradata\hnyd\CONTROL01.CTL, F:\oracle\oradata\hnyd\CONTROL02.CTL, F:\oracle\oradata\hnyd\CONTROL03.CTL
db_block_size
= 4096
db_cache_size
= 645922816
compatible
= 9.0.0
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain
=
instance_name
= hnyd
dispatchers
= (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = F:\oracle\admin\hnyd\bdump
user_dump_dest = F:\oracle\admin\hnyd\udump
core_dump_dest = F:\oracle\admin\hnyd\cdump
sort_area_size = 4194304
db_name
= hnyd
open_cursors
= 600
ifile
= F:\oracle\admin\hnyd\pfile\init.ora
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
Sat Sep 16 09:51:37 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Sep 16 09:51:39 2006
alter database mount exclusive
Sat Sep 16 09:51:41 2006
ORA-214 signalled during: alter database mount exclusive...
Dump file F:\oracle\admin\hnyd\bdump\hnydALRT.LOG
Sat Sep 16 10:01:48 2006
ORACLE V9.0.1.1.1 - Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 9.0.1.1.1.
System parameters with non-default values:
processes
= 400
timed_statistics = TRUE
shared_pool_size = 117440512
large_pool_size
= 48097152
java_pool_size = 58720256
control_files
= F:\oracle\oradata\hnyd\CONTROL01.CTL, F:\oracle\oradata\hnyd\CONTROL02.CTL, F:\oracle\oradata\hnyd\CONTROL03.CTL
db_block_size
= 4096
db_cache_size
= 645922816
compatible
= 9.0.0
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain
=
instance_name
= hnyd
dispatchers
= (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = F:\oracle\admin\hnyd\bdump
user_dump_dest = F:\oracle\admin\hnyd\udump
core_dump_dest = F:\oracle\admin\hnyd\cdump
sort_area_size = 4194304
db_name
= hnyd
open_cursors
= 600
ifile
= F:\oracle\admin\hnyd\pfile\init.ora
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
Sat Sep 16 10:01:50 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Sep 16 10:01:52 2006
alter database mount exclusive
Sat Sep 16 10:01:54 2006
ORA-214 signalled during: alter database mount exclusive...
Sat Sep 16 10:17:59 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 1
Sat Sep 16 10:18:02 2006
alter database close normal
ORA-1507 signalled during: alter database close normal...
Dump file F:\oracle\admin\hnyd\bdump\hnydALRT.LOG
Sat Sep 16 10:18:16 2006
ORACLE V9.0.1.1.1 - Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 9.0.1.1.1.
System parameters with non-default values:
processes
= 400
timed_statistics = TRUE
shared_pool_size = 117440512
large_pool_size
= 48097152
java_pool_size = 58720256
control_files
= F:\oracle\oradata\hnyd\CONTROL01.CTL, F:\oracle\oradata\hnyd\CONTROL02.CTL, F:\oracle\oradata\hnyd\CONTROL03.CTL
db_block_size
= 4096
db_cache_size
= 645922816
compatible
= 9.0.0
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS
remote_login_passwordfile= EXCLUSIVE
db_domain
=
instance_name
= hnyd
dispatchers
= (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
background_dump_dest = F:\oracle\admin\hnyd\bdump
user_dump_dest = F:\oracle\admin\hnyd\udump
core_dump_dest = F:\oracle\admin\hnyd\cdump
sort_area_size = 4194304
db_name
= hnyd
open_cursors
= 600
ifile
= F:\oracle\admin\hnyd\pfile\init.ora
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
Sat Sep 16 10:18:19 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Sep 16 10:18:20 2006
alter database mount exclusive
Sat Sep 16 10:18:23 2006
ORA-214 signalled during: alter database mount exclusive...
Dump file F:\oracle\admin\hnyd\bdump\hnydALRT.LOG
Sat Sep 16 10:34:34 2006
ORACLE V9.0.1.1.1 - Production vsnsta=0
vsnsql=10 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 9.0.1.1.1.
回复

使用道具 举报

千问 | 2006-9-4 01:02:51 | 显示全部楼层
没用过这么低的9i版本
回复

使用道具 举报

千问 | 2006-9-4 01:02:51 | 显示全部楼层
主机硬件环境?出错前作了什么操作?系统里还跑了什么应用没有?
回复

使用道具 举报

千问 | 2006-9-4 01:02:51 | 显示全部楼层
你可以先把操作系统重新启动一下,看看数据库能否启动
回复

使用道具 举报

千问 | 2006-9-4 01:02:51 | 显示全部楼层
是Win2000 server + Oracle 9 i 环境,同时报控制文件与日志文件损坏,有有效的恢复方法吗?恳求解答。多谢!
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行