ORA-07445 [_ intel_fast_memcpy.a () + 10] Error reported using regular expression execution in Oracle SQL

 

 

Oracle version: 10.2.0.1

OS: Linux 64-bit

 

Regular expressions are used in SQL:

Select count (*)

From t

Where regexp_like (T. Note, '^ (. | +) * (\ (either \) +', 'I ')

 

The first execution can be performed, the second execution reports ORA-7445, session interruption.

 

The records in the trace file are as follows:

 

Exception signal: 11 (SIGSEGV), Code: 1 (address not mapped to object), ADDR: 0x5e, PC: [0x2a95574358, _ intel_fast_memcpy.a () + 10]

* ** 17:01:42. 331

Ksedmp: internal or fatal error

ORA-07445: predictionencountered: core dump [_ intel_fast_memcpy.a () + 10] [SIGSEGV] [address notmapped to object] [0x00000005e] [] []

 

 

Mos has the following documents:

Ora-7445 [kghphosphatase] Using Regexp or tablefunctions [ID 415567.1]

 

In Oracle 10.1.0.4 to 10.2.0.2, use a regular expression or table () function in SQL. May trigger ORA-7445 errors. What is mentioned in MOS is:

ORA-07445: exception encountered: core dump [kghalkaline () + 53]

 

Here the core dump is different from here, according to the description of MOS, in the use of regular expressions or table functions caused by ORA-7445 errors, core dump should also include: kghpld evarx1c lxreggenpblxregcomp lxkregexpcomp...

 

This error is caused by the Oracle bug 4440681. However, I have some discrepancies with this bug, but I have also ruled out several other possible causes. It is suspected that the bug is related. The bug has been fixed in Versions later than Oracle 10.2.0.3. Ask a friend to upgrade the database to 10.2.0.4 and test it.

 

 

 

 

 

 

 

 

 

 

Bytes -------------------------------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

Skype: tianlesoftware

QQ: tianlesoftware@gmail.com

Email: tianlesoftware@gmail.com

Blog: http://www.tianlesoftware.com

WEAVER: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

LinkedIn: http://cn.linkedin.com/in/tianlesoftware

 

 

------- Add a group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, reject the application ----

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823

Dba6 group: 158654907 dba7 group: 172855474 DBA group: 104207940