Submit a ticketCall us
Home > Success Center > Database Performance Analyzer (DPA) > ORA-03137: TTC protocol internal errors

ORA-03137: TTC protocol internal errors

Updated March 11th, 2016

Overview

The DPA log files or Oracle trace files contain the following error:

 

ORA-03137: TTC protocol internal error

Environment

  • DPA 8.0 and later
  • Oracle 11.1 as the repository database

Cause

This appears to be related to Bug #7445550 related to JDBC connections to the database, which DPA uses.

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.

Last modified
10:59, 1 Mar 2017

Tags

Classifications

Public