帮忙分析一下
警告日志的一部分：
Jul 28 11:21:17 2004
Errors in file /export/oracle/admin/oraunix/bdump/oradb_s001_21173.trc:
ORA-07445: 出现异常: 核心转储 [ptmak()+120] [SIGSEGV] [Address not mapped to obj
ect] [0x8] [] []
Jul 28 11:21:52 2004
found dead shared server 'S001', pid = (10, 3)
Jul 28 11:22:16 2004
Errors in file /export/oracle/admin/oraunix/bdump/oradb_s001_22770.trc:
ORA-07445: 出现异常: 核心转储 [ptmak()+120] [SIGSEGV] [Address not mapped to obj
ect] [0x8] [] []
Jul 28 11:22:50 2004
found dead shared server 'S001', pid = (10, 4)
Jul 28 14:39:41 2004
Errors in file /export/oracle/admin/oraunix/bdump/oradb_s001_22772.trc:
ORA-07445: 出现异常: 核心转储 [ptmak()+120] [SIGSEGV] [Address not mapped to obj
ect] [0x8] [] []
Jul 28 14:40:33 2004
found dead shared server 'S001', pid = (10, 5)
Jul 28 14:40:57 2004
Errors in file /export/oracle/admin/oraunix/bdump/oradb_s002_627.trc:
ORA-07445: 出现异常: 核心转储 [ptmak()+120] [SIGSEGV] [Address not mapped to obj
ect] [0x8] [] []
Jul 28 14:41:24 2004
found dead shared server 'S002', pid = (11, 1)
Jul 28 14:42:18 2004
Errors in file /export/oracle/admin/oraunix/bdump/oradb_s001_23087.trc:
ORA-07445: 出现异常: 核心转储 [ptmak()+120] [SIGSEGV] [Address not mapped to obj
ect] [0x8] [] []
Jul 28 14:43:16 2004
found dead shared server 'S001', pid = (10, 6)
Jul 28 14:43:47 2004
Errors in file /export/oracle/admin/oraunix/bdump/oradb_s001_23097.trc:
ORA-07445: 出现异常: 核心转储 [ptmak()+120] [SIGSEGV] [Address not mapped to obj
ect] [0x8] [] []
Jul 28 14:44:04 2004
found dead shared server 'S001', pid = (10, 7)
Jul 28 14:50:26 2004
Errors in file /export/oracle/admin/oraunix/bdump/oradb_s001_23099.trc:
ORA-07445: 出现异常: 核心转储 [ptmak()+120] [SIGSEGV] [Address not mapped to obj
ect] [0x8] [] []
Jul 28 14:51:24 2004
found dead shared server 'S001', pid = (10, 8)
Jul 28 14:52:06 2004
Errors in file /export/oracle/admin/oraunix/bdump/oradb_s001_23110.trc:
ORA-07445: 出现异常: 核心转储 [ptmak()+120] [SIGSEGV] [Address not mapped to obj
ect] [0x8] [] []
Jul 28 14:53:01 2004
found dead shared server 'S001', pid = (10, 9)
Jul 28 14:54:25 2004
Thread 1 advanced to log sequence 2999
Current log# 1 seq# 2999 mem# 0: /export/oracle/oradata/oraunix/redo01.log
Current log# 1 seq# 2999 mem# 1: /disk1/oracle_data/redo01.log
Jul 28 14:54:25 2004
ARC2: Beginning to archive log 3 thread 1 sequence 2998
ARC2: Completed archivinglog 3 thread 1 sequence 2998
Jul 28 14:56:25 2004
Errors in file /export/oracle/admin/oraunix/bdump/oradb_s002_23089.trc:
ORA-07445: 出现异常: 核心转储 [ptmak()+120] [SIGSEGV] [Address not mapped to obj
ect] [0x8] [] []
Jul 28 14:56:41 2004
found dead shared server 'S002', pid = (11, 2)
Jul 28 15:21:10 2004
Errors in file /export/oracle/admin/oraunix/bdump/oradb_s001_23121.trc:
ORA-07445: 出现异常: 核心转储 [ptmak()+120] [SIGSEGV] [Address not mapped to obj
ect] [0x8] [] []
Jul 28 15:21:53 2004
found dead shared server 'S001', pid = (10, 10)
Jul 28 15:31:22 2004
Errors in file /export/oracle/admin/oraunix/bdump/oradb_s001_23177.trc:
ORA-07445: 出现异常: 核心转储 [ptmak()+120] [SIGSEGV] [Address not mapped to obj
ect] [0x8] [] []
Jul 28 15:32:10 2004
found dead shared server 'S001', pid = (10, 11)
Jul 28 15:34:28 2004
Errors in file /export/oracle/admin/oraunix/bdump/oradb_s001_23201.trc:
ORA-07445: 出现异常: 核心转储 [ptmak()+120] [SIGSEGV] [Address not mapped to obj
ect] [0x8] [] []
Jul 28 15:34:53 2004
found dead shared server 'S001', pid = (10, 12)
Jul 28 15:39:55 2004
Restarting dead background process EMN0
EMN0 started with pid=37
oradb_s001_22770.trc文件中的一部分：
/export/oracle/admin/oraunix/bdump/oradb_s001_22770.trc
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
ORACLE_HOME = /export/oracle
System name:
SunOS
Node name:
e3500
Release:
5.8
Version:
Generic_108528-07
Machine:
sun4u
Instance name: oradb
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 22770, image: oracle@e3500 (S001)
*** 2004-07-28 11:22:16.078
*** SESSION ID
40.43857) 2004-07-28 11:22:16.047
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x8, PC: [0x1614f94, ptmak()+120]
*** 2004-07-28 11:22:16.120
ksedmp: internal or fatal error
ORA-07445: 出现异常: 核心转储 [ptmak()+120] [SIGSEGV] [Address not mapped to object] [0x8] [] []
Current SQL statement for this session:
BEGIN
/* NOP UNLESS A TABLE OBJECT */
IF dictionary_obj_type = 'TABLE' THEN
sys.dbms_cdc_publish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,sysevent);
END IF;
END;
|
