ORA-03137: TTC protocol internal error : [3149]
ORA-03149: Invalid Oracle error code
Sul db TEST01 abbiamo questo errore nel file “alert.log”
Errors in file /u01/app/oracle/diag/rdbms/test01/TEST01/trace/TEST01_ora_8234.trc (incident=10758):
ORA-03137: TTC protocol internal error : [3149] [] [] [] [] [] [] []
ORA-03149: Invalid Oracle error code
Tue May 26 13:23:47 2020
Sweep [inc][10758]: completed
Sweep [inc][10757]: completed
Sweep [inc2][10757]: completed
Vediamo il file di trace indicato nel file di log
vi /u01/app/oracle/diag/rdbms/test01/TEST01/incident/incdir_10756/TEST01_ora_8234_i10756.trc
Questa sembrerebbe la query incriminata
========= Dump for incident 10756 (ORA 3137 [3149]) ========
*** 2020-05-26 13:22:45.393
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
---- Current SQL Statement for this session (sql_id=4ftjw26fr3rw6) ----
select F204_PROGINS ,F204_NATRAP ,F204_MATR_COD ,F204_LPCS ,F204_POS_FILL ,F204_TIP_DEC ,F204_NUMDEC ,F204_DATADECR ,F204_DATA_IMMI ,F204_USER_LAST ,F204_DATA_REVOCA ,F204_FILLER_R ,F204_MENS_DECOR ,F204_IMPORTO ,F204_ADEG_PERC ,F204_DURATA ,F204_ART15 ,F204_DATA_APPL from TET01.PT03F204 where F204_PROGINS<=:b1 order by F204_PROGINS desc
L'errore è legato al Bug 14489591 - ORA-3137 [3149] on server due to bad bind attempt in client.
La versione del db è 11.2.0.4.0