Home » RDBMS Server » Performance Tuning » ORA-03137 (11.1.0.6.0)
ORA-03137 [message #455476] Tue, 11 May 2010 13:34 Go to next message
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
Re: ORA-03137 [message #455478 is a reply to message #455476] Tue, 11 May 2010 13:39 Go to previous messageGo to next message
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.
Re: ORA-03137 [message #530865 is a reply to message #455478] Fri, 11 November 2011 03:08 Go to previous messageGo to next message
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;
Re: ORA-03137 [message #530866 is a reply to message #530865] Fri, 11 November 2011 03:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Re: ORA-03137 [message #561788 is a reply to message #455476] Wed, 25 July 2012 05:43 Go to previous messageGo to next message
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 5081 times)
Re: ORA-03137 [message #561790 is a reply to message #561788] Wed, 25 July 2012 05:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: ORA-03137 [message #561791 is a reply to message #561788] Wed, 25 July 2012 05:59 Go to previous messageGo to next message
francl
Messages: 8
Registered: November 2011
Location: Slovenia
Junior Member
Try using quotes.

alter system set "_optim_peek_user_binds"=false scope=both;
Re: ORA-03137 [message #561797 is a reply to message #561791] Wed, 25 July 2012 06:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-03137 [message #561808 is a reply to message #561797] Wed, 25 July 2012 06:40 Go to previous messageGo to next message
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
Re: ORA-03137 [message #561817 is a reply to message #561808] Wed, 25 July 2012 06:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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

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
Re: ORA-03137 [message #582170 is a reply to message #455476] Mon, 15 April 2013 03:18 Go to previous messageGo to next message
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
Re: ORA-03137 [message #582171 is a reply to message #582170] Mon, 15 April 2013 03:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: ORA-03137 [message #582180 is a reply to message #582171] Mon, 15 April 2013 08:06 Go to previous messageGo to next message
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

Re: ORA-03137 [message #582187 is a reply to message #582180] Mon, 15 April 2013 08:46 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Any other way without contact oracle support services
no other way
Re: ORA-03137 [message #582733 is a reply to message #582187] Mon, 22 April 2013 06:05 Go to previous messageGo to next message
nlnkapardi
Messages: 26
Registered: April 2013
Location: India
Junior Member

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





Re: ORA-03137 [message #651211 is a reply to message #582733] Thu, 12 May 2016 16:40 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: ORA-03137 [message #651214 is a reply to message #651211] Thu, 12 May 2016 17:38 Go to previous message
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:
  


Current Time: Thu Mar 28 15:43:44 CDT 2024