ORA-600 [17182] While Compiling A Procedure (Doc ID 1464898.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.

Symptoms


Attempt to create a package  which depends on an existing package that in turn
depends on a table generates:

ORA-00600: codice di errore interno, argomenti: [17182], [0x9E4917C], [], [], [], [], [], [], [], [], [], []

 

In Alert log:

Wed May 30 12:58:32 2012
Errors in file /app/diag/rdbms/test/test/trace/test_ora_14927.trc  (incident=77253):
ORA-00600: codice di errore interno, argomenti: [17182], [0x9E4917C], [], [], [], [], [], [], [], [], [], []
ORA-06544: PL/SQL: errore interno, argomenti: [2603], [], [], [], [], [], [], []
Incident details in: /app/diag/rdbms/test/test/incident/incdir_77253/test_ora_14927_i77253.trc
Wed May 30 12:58:58 2012
Errors in file /app/diag/rdbms/test/test/incident/incdir_77253/test_ora_14927_i77253.trc:
ORA-00308: impossibile aprire log archiviato '/oralog/archive/archive1_92_717587251.dbf'
ORA-27037: impossibile ottenere lo stato del file
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00600: codice di errore interno, argomenti: [17182], [0x9E4917C], [], [], [], [], [], [], [], [], [], []
ORA-06544: PL/SQL: errore interno, argomenti: [2603], [], [], [], [], [], [], []
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x20049] [PC:0xED65D89, kghfrf()+49] [flags: 0x0, count: 1]
Wed May 30 12:58:59 2012
Trace dumping is performing id=[cdmp_20120530125859]
Errors in file /app/diag/rdbms/test/test/trace/test_ora_14927.trc  (incident=77254):
ORA-07445: trovata eccezione: dump della memoria [kghfrf()+49] [SIGSEGV] [ADDR:0x20049] [PC:0xED65D89] [Address not mapped to object] []
ORA-00600: codice di errore interno, argomenti: [17182], [0x9E4917C], [], [], [], [], [], [], [], [], [], []
ORA-06544: PL/SQL: errore interno, argomenti: [2603], [], [], [], [], [], [], []
Incident details in: /app/diag/rdbms/test/test/incident/incdir_77254/test_ora_14927_i77254.trc

  

PL/SQL reported in the trace file:

create or replace
PACKAGE testpkg AS
 
 function query_show_matr              return domandaconcorsi_common.show_guser_table              pipelined;
 function query_show_doc               return domandaconcorsi_common.show_gdoc_table               pipelined;
 function query_show_dom               return domandaconcorsi_common.show_gdom_table               pipelined;
 function query_show_accessi           return domandaconcorsi_common.show_gacc_table               pipelined;
 function query_show_da_conf           return domandaconcorsi_common.show_gda_conf_table           pipelined;
 function query_show_stat_dom          return domandaconcorsi_common.show_gstatistiche_table       pipelined;
 function query_show_stat_conc         return domandaconcorsi_common.show_gstat_conc_table         pipelined;
 function query_show_stat_cittad       return domandaconcorsi_common.show_gstat_cittad_table       pipelined;
 function query_show_domande           return domandaconcorsi_common.show_gdomande_table           pipelined;
 function query_show_documenti         return domandaconcorsi_common.show_gdocumenti_table         pipelined;
 function query_show_documento_domanda return domandaconcorsi_common.show_gdocumento_domanda_table pipelined;
 function query_show_ult_richi         return domandaconcorsi_common.show_gult_richi_table         pipelined;
       
 function list_data_l_documento       return ui_list.list_option_tab pipelined;
 function list_data_l_corso_dottorato return ui_list.list_option_tab pipelined;
 
 function list_data_l_stato              return ui_list.list_option_tab pipelined;
 function list_data_l_provincia          return ui_list.list_option_tab pipelined;
 function list_data_l_provincia_recapito return ui_list.list_option_tab pipelined;
 function list_data_l_comune             return ui_list.list_option_tab pipelined;
 function list_data_l_comune_recapito    return ui_list.list_option_tab pipelined;
 function list_data_l_cittadinanza       return ui_list.list_option_tab pipelined;
 
 function list_data_r_se_extra_com       return ui_list.list_option_tab pipelined;
 
 function goto_entry_point              return varchar2;
 function goto_visualizza_accessi       return varchar2;
 function goto_integra_documento        return varchar2;
 function goto_ottieni_matricola        return varchar2;
 function goto_sblocco_conferma_domande return varchar2;
 function goto_visualizza_documenti     return varchar2;
 function goto_visualizza_domande       return varchar2;
 function goto_stampa_ricevute          return varchar2;
 function goto_visualizza_statistiche   return varchar2;
 function goto_statistiche_cittadinanza return varchar2;
 function goto_visualizza_excel         return varchar2;
 function goto_modifica_anagrafica      return varchar2;
 function goto_cambia_corso             return varchar2;
 function goto_ulteriori_richieste      return varchar2;
 function goto_controllo_dati           return varchar2;
 function goto_cancella_dati            return varchar2;
       
 procedure index_page;
 procedure accesses_page;
 procedure integration_page_1;
 procedure integration_page_2;
 procedure integration_page_3;
 procedure documents_page_1;
 procedure documents_page_2;
 procedure ricevuta_page_1;
 procedure ricevuta_page_2;
 procedure ricevuta_page_3;
 procedure statistiche_pg;
 procedure applications_page;
 procedure cittadinanza_pg;
 procedure cancella_dati_pg;
 procedure modifica_anagrafica_1_pg;
 procedure modifica_anagrafica_2_pg (p_event in varchar2);
 procedure visualizza_excel_pg      (p_event in varchar2);
 procedure cambia_corso_1_pg;
 procedure cambia_corso_2_pg;
 procedure inserisci_richieste_pg   (p_event in varchar2);
 procedure access_denied            (p_event in varchar2);
 
 procedure on_search_user;
 procedure on_search_course;
 procedure on_search_matr;
 procedure on_unlock_dom;
 procedure on_confirm_app;
 procedure on_go_app;
 procedure on_send_mail;
 procedure on_modifica_dati_anag;
 procedure on_domanda_selezionata;
 procedure on_cambia_corso;
 procedure on_delete_ass_dom_doc;
 procedure on_delete_documenti;
 procedure on_delete_domande;
 procedure on_delete_accessi;
 
 procedure on_upload;
     
 procedure on_page_event(p_page in varchar2, p_event in varchar2);
 procedure after_action;
END testpkg;

 
Call stack:

kgherror kghfrf psdtygen pssuprs4_type pssuprs2_toplev psstygen2 psstygen psdtygen pcitygen
phpcmp pcicmp0 kkxcmp0 rpiswu2 kkxcmp kkpcrt opiexe

 

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