Analýza

Thu Jan 05 08:27:26 2017
Errors in file /opt/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ora_20013.trc (incident=84864):
ORA-03137: vnitøní chyba protokolu TTC: [12333] [10] [65] [65] [] [] [] []

Trace file
--- PROTOCOL VIOLATION DETECTED ---
----- Dump Cursor sql_id=ggwxk0q15fpf6 xsc=0x2ba3ce2398e0 cur=0x2ba3cdf91a38 -----
LibraryHandle: Address=bfc34a50 Hash=825755c6 LockMode=N PinMode=0 LoadLockMode=0 Status=VALD
 ObjectName: Name=select
 (DQ.Code || '-' || CAST(a.OrdNumber AS VARCHAR(10)) ||'/' || P.Code) as DisplayName,
 FO.Name as FirmOfficeName,
.....

Řešení

podle NOTE Troubleshooting ORA-3137 [12333] Errors Encountered When Using Oracle JDBC Driver (Doc ID 1361107.1)

SQL> SELECT ksppinm, ksppstvl
FROM x$ksppi a, x$ksppsv b
WHERE a.indx=b.indx AND ksppinm = '_optim_peek_user_binds'
ORDER BY ksppinm
/ 
KSPPINM
--------------------------------------------------------------------------------
KSPPSTVL
--------------------------------------------------------------------------------
_optim_peek_user_binds
TRUE
SQL> alter system set "_optim_peek_user_binds"=false;
System zmenen.
SQL> SELECT ksppinm, ksppstvl
FROM x$ksppi a, x$ksppsv b
WHERE a.indx=b.indx AND ksppinm = '_optim_peek_user_binds'
ORDER BY ksppinm
/ 2 3 4 5
KSPPINM
--------------------------------------------------------------------------------
KSPPSTVL
--------------------------------------------------------------------------------
_optim_peek_user_binds
FALSE


Komentáře