本帖最后由 ccton 于 2012-5-14 14:24 编辑
数据库版本
SQL> select *from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE11.1.0.6.0Production
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 advanced to log sequence 27437
Thread 1 opened at log sequence 27437
Current log# 2 seq# 27437 mem# 0: E:\ORA_DATA\ORCL\REDO02.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC3: Becoming the heartbeat ARCH
Mon May 14 14:29:33 2012
SMON: enabling cache recovery
db_recovery_file_dest_size of 61440 MB is 33.60% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
Starting background process FBDA
Starting background process SMCO
Mon May 14 14:29:34 2012
FBDA started with pid=27, OS id=3196
Mon May 14 14:29:34 2012
SMCO started with pid=28, OS id=2020
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Mon May 14 14:29:35 2012
QMNC started with pid=29, OS id=3620
Mon May 14 14:29:44 2012
Completed: ALTER DATABASE OPEN
Mon May 14 14:34:26 2012
Starting background process CJQ0
Mon May 14 14:34:26 2012
CJQ0 started with pid=44, OS id=1964
Mon May 14 14:34:34 2012
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFF] [PC:0x7FFF65D0, {empty}]
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_p001_1280.trc:
ORA-07445: exception encountered: core dump [PC:0x7FFF65D0] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFF] [PC:0x7FFF65D0] [UNABLE_TO_READ] []
Mon May 14 14:34:35 2012
Trace dumping is performing id=[cdmp_20120514143435]
Mon May 14 14:35:10 2012
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFF] [PC:0x7FFF65D0, {empty}]
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_smon_1072.trc(incident=164712):
ORA-07445: exception encountered: core dump [PC:0x7FFF65D0] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFF] [PC:0x7FFF65D0] [UNABLE_TO_READ] []
ORA-12080: Buffer cache miss for IOQ batching
Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_164712\orcl_smon_1072_i164712.trc
Mon May 14 14:35:11 2012
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_pmon_2768.trc:
ORA-00474: SMON process terminated with error
PMON (ospid: 2768): terminating the instance due to error 474
Mon May 14 14:35:11 2012
ORA-1092 : opiodr aborting process unknown ospid (2400_1272)
Mon May 14 14:35:11 2012
ORA-1092 : opitsk aborting process
Mon May 14 14:35:12 2012
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_q002_3896.trc:
ORA-00474: SMON process terminated with error
Mon May 14 14:35:12 2012
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_q003_1220.trc:
ORA-00474: SMON process terminated with error
Mon May 14 14:35:12 2012
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_q000_3284.trc:
ORA-00474: SMON process terminated with error
ORA-1092 : opidrv aborting process Q002 ospid (2400_3896)
ORA-1092 : opidrv aborting process Q003 ospid (2400_1220)
ORA-1092 : opidrv aborting process Q000 ospid (2400_3284)
Mon May 14 14:35:12 2012
ORA-1092 : opidrv aborting process W000 ospid (2400_1992)
Mon May 14 14:35:13 2012
ORA-474 : opidrv aborting process S000 ospid (2400_2624)
Instance terminated by PMON, pid = 2768
orcl_p001_1280.trc 和orcl_smon_1072_i164712.trc
见附件
[attach]orcl_smon_1072_i164712.rar [/attach]
[attach]orcl_p001_1280.rar [/attach]
|