我的oracle是装在win2000上的，版本是9.2.0.0，我想把管理db的instance服务停掉，但是没有成功，该服务一直处于stopping状态，最后只能重启，但是重启后数据库再也起不来，报如下错：
ORA-01033: ORACLE initialization or shutdown in progress ，
以下是我的alert文件：
Tue Jul 13 23:59:03 2004
ORA-205 signalled during: alter database mount exclusive...
Shutting down instance (abort)
License high water mark = 3
Instance terminated by USER, pid = 1352
Dump file e:\oracle\admin\mistest1\bdump\alert_mistest1.log
Wed Jul 14 01:19:28 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Wed Jul 14 01:19:28 2004
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.1.0.
System parameters with non-default values:
processes
= 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size
= 8388608
java_pool_size = 33554432
control_files
= E:\oracle\oradata\MISTEST1\control01.ctl, E:\oracle\oradata\MISTEST1\control02.ctl, E:\oracle\oradata\MISTEST1\control03.ctl
db_block_size
= 8192
db_cache_size
= 25165824
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
= MISTEST1
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = E:\oracle\admin\MISTEST1\bdump
user_dump_dest = E:\oracle\admin\MISTEST1\udump
core_dump_dest = E:\oracle\admin\MISTEST1\cdump
sort_area_size = 524288
db_name
= MISTEST1
open_cursors
= 300
star_transformation_enabled= FALSE
query_rewrite_enabled= FALSE
pga_aggregate_target = 25165824
aq_tm_processes
= 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Jul 14 01:19:31 2004
alter database mount exclusive
Wed Jul 14 01:19:31 2004
ORA-09341: scumnt: unable to mount database
OSD-04400: 无法获取进程的内部信号
O/S-Error: (OS 183) Cannot create a file when that file already exists.
Wed Jul 14 01:19:31 2004
ORA-1102 signalled during: alter database mount exclusive...
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
Wed Jul 14 09:41:09 2004
alter database close normal
ORA-1507 signalled during: alter database close normal...
Dump file e:\oracle\admin\mistest1\bdump\alert_mistest1.log
Wed Jul 14 09:44:28 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Wed Jul 14 09:44:28 2004
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.1.0.
System parameters with non-default values:
processes
= 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size
= 8388608
java_pool_size = 33554432
control_files
= E:\oracle\oradata\MISTEST1\control01.ctl, E:\oracle\oradata\MISTEST1\control02.ctl, E:\oracle\oradata\MISTEST1\control03.ctl
db_block_size
= 8192
db_cache_size
= 25165824
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
= MISTEST1
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = E:\oracle\admin\MISTEST1\bdump
user_dump_dest = E:\oracle\admin\MISTEST1\udump
core_dump_dest = E:\oracle\admin\MISTEST1\cdump
sort_area_size = 524288
db_name
= MISTEST1
open_cursors
= 300
star_transformation_enabled= FALSE
query_rewrite_enabled= FALSE
pga_aggregate_target = 25165824
aq_tm_processes
= 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Jul 14 09:44:33 2004
alter database mount exclusive
Wed Jul 14 09:44:33 2004
ORA-09341: scumnt: unable to mount database
OSD-04400: 无法获取进程的内部信号
O/S-Error: (OS 183) Cannot create a file when that file already exists.
Wed Jul 14 09:44:33 2004
ORA-1102 signalled during: alter database mount exclusive...
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
Wed Jul 14 10:52:21 2004
alter database close normal
ORA-1507 signalled during: alter database close normal...
Dump file e:\oracle\admin\mistest1\bdump\alert_mistest1.log
Wed Jul 14 10:54:27 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Wed Jul 14 10:54:27 2004
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.1.0.
System parameters with non-default values:
processes
= 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size
= 8388608
java_pool_size = 33554432
control_files
= E:\oracle\oradata\MISTEST1\control01.ctl, E:\oracle\oradata\MISTEST1\control02.ctl, E:\oracle\oradata\MISTEST1\control03.ctl
db_block_size
= 8192
db_cache_size
= 25165824
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
= MISTEST1
job_queue_processes= 10
hash_join_enabled= TRUE
background_dump_dest = E:\oracle\admin\MISTEST1\bdump
user_dump_dest = E:\oracle\admin\MISTEST1\udump
core_dump_dest = E:\oracle\admin\MISTEST1\cdump
sort_area_size = 524288
db_name
= MISTEST1
open_cursors
= 300
star_transformation_enabled= FALSE
query_rewrite_enabled= FALSE
pga_aggregate_target = 25165824
aq_tm_processes
= 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Wed Jul 14 10:54:31 2004
alter database mount exclusive
Wed Jul 14 10:54:36 2004
Successful mount of redo thread 1, with mount id 4150713767.
Wed Jul 14 10:54:36 2004
Database mounted in Exclusive Mode.
ORA-1990 signalled during: alter database mount exclusive...
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
Wed Jul 14 11:33:34 2004
alter database close normal
ORA-1109 signalled during: alter database close normal...
|
