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)
ORA-07445: exception encountered: core dump [audplsfailure()+54] [message #669824] Tue, 15 May 2018 08:37 Go to next message
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 241 times)
Re: ORA-07445: exception encountered: core dump [audplsfailure()+54] [message #669826 is a reply to message #669824] Tue, 15 May 2018 08:48 Go to previous messageGo to next message
BlackSwan
Messages: 26274
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

Re: ORA-07445: exception encountered: core dump [audplsfailure()+54] [message #669827 is a reply to message #669824] Tue, 15 May 2018 08:48 Go to previous messageGo to next message
Roachcoach
Messages: 1571
Registered: May 2010
Location: UK
Senior Member
7445 >>> oracle support
Re: ORA-07445: exception encountered: core dump [audplsfailure()+54] [message #669828 is a reply to message #669824] Tue, 15 May 2018 10:18 Go to previous messageGo to next message
gazzag
Messages: 1040
Registered: November 2010
Location: Bristol, UK
Senior Member
You can use the Oracle ORA-07445 diagnostic tool here.
Re: ORA-07445: exception encountered: core dump [audplsfailure()+54] [message #669829 is a reply to message #669824] Tue, 15 May 2018 11:25 Go to previous message
Michel Cadot
Messages: 65961
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=90546&SkipA=0#248102

Previous Topic: Stored procedure taking long time to run
Next Topic: Distinct query taking long time to run
Goto Forum:
  


Current Time: Wed Nov 14 19:47:14 CST 2018