- 论坛徽章:
- 0
|
请帮忙看看！！是什么原因！
AIX日志：
# errpt -a | more
LABEL: SRC
IDENTIFIER: E18E984F
Date/Time: Fri Oct 10 03:52:29 BEIS
Sequence Number: 13770
Class: S
Type: PERM
Resource Name: SRC
Description
SOFTWARE PROGRAM ERROR
Probable Causes
APPLICATION PROGRAM
Failure Causes
SOFTWARE PROGRAM
Recommended Actions
PERFORM PROBLEM RECOVERY PROCEDURES
Standard input
Detail Data
SYMPTOM CODE
-256
SOFTWARE ERROR CODE
-9035
ERROR CODE
0
DETECTING MODULE
'srchevn.c'@line:'201'
FAILING MODULE
IBM.AuditRM
# vmstat 1 20
kthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
1 1 284128 3671 0 0 0 71 138 0 266 1115 449 3 1 92 5
0 0 284134 3665 0 0 0 0 0 0 238 2325 311 0 0 99 1
0 0 284134 3665 0 0 0 0 0 0 232 2313 297 0 0 99 0
0 0 284134 3665 0 0 0 0 0 0 236 2630 299 0 0 99 0
0 0 284134 3665 0 0 0 0 0 0 239 2324 323 0 0 98 1
0 0 284134 3663 0 0 0 0 0 0 270 2527 376 0 0 96 4
0 0 284134 3663 0 0 0 0 0 0 233 2318 301 0 0 99 0
0 0 284134 3663 0 0 0 0 0 0 235 2317 314 0 0 99 1
0 0 284135 3662 0 0 0 0 0 0 247 2391 332 0 0 99 1
0 0 284135 3662 0 0 0 0 0 0 232 2334 314 0 0 99 0
0 0 284135 3662 0 0 0 0 0 0 240 2323 313 0 0 99 0
0 0 284135 3662 0 0 0 0 0 0 231 2311 293 0 0 99 0
0 0 284135 3662 0 0 0 0 0 0 235 2322 303 0 0 99 0
0 0 284135 3662 0 0 0 0 0 0 251 2369 333 0 0 98 1
0 0 287818 257 0 2 0 281 518 0 343 6337 647 6 10 84 0
1 0 287820 255 0 0 0 0 0 0 273 3320 390 1 23 75 1
0 0 287820 238 0 0 0 0 0 0 374 2694 422 2 16 72 10
0 0 287820 238 0 0 0 0 0 0 244 2469 323 0 1 99 0
0 0 287823 235 0 0 0 0 0 0 336 3507 515 1 0 98 0
0 0 287823 235 0 0 0 0 0 0 238 2328 318 0 0 98 1
#
ORACLE日志：
Thu Oct 9 08:05:53 2003
Thread 1 advanced to log sequence 202
Current log# 3 seq# 202 mem# 0: /oracle/app/oracle/oradata/orcl/redo03.log
Current log# 3 seq# 202 mem# 1: /SBYW/oradata/orcl/redo031.rdo
Thu Oct 9 09:12:05 2003
Thread 1 advanced to log sequence 203
Current log# 1 seq# 203 mem# 0: /oracle/app/oracle/oradata/orcl/redo01.log
Current log# 1 seq# 203 mem# 1: /SBYW/oradata/orcl/redo011.rdo
Thu Oct 9 09:19:33 2003
Thread 1 advanced to log sequence 204
Current log# 2 seq# 204 mem# 0: /oracle/app/oracle/oradata/orcl/redo02.log
Current log# 2 seq# 204 mem# 1: /SBYW/oradata/orcl/redo021.rdo
Thu Oct 9 09:23:31 2003
Thread 1 advanced to log sequence 205
Current log# 3 seq# 205 mem# 0: /oracle/app/oracle/oradata/orcl/redo03.log
Current log# 3 seq# 205 mem# 1: /SBYW/oradata/orcl/redo031.rdo
Thu Oct 9 11:53:59 2003
Thread 1 advanced to log sequence 206
Current log# 1 seq# 206 mem# 0: /oracle/app/oracle/oradata/orcl/redo01.log
Current log# 1 seq# 206 mem# 1: /SBYW/oradata/orcl/redo011.rdo
Thu Oct 9 12:17:46 2003
Thread 1 advanced to log sequence 207
Current log# 2 seq# 207 mem# 0: /oracle/app/oracle/oradata/orcl/redo02.log
Current log# 2 seq# 207 mem# 1: /SBYW/oradata/orcl/redo021.rdo
Thu Oct 9 15:01:31 2003
Thread 1 advanced to log sequence 208
Current log# 3 seq# 208 mem# 0: /oracle/app/oracle/oradata/orcl/redo03.log
Current log# 3 seq# 208 mem# 1: /SBYW/oradata/orcl/redo031.rdo
Thu Oct 9 17:02:02 2003
Errors in file /SBYW/admin/orcl/udump/orcl_ora_41580.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
Thu Oct 9 17:02:04 2003
Errors in file /SBYW/admin/orcl/bdump/orcl_pmon_25418.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
Thu Oct 9 17:02:25 2003
LGWR: terminating instance due to error 472
Instance terminated by LGWR, pid = 30368
Thu Oct 9 17:15:21 2003
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 3
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 218103808
large_pool_size = 67108864
java_pool_size = 0
control_files = /SBYW/oradata/orcl/control01.ctl, /SBYW/oradata/orcl/control02.ctl, /SBYW/oradata/orcl/control03.ctl
db_block_size = 8192
db_cache_size = 318767104
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 = orcl
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /SBYW/admin/orcl/bdump
user_dump_dest = /SBYW/admin/orcl/udump
core_dump_dest = /SBYW/admin/orcl/cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 31457280
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
Thu Oct 9 17:15:23 2003
ALTER DATABASE MOUNT
Thu Oct 9 17:15:27 2003
Successful mount of redo thread 1, with mount id 1034716331.
Thu Oct 9 17:15:27 2003
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Oct 9 17:15:27 2003
ALTER DATABASE OPEN
Thu Oct 9 17:15:28 2003
Beginning crash recovery of 1 threads
Thu Oct 9 17:15:28 2003
Started first pass scan
Thu Oct 9 17:15:28 2003
Completed first pass scan
19970 redo blocks read, 3773 data blocks need recovery
Thu Oct 9 17:15:28 2003
Started recovery at
Thread 1: logseq 208, block 176625, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 208 Reading mem 0
Mem# 0 errs 0: /oracle/app/oracle/oradata/orcl/redo03.log
Mem# 1 errs 0: /SBYW/oradata/orcl/redo031.rdo
Thu Oct 9 17:15:41 2003
Completed redo application
Thu Oct 9 17:16:08 2003
Restarting dead background process QMN0
QMN0 started with pid=9
Thu Oct 9 17:16:17 2003
Ended recovery at
Thread 1: logseq 208, block 196595, scn 0.4989359
3773 data blocks read, 3773 data blocks written, 19970 redo blocks read
Crash recovery completed successfully
Thu Oct 9 17:16:18 2003
Thread 1 advanced to log sequence 209
Thread 1 opened at log sequence 209
Current log# 1 seq# 209 mem# 0: /oracle/app/oracle/oradata/orcl/redo01.log
Current log# 1 seq# 209 mem# 1: /SBYW/oradata/orcl/redo011.rdo
Successful open of redo thread 1.
Thu Oct 9 17:16:18 2003
SMON: enabling cache recovery
Thu Oct 9 17:16:18 2003
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.
Thu Oct 9 17:16:18 2003
SMON: enabling tx recovery
Thu Oct 9 17:16:18 2003
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Thu Oct 9 17:36:54 2003
SMON: Parallel transaction recovery tried
Thu Oct 9 17:48:21 2003
Thread 1 advanced to log sequence 210
Current log# 2 seq# 210 mem# 0: /oracle/app/oracle/oradata/orcl/redo02.log
Current log# 2 seq# 210 mem# 1: /SBYW/oradata/orcl/redo021.rdo
Fri Oct 10 04:04:40 2003
Thread 1 advanced to log sequence 211
Current log# 3 seq# 211 mem# 0: /oracle/app/oracle/oradata/orcl/redo03.log
Current log# 3 seq# 211 mem# 1: /SBYW/oradata/orcl/redo031.rdo
Fri Oct 10 10:47:34 2003
Thread 1 advanced to log sequence 212
Current log# 1 seq# 212 mem# 0: /oracle/app/oracle/oradata/orcl/redo01.log
Current log# 1 seq# 212 mem# 1: /SBYW/oradata/orcl/redo011.rdo
Fri Oct 10 15:08:35 2003
Errors in file /SBYW/admin/orcl/udump/orcl_ora_37252.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] [] |
|
免费注册
发表于 2003-10-10 16:37
发表于 2003-10-10 17:28
