OraFAQ Forum: Performance Tuning » ORA-07445: exception encountered: core dump [audplsfailure()+54]

Home » RDBMS Server » Performance Tuning » ORA-07445: exception encountered: core dump [audplsfailure()+54] (Oracle DB 11.2.0.4 OS: Redhat Linux 6.9 64 Bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-07445: exception encountered: core dump [audplsfailure()+54] [message #669824]

Tue, 15 May 2018 08:37

suhaspdba
Messages: 1
Registered: May 2018

Junior Member

Hi,

While creating view we got below error :

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x428] [PC:0x1ED60C8, audplsfailure()+54] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/prod/PROD/trace/PROD_ora_32001.trc (incident=36194):
ORA-07445: exception encountered: core dump [audplsfailure()+54] [SIGSEGV] [ADDR:0x428] [PC:0x1ED60C8] [Address not mapped to object] []
ORA-00957: duplicate column name
Incident details in: /u01/app/oracle/diag/rdbms/prod/PROD/incident/incdir_36194/PROD_ora_32001_i36194.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue May 15 14:46:34 2018
Dumping diagnostic data in directory=[cdmp_20180515144634], requested by (instance=1, osid=32001), summary=[incident=36194].
Tue May 15 14:46:34 2018
Sweep [inc][36194]: completed
Sweep [inc2][36194]: completed
Tue May 15 14:54:49 2018
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x428] [PC:0x1ED60C8, audplsfailure()+54] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/prod/PROD/trace/PROD_ora_6416.trc (incident=36242):
ORA-07445: exception encountered: core dump [audplsfailure()+54] [SIGSEGV] [ADDR:0x428] [PC:0x1ED60C8] [Address not mapped to object] []
ORA-00957: duplicate column name
Incident details in: /u01/app/oracle/diag/rdbms/prod/PROD/incident/incdir_36242/PROD_ora_6416_i36242.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue May 15 14:54:50 2018
Dumping diagnostic data in directory=[cdmp_20180515145450], requested by (instance=1, osid=6416), summary=[incident=36242].
Tue May 15 14:54:53 2018
Sweep [inc][36242]: completed
Sweep [inc2][36242]: completed

and creating view sql's attached

Attachment: DELQ.sql
(Size: 11.58KB, Downloaded 3102 times)

Report message to a moderator

Re: ORA-07445: exception encountered: core dump [audplsfailure()+54] [message #669826 is a reply to message #669824]

Tue, 15 May 2018 08:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Below needs to be corrected
>ORA-00957: duplicate column name

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Report message to a moderator