rhel4+oracle10201上ORA-07445: exception encountered: core dump [snstimsane()...
本帖最后由 qhd2004 于 2014-12-3 10:53 编辑sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 3 10:26:37 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security and Data Mining options
lsb_release -a
LSB Version: :core-3.0-amd64:core-3.0-ia32:core-3.0-noarch:graphics-3.0-amd64:graphics-3.0-ia32:graphics-3.0-noarch
Distributor ID: RedHatEnterpriseAS
Description: Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
Release: 4
Codename: NahantUpdate4
由于对alert我们有定时脚本做清理，我只能拿到一点点，如下：
more 201412030134_alert.log
Wed Dec 3 01:30:02 2014
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=122, OS id=30347
to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_TABLE_01', 'ETL_USER', 'KUPC$C_1_20141203013008', 'KUPC$S_1_20141203013008', 0);
kupprdp: worker process DW01 started with worker id=1, pid=123, OS id=30349
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_TABLE_01', 'ETL_USER');
Wed Dec 3 01:30:18 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 3144K exceeds notification threshold (2048K)
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_DATA_T', '7')), 0 ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,'TABLE' ,to_char
(KU$.BYTES_ALLOC) ,to_char(KU$.ET_PARALLEL) ,KU$.FGAC ,KU$.NONSCOPED_REF ,KU$.XMLSCHEMACOLS ,KU$.NAME ,KU$.NAME ,'TABLE_DATA' ,KU$.PART_NAME ,KU$.SCHEMA_OBJ.OWNER_NAME
,KU$.TS_NAME ,KU$.TRIGFLAG ,decode(KU$.SCHEMA_OBJ.TYPE_NUM,2,decode(bitand(KU$.PROPERTY,8192),8192,'NESTED TABLE','TABLE'),19,'PARTITION',20,'PARTITION','SUBPARTITION
') ,to_char(KU$.UNLOAD_METHO
Wed Dec 3 01:30:18 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 3144K exceeds notification threshold (2048K)
Details in trace file /apps/oracle/admin/sjdsbi/bdump/sjdsbi_dw01_30349.trc
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_DATA_T', '7')), 0 ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,'TABLE' ,to_char
(KU$.BYTES_ALLOC) ,to_char(KU$.ET_PARALLEL) ,KU$.FGAC ,KU$.NONSCOPED_REF ,KU$.XMLSCHEMACOLS ,KU$.NAME ,KU$.NAME ,'TABLE_DATA' ,KU$.PART_NAME ,KU$.SCHEMA_OBJ.OWNER_NAME
,KU$.TS_NAME ,KU$.TRIGFLAG ,decode(KU$.SCHEMA_OBJ.TYPE_NUM,2,decode(bitand(KU$.PROPERTY,8192),8192,'NESTED TABLE','TABLE'),19,'PARTITION',20,'PARTITION','SUBPARTITION
') ,to_char(KU$.UNLOAD_METHO
Wed Dec 3 01:30:40 2014
Errors in file /apps/oracle/admin/sjdsbi/udump/sjdsbi_ora_30266.trc:
ORA-07445: exception encountered: core dump [] []
附件为trc文件
大家有时间帮忙看下，3ks
本帖最后由 qhd2004 于 2014-12-3 10:56 编辑
如果需要其他相关信息，我再上传。
页:
[1]