oracle rac11g数据库报07445的错误

马鹏竣

2019-07-11

oracle

报错如下：

Sun Jun 30 14:41:20 2019

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x4] [PC:0x96BB4A7, evaopn3

()+135] [flags: 0x0, count: 1]

Errors in file /u01/app/oracle/diag/rdbms/hbswsjck/hbswsjck1/trace/hbswsjck1_ora_212978.trc

(incident=336691):

ORA-07445: 出现异常错误: 核心转储 [evaopn3()+135] [SIGSEGV] [ADDR:0x4] [PC:0x96BB4A7] [Address

not mapped to object] []

Incident details in:

/u01/app/oracle/diag/rdbms/hbswsjck/hbswsjck1/incident/incdir_336691/hbswsjck1_ora_212978_i3366

91.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Sun Jun 30 14:41:22 2019

Dumping diagnostic data in directory=[cdmp_20190630144122], requested by (instance=1,

osid=212978), summary=[incident=336691].

Sun Jun 30 14:41:26 2019

Sweep [inc][336691]: completed

Sweep [inc2][336691]: completed

Sun Jun 30 14:41:53 2019

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x4] [PC:0x96BB4A7, evaopn3

()+135] [flags: 0x0, count: 1]

Errors in file /u01/app/oracle/diag/rdbms/hbswsjck/hbswsjck1/trace/hbswsjck1_ora_335794.trc

(incident=336886):

ORA-07445: 出现异常错误: 核心转储 [evaopn3()+135] [SIGSEGV] [ADDR:0x4] [PC:0x96BB4A7] [Address

not mapped to object] []

Incident details in:

/u01/app/oracle/diag/rdbms/hbswsjck/hbswsjck1/incident/incdir_336886/hbswsjck1_ora_335794_i3368

86.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Sun Jun 30 14:41:54 2019

Dumping diagnostic data in directory=[cdmp_20190630144154], requested by (instance=1,

osid=335794), summary=[incident=336886].

Sun Jun 30 14:42:26 2019

Sweep [inc][336886]: completed

Sweep [inc2][336886]: completed

Sun Jun 30 14:45:56 2019

Errors in file /u01/app/oracle/diag/rdbms/hbswsjck/hbswsjck1/trace/hbswsjck1_ora_336829.trc

(incident=336963):

ORA-00600: 内部错误代码, 参数: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [],

[]

Incident details in:

/u01/app/oracle/diag/rdbms/hbswsjck/hbswsjck1/incident/incdir_336963/hbswsjck1_ora_336829_i3369

63.trc

6条回答

默认

最新

马鹏竣

上传附件：alert2.txt

有用 0

张小帅

看下trc日志内容，current sql是不是建表日志，是的话可"_pred_move_around"=false;

有用 0

马鹏竣

----- Current SQL Statement for this session (sql_id=b4spqdcs73rcs) -----

CREATE TABLE TMP_HF_JGB_LX4NKS AS

WITH A AS (

SELECT JLR.NSRDZDAH,

JLR.BBSQQ,

JLR.JLR,

TO_CHAR(JLR.BBSQQ, 'YYYY') NF,

ROW_NUMBER() OVER(PARTITION BY JLR.NSRDZDAH ORDER BY JLR.BBSQQ ) XH

FROM TMP_HF_SFZ_CWBB_JLR JLR

WHERE JLR.ZB_DL = '5'

AND JLR < 20000

AND JLR.BBSQZ<>DATE'2019-12-31'

AND JLR.BBSQQ>=DATE'2015-01-01'

),B AS (

SELECT A.*,TO_CHAR(SYSDATE,'YYYY')+XH XXH FROM A A

),C AS (

SELECT B.*,XXH-NF NFC FROM B B

)

SELECT C.NSRDZDAH, MIN(NF) STA, MAX(NF) ENDN, COUNT(NFC) LXCS

FROM C C

GROUP BY C.NSRDZDAH, NFC

HAVING COUNT(NFC)>=4--2015-2018连续四年净利润小于2万

ORDER BY NFC

有用 0

文成

A CTAS (Create table as select) operation undergoing predicate move around
may fail during execution with an ORA-600 [rwoirw: check ret val] or an ORA-7445.
Workaround
Disable predicate move around before executing the CTAS.
eg:
alter session set "_pred_move_around"=FALSE;

看看这个方案能不能解决

同时这个sql感觉写复杂了啊去掉with as 应该也比较容易吧

有用 0