OraFAQ Forum: Performance Tuning » ORA-03137

Home » RDBMS Server » Performance Tuning » ORA-03137 (11.1.0.6.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-03137 [message #455476]

Tue, 11 May 2010 13:34

AlinaC
Messages: 45
Registered: November 2005
Location: India

Member

I'm using
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Solaris: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production.
alart log of the DB reporting the following error-
ORA-03137: TTC protocol internal error : [12333] [16] [75] [95] [] [] [] [] and my DB is running slow.
Can any one help me on the issue.

Thanks,

Alina

Report message to a moderator

Re: ORA-03137 [message #455478 is a reply to message #455476]

Tue, 11 May 2010 13:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

03137, 00000, "TTC protocol internal error : [%s] [%s] [%s] [%s] [%s] [%s] [%s] [%s]"
// *Cause:  TTC protocol internal error.
// *Action: Contact Oracle Support Services.

Report message to a moderator

Re: ORA-03137 [message #530865 is a reply to message #455478]

Fri, 11 November 2011 03:08

francl
Messages: 8
Registered: November 2011
Location: Slovenia

Junior Member

I was getting similar errors intermittently from our java applications which were connecting to the database. In the end Oracle suggested I set the following parameter "_optim_peek_user_binds=FALSE" and I have not seen these errors since.

alter system set _optim_peek_user_binds=FALSE scope=both;

Report message to a moderator

Re: ORA-03137 [message #530866 is a reply to message #530865]

Fri, 11 November 2011 03:11

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for the feedback.

Regards
Michel

Report message to a moderator

Re: ORA-03137 [message #561788 is a reply to message #455476]

Wed, 25 July 2012 05:43

gajjar.swetal
Messages: 1
Registered: July 2012
Location: INDIA

Junior Member

Hi,

I am using Oracle 11.2.0.1.0 version and am getting the same error.
When I tried to execute "alter system set _optim_peek_user_binds=FALSE scope=both;", I am getting error shows in attached file.

Regards,
Swetal Gajjar.

Attachment: dberror.png
(Size: 47.97KB, Downloaded 5629 times)

Report message to a moderator

Re: ORA-03137 [message #561790 is a reply to message #561788]

Wed, 25 July 2012 05:58

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ You MUST NOT use this parameter unless Oracle support call you to do it. It is NOT a magical and silver bullet.
2/ If you don't know how to set this parameter this means you are not skilled enough to use it, so forget about it

Regards
Michel

Report message to a moderator

Re: ORA-03137 [message #561791 is a reply to message #561788]

Wed, 25 July 2012 05:59

francl
Messages: 8
Registered: November 2011
Location: Slovenia

Junior Member

Try using quotes.

alter system set "_optim_peek_user_binds"=false scope=both;

Report message to a moderator

Re: ORA-03137 [message #561797 is a reply to message #561791]

Wed, 25 July 2012 06:18

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do NOT provide such answer to unskilled people.
It will NOT help, it will just harm. It is like to give a gun to a child.

Regards
Michel

Report message to a moderator

Re: ORA-03137 [message #561808 is a reply to message #561797]

Wed, 25 July 2012 06:40

francl
Messages: 8
Registered: November 2011
Location: Slovenia

Junior Member

I am sorry Michel but I don't agree with your analogy. There is big difference between giving someone a gun and giving people information (there is way to much hiding of knowledge already). It is up to the person to test and research further what these parameters will do if they want to.

I am no Oracle expert but this particular parameter has had no other visable affects on our production database, so I think he should be reasonably safe if using it. If anything this parameter has helped us get around Oracle bugs in their JDBC drivers and bind peeking which Oracle were not able to resolve via patches to date.

One other thing, this is a forum and people are looking for answers or things to try. We should give them information rather than withhold it. They will learn with time that they need to do testing before applying such changes to the live system. We don't guarantee anything here in these forums we just offer suggestions about what has worked for us and they can try them or not. (Stay off the Caffeine and be nice, we need smart people like you.) Cool

Cool

Report message to a moderator

Re: ORA-03137 [message #561817 is a reply to message #561808]

Wed, 25 July 2012 06:57

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I am sorry Michel but I don't agree with your analogy. There is big difference between giving someone a gun and giving people information (there is way to much hiding of knowledge already). It is up to the person to test and research further what these parameters will do if they want to.

You give that to a child, a child does not test in a safe way, a child just uses the gun (hidden parameter).

Quote:

I am no Oracle expert but this particular parameter has had no other visable affects on our production database, so I think he should be reasonably safe if using it.

As you say you are not an Oracle expert.
I do not see the tiger but the tiger eated me, why? wasn't it safe enough to not pay attention to it? Smile

Smile

Quote:

One other thing, this is a forum and people are looking for answers or things to try. We should give them information rather than withhold it. They will learn with time that they need to do testing before applying such changes to the live system. We don't guarantee anything here in these forums we just offer suggestions about what has worked for us and they can try them or not. (Stay off the Caffeine and be nice, we need smart people like you.)

I think you are not old enough to statistically know how people behave, so trust me, if you post something then it will be used ANY WAY. I think when answering we have the responsability to not lead people on a dangerous slope (unless you want to get his job).

(By the way, I do not take coffee, cola or any other of this king of drink (if you are interested in this important information.)

Regards
Michel

Report message to a moderator

Re: ORA-03137 [message #582170 is a reply to message #455476]

Mon, 15 April 2013 03:18

lovelyjo
Messages: 3
Registered: April 2013
Location: hyderabad

Junior Member

Hi

Iam using

Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

I am getting the below errorson production server

Errors in file /var/opt/oracle/otk/1.0/diag/rdbms/clmstd/clmstd/trace/clmstd_ora_11876.trc (incident=11145):
ORA-03137: TTC protocol internal error : [12333] [7] [87] [65] [] [] [] []
Incident details in: /var/opt/oracle/otk/1.0/diag/rdbms/clmstd/clmstd/incident/incdir_11145/clmstd_ora_11876_i11145.trc

Any suggestions to stop this errors........

Thanks
Jyothi

Report message to a moderator

Re: ORA-03137 [message #582171 is a reply to message #582170]

Mon, 15 April 2013 03:40

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

BlackSwan wrote on Tue, 11 May 2010 20:39

03137, 00000, "TTC protocol internal error : [%s] [%s] [%s] [%s] [%s] [%s] [%s] [%s]"
// *Cause:  TTC protocol internal error.
// *Action: Contact Oracle Support Services.

Report message to a moderator

Re: ORA-03137 [message #582180 is a reply to message #582171]

Mon, 15 April 2013 08:06

lovelyjo
Messages: 3
Registered: April 2013
Location: hyderabad

Junior Member

Any other way without contact oracle support services

because I am providing the support to production databases

Thanks
jyothi

Report message to a moderator

Re: ORA-03137 [message #582187 is a reply to message #582180]

Mon, 15 April 2013 08:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Any other way without contact oracle support services
no other way

Report message to a moderator

Re: ORA-03137 [message #582733 is a reply to message #582187]

Mon, 22 April 2013 06:05

nlnkapardi
Messages: 26
Registered: April 2013
Location: India

Junior Member

nlnkapardi@gmail.com

Hi All

As per My knowledge. We can Drill down like getting the following information.

Which Functionality is the user using. As If We see the first Argument [12333]

It indicates that we are about to read an new function request from the message but the function code seen is not a valid code. This can typically happen if the current message position has gotten out of sync for some reason.

For this Please check weather your End user's Requirement is Correctly Hitting the Valid Function Or not.

For this Please verify the Master Metalink note 1388487.1 Where Some times you will be hit with some Known bugs.

@ Seniors You Can Help my Answer to grow ahead with your valuable feedback.

Please Feel Free to get back to me.,

Cheers
kapardi

Report message to a moderator

Re: ORA-03137 [message #651211 is a reply to message #582733]

Thu, 12 May 2016 16:40

valdba
Messages: 2
Registered: May 2016
Location: Portland, OR

Junior Member

Both sides of this discussion have a point.
In as much as the originator of the question may need an urgent answer to solve an immediate problem, it may help better to provide a little more context/explanation to the response.
In this regard, a little more information about the optimizer & bind variable peeking (https://docs.oracle.com/cd/E11882_01/server.112/e41573/optimops.htm#PFGRF94588) may come in very handy here.

thanks, vm

[Updated on: Thu, 12 May 2016 16:41]

Report message to a moderator

Re: ORA-03137 [message #651213 is a reply to message #651211]

Thu, 12 May 2016 17:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>In as much as the originator of the question may need an urgent answer to solve an immediate problem,
I doubt that after 3+ years, this would still be an urgent issue.

valbdba,

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Report message to a moderator

Re: ORA-03137 [message #651214 is a reply to message #651211]

Thu, 12 May 2016 17:38

valdba
Messages: 2
Registered: May 2016
Location: Portland, OR

Junior Member

Removed violation of Oracle's copyrighted material.
Oracle license prohibits others to publish Notes from MOS.

[Updated on: Thu, 12 May 2016 17:47] by Moderator

Report message to a moderator

Previous Topic:	SGA_MAX_SIZE and SGA_TARGET
Next Topic:	performance issue with oracle AQ while dequeueing the table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 06:36:54 CST 2024