Applications Systems
ORA-03137: TTC protocol internal errors
The DPA log files or Oracle trace files contain the following error: ORA-03137: TTC protocol internal error
First published date
Last published date
Overview
The DPA log files or Oracle trace files contain the following error with Oracle 11.1 as the repository database:
ORA-03137: TTC protocol internal error
Product section
Cause
Resolution
Perform one of the following actions:
- Upgrade to Oracle 11.1.0.7.
- Set "_optim_peek_user_binds"=false. SolarWinds recommends using this option.
The issue can still occur after upgrading to Oracle11.1.0.7
Although upgrading to database version 11.1.0.7 has been confirmed to have solved this issue in a high number of cases, error ORA-3137 [12333] accompanied by Protocol Violation messages may still occur intermittently in database versions prior to 11.2, including database 10.2.0.4 and 11.1.0.7. This has been reported in unpublished bug:8625762 ORA-3137 [12333] due to bind data not read from wire, in which case ORA-3137 [12333] can occur intermittently for SQL which uses user binds due to bind data being left unread on the Net connection. The bug suggests the workaround of setting "_optim_peek_user_binds"=false to avoid this problem (workaround to be used with caution as it can affect execution plans chosen by CBO), and also provides the fix by the application of Patch:8625762.
Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.