下面是日志的信息,不知道大家有没有能解决或者提示的Mon Jun 11 18:11:05 2007
Restarting dead background process QMN0
QMN0 started with pid=9
Dump file d:\oracle92\admin\qa212\bdump\alert_qa212.log
Mon Jun 11 21:06:32 2007
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Mon Jun 11 21:06:32 2007
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:\oracle92\oradata\qa212\CONTROL01.CTL, e:\oracle92\oradata\qa212\CONTROL02.CTL, e:\oracle92\oradata\qa212\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 = qa212
dispatchers = (PROTOCOL=TCP) (SERVICE=qa212XDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle92\admin\qa212\bdump
user_dump_dest = D:\oracle92\admin\qa212\udump
core_dump_dest = D:\oracle92\admin\qa212\cdump
sort_area_size = 524288
db_name = qa212
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
Mon Jun 11 21:06:50 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Jun 11 21:06:57 2007
alter database mount exclusive
Mon Jun 11 21:07:07 2007
Successful mount of redo thread 1, with mount id 1737908337.
Mon Jun 11 21:07:07 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Jun 11 21:07:07 2007
alter database open
Mon Jun 11 21:07:11 2007
Beginning crash recovery of 1 threads
Mon Jun 11 21:07:11 2007
Started first pass scan
Mon Jun 11 21:07:12 2007
Completed first pass scan
4048 redo blocks read, 67 data blocks need recovery
Mon Jun 11 21:07:12 2007
Started recovery at
Thread 1: logseq 276, block 26592, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 276 Reading mem 0
Mem# 0 errs 0: E:\ORACLE92\ORADATA\QA212\REDO02.LOG
Mon Jun 11 21:07:13 2007
Ended recovery at
Thread 1: logseq 276, block 30640, scn 0.31416698
67 data blocks read, 66 data blocks written, 4048 redo blocks read
Crash recovery completed successfully
Mon Jun 11 21:07:14 2007
Thread 1 advanced to log sequence 277
Thread 1 opened at log sequence 277
Current log# 3 seq# 277 mem# 0: E:\ORACLE92\ORADATA\QA212\REDO03.LOG
Successful open of redo thread 1.
Mon Jun 11 21:07:15 2007
SMON: enabling cache recovery
Mon Jun 11 21:07:19 2007
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Mon Jun 11 21:07:19 2007
SMON: enabling tx recovery
Mon Jun 11 21:07:19 2007
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Restarting dead background process QMN0
QMN0 started with pid=9
Dump file d:\oracle92\admin\qa212\bdump\alert_qa212.log
Mon Jun 11 21:06:32 2007
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Mon Jun 11 21:06:32 2007
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:\oracle92\oradata\qa212\CONTROL01.CTL, e:\oracle92\oradata\qa212\CONTROL02.CTL, e:\oracle92\oradata\qa212\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 = qa212
dispatchers = (PROTOCOL=TCP) (SERVICE=qa212XDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle92\admin\qa212\bdump
user_dump_dest = D:\oracle92\admin\qa212\udump
core_dump_dest = D:\oracle92\admin\qa212\cdump
sort_area_size = 524288
db_name = qa212
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
Mon Jun 11 21:06:50 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Jun 11 21:06:57 2007
alter database mount exclusive
Mon Jun 11 21:07:07 2007
Successful mount of redo thread 1, with mount id 1737908337.
Mon Jun 11 21:07:07 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Jun 11 21:07:07 2007
alter database open
Mon Jun 11 21:07:11 2007
Beginning crash recovery of 1 threads
Mon Jun 11 21:07:11 2007
Started first pass scan
Mon Jun 11 21:07:12 2007
Completed first pass scan
4048 redo blocks read, 67 data blocks need recovery
Mon Jun 11 21:07:12 2007
Started recovery at
Thread 1: logseq 276, block 26592, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 276 Reading mem 0
Mem# 0 errs 0: E:\ORACLE92\ORADATA\QA212\REDO02.LOG
Mon Jun 11 21:07:13 2007
Ended recovery at
Thread 1: logseq 276, block 30640, scn 0.31416698
67 data blocks read, 66 data blocks written, 4048 redo blocks read
Crash recovery completed successfully
Mon Jun 11 21:07:14 2007
Thread 1 advanced to log sequence 277
Thread 1 opened at log sequence 277
Current log# 3 seq# 277 mem# 0: E:\ORACLE92\ORADATA\QA212\REDO03.LOG
Successful open of redo thread 1.
Mon Jun 11 21:07:15 2007
SMON: enabling cache recovery
Mon Jun 11 21:07:19 2007
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Mon Jun 11 21:07:19 2007
SMON: enabling tx recovery
Mon Jun 11 21:07:19 2007
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Wed Mar 07 09:41:34 2007
alter database rename global_name to qa212
Completed: alter database rename global_name to qa212
Wed Mar 07 09:41:36 2007
ALTER TABLESPACE TEMP ADD TEMPFILE 'e:\oracle92\oradata\qa212\TEMP01.DBF' REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'e:\oracle92\or
Wed Mar 07 09:41:37 2007
alter database character set INTERNAL_CONVERT ZHS16GBK
Wed Mar 07 09:41:50 2007
Updating character set in controlfile to ZHS16GBK
SYS.SNAP$ (REL_QUERY) - CLOB representation altered
SYS.METASTYLESHEET (STYLESHEET) - CLOB representation altered
SYS.EXTERNAL_TAB$ (PARAM_CLOB) - CLOB representation altered
XDB.XDB$RESOURCE (SYS_NC00027$) - CLOB representation altered
ODM.ODM_PMML_DTD (DTD) - CLOB representation altered
OE.WAREHOUSES (SYS_NC00003$) - CLOB representation altered
PM.ONLINE_MEDIA (SYS_NC00042$) - CLOB representation altered
PM.ONLINE_MEDIA (SYS_NC00062$) - CLOB representation altered
PM.ONLINE_MEDIA (PRODUCT_TEXT) - CLOB representation altered
PM.ONLINE_MEDIA (SYS_NC00080$) - CLOB representation altered
PM.PRINT_MEDIA (AD_SOURCETEXT) - CLOB representation altered
PM.PRINT_MEDIA (AD_FINALTEXT) - CLOB representation altered
Completed: alter database character set INTERNAL_CONVERT ZHS1
Wed Mar 07 09:42:06 2007
alter database national character set INTERNAL_CONVERT AL16UTF16
Completed: alter database national character set INTERNAL_CON
Wed Mar 07 09:43:24 2007
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water = 1
Waiting for dispatcher 'D000' to shutdown
Wed Mar 07 09:48:33 2007
Giving up waiting for dispatchers and shared servers to die
Wed Mar 07 09:48:35 2007
ALTER DATABASE CLOSE NORMAL
Wed Mar 07 09:48:36 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Mar 07 09:48:39 2007
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1
Successful close of redo thread 1.
Wed Mar 07 09:48:43 2007
Completed: ALTER DATABASE CLOSE NORMAL
Wed Mar 07 09:48:43 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Mar 07 09:48:54 2007