Oracle ORA-07445 evaopn2 () +128 error issue

Oracle ORA-07445 evaopn2 () +128 Error Issues

Problem description

Plsql developer executes a SQL error:

Check alert log for detailed error information:

Ora-07445:exception Encountered:core Dump [EVAOPN2 () +128] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

Database version

10.2.0.4.0????

Cause of the problem

Oracle bugs caused by complex view merge issues

Workaround

1, modify the hidden parameters:

Alter system set "_complex_view_merging" =false Scope=both;

2. Use hint No_merge

Modifying hidden parameters has too wide a scope to cause other problems, so hint is used to resolve them.

Oracle ORA-07445 evaopn2 () +128 error issue