Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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