Hi,
i have this error:
ORA-00600: codice di errore interno, argomenti: [Cursor not typechecked], [], [], [], [], [], [], [], [], [], [], []
My db is Oracle RAC 3 version:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
on IBM AIX 6.
in the alert log i found:
Errors in file /product/oracle/diag/rdbms/bsmetlp/BSMETLP3/trace/BSMETLP3_j000_51708130.trc (incident=140551):
ORA-00600: codice di errore interno, argomenti: [Cursor not
typechecked], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /product/oracle/diag/rdbms/bsmetlp/BSMETLP3/incident/incdir_140551/BSMETLP3_j000_51708130_i140551.trc
and in BSMETLP3_j000_51708130.tr file i found:
Trace file /product/oracle/diag/rdbms/bsmetlp/BSMETLP3/trace/BSMETLP3_j000_51708130.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /product/oracle/11gR2/product/11.2.0.3/db
System name: AIX
Node name: ial50048
Release: 1
Version: 6
Machine: 00CFE4A44C00
Instance name: BSMETLP3
Redo thread mounted by this instance: 3
Oracle process number: 54
Unix process pid: 51708130, image: oracle@ial50048 (J000)
*** 2014-04-15 15:01:28.935
*** SESSION ID:(299.44593) 2014-04-15 15:01:28.935
*** CLIENT ID:() 2014-04-15 15:01:28.935
*** SERVICE NAME:(SYS$USERS) 2014-04-15 15:01:28.935
*** MODULE NAME:(prc_carica_si_wo) 2014-04-15 15:01:28.935
*** ACTION NAME:(CARICAMENTO DATI) 2014-04-15 15:01:28.935
Incident 140551 created, dump file: /product/oracle/diag/rdbms/bsmetlp/BSMETLP3/incident/incdir_140551/BSMETLP3_j000_51708130_i140551.trc
ORA-00600: codice di errore interno, argomenti: [Cursor not typechecked], [], [], [], [], [], [], [], [], [], [], []
Incident 140552 created, dump file: /product/oracle/diag/rdbms/bsmetlp/BSMETLP3/incident/incdir_140552/BSMETLP3_j000_51708130_i140552.trc
ORA-00600: codice di errore interno, argomenti: [Cursor not typechecked], [], [], [], [], [], [], [], [], [], [], []
*** 2014-04-15 15:03:50.560
Incident 140553 created, dump file: /product/oracle/diag/rdbms/bsmetlp/BSMETLP3/incident/incdir_140553/BSMETLP3_j000_51708130_i140553.trc
ORA-00600: codice di errore interno, argomenti: [Cursor not typechecked], [], [], [], [], [], [], [], [], [], [], []
and in BSMETLP3_j000_51708130_i140551.trc file, i found:
Dump file /product/oracle/diag/rdbms/bsmetlp/BSMETLP3/incident/incdir_140551/BSMETLP3_j000_51708130_i140551.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /product/oracle/11gR2/product/11.2.0.3/db
System name: AIX
Node name: ial50048
Release: 1
Version: 6
Machine: 00CFE4A44C00
Instance name: BSMETLP3
Redo thread mounted by this instance: 3
Oracle process number: 54
Unix process pid: 51708130, image: oracle@ial50048 (J000)
*** 2014-04-15 15:01:28.949
*** SESSION ID:(299.44593) 2014-04-15 15:01:28.949
*** CLIENT ID:() 2014-04-15 15:01:28.949
*** SERVICE NAME:(SYS$USERS) 2014-04-15 15:01:28.949
*** MODULE NAME:(prc_carica_si_wo) 2014-04-15 15:01:28.949
*** ACTION NAME:(CARICAMENTO DATI) 2014-04-15 15:01:28.949
Dump continued from file: /product/oracle/diag/rdbms/bsmetlp/BSMETLP3/trace/BSMETLP3_j000_51708130.trc
ORA-00600: codice di errore interno, argomenti: [Cursor not typechecked], [], [], [], [], [], [], [], [], [], [], []
========= Dump for incident 140551 (ORA 600 [Cursor not typechecked]) ========
*** 2014-04-15 15:01:28.956
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=bp1rp7v2q62n5) -----
SELECT * FROM BSM.BSM_CLIENTE BC WHERE UPPER(BC.RAGIONE_SOCIALE) = UPPER(:B4 ) AND ((TRIM(BC.CODICE_FISCALE) = TRIM(:B3 )) OR (BC.CODICE_FISCALE IS NULL AND :B3 IS NULL)) AND ((TRIM(BC.PART
ITA_IVA) = TRIM(:B2 )) OR (:B2 IS NULL AND BC.PARTITA_IVA IS NULL)) AND ((:B1 > DATA_ATTIVAZIONE AND :B1 < DATA_CESSAZIONE OR DATA_CESSAZIONE IS NULL) OR (:B1 < DATA_ATTIVAZIONE AND DATA_CE
SSAZIONE IS NULL))
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
700000227ec18e0 588 package body ETL.PKG_ETL_BSM_SI_WO
700000227ec18e0 14561 package body ETL.PKG_ETL_BSM_SI_WO
7000001e7a94b48 1 anonymous block
please, can somebody help me?
with regards
Ivano