Alter View Compile Fails with ORA-7445 [nsoexc()+199] (Doc ID 1068904.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Unable to run utilrp when upgrading to 10.2.0.4 with ORA-03114 and ORA-07445:

Call Stack
nsoexc nsoboc nsolev kkqdrv opiSem opiprs kksParseChildCursor rpiswu2 kksfbc opiosq

---- PL/SQL Call Stack -----
0x7d5786a8 946 package body SYS.DBMS_UTILITY
0x78dbc540 1 anonymous block
0x78e8d668 316 package body SYS.UTL_RECOMP
0x78e8d668 644 package body SYS.UTL_RECOMP
0x78e8d668 595 package body SYS.UTL_RECOMP
0x78e8ddf8 4 anonymous block

Error Message
ORA-07445: exception encountered: core dump [nsoexc()+199] [SIGSEGV] [Address not mapped to object] [0x0000001E0] [] []
Current SQL statement for this session:
ALTER VIEW "OPS"."V_MAT_OTHER_COST_TRINOMIAL" COMPILE

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms