ORA-03137: TTC PROTOCOL INTERNAL ERROR : [12333] .... as any body ever see this?
Cristian Cudizio
ORA-03137: TTC PROTOCOL INTERNAL ERROR : [12333] [5] [196] [54] [] []
[] []
On Oracle 11.1.0.6 on AIX 5.3
that causes server process of the session being services to bump
provoking
java.sql.SQLException: No more data to read from socket
at
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:
74)
at
oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:
110)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
171)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
227)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
439)
at oracle.jdbc.driver.T4CMAREngine.getNBytes(T4CMAREngine.java:
1387)
at
oracle.jdbc.driver.T4CMAREngine.unmarshalNBytes(T4CMAREngine.java:
1357)
at
oracle.jdbc.driver.T4CMAREngine.unmarshalBuffer(T4CMAREngine.java:
1895)
at
oracle.jdbc.driver.T4CMAREngine.unmarshalCLR(T4CMAREngine.java:1661)
at
oracle.jdbc.driver.T4CMAREngine.unmarshalCLR(T4CMAREngine.java:1578)
at
oracle.jdbc.driver.T4CMAREngine.unmarshalCLR(T4CMAREngine.java:1792)
at
oracle.jdbc.driver.T4CMAREngine.unmarshalDALC(T4CMAREngine.java:2142)
at oracle.jdbc.driver.T4C8TTIuds.unmarshal(T4C8TTIuds.java:
134)
at oracle.jdbc.driver.T4CTTIdcb.receiveCommon(T4CTTIdcb.java:
169)
at oracle.jdbc.driver.T4CTTIdcb.receive(T4CTTIdcb.java:126)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:988)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:
194)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:
785)
at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:
860)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:
1186)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:
3381)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:
3425)
at
On metalink i've found only 3 occurences of a similar error with no
solution. Our customer has opened a SR
but because the problem is not reproducible and occurs randomly until
now there is no response by
Oracle Support.
It appens with both JDBC thin that JDBC oci drivers
I wonder if somebody else has encountered such error. Also on google
there is little informations.
Regards,
Cristian Cudizio
joel garry
wrote:
> Our customer is having sometimes this error .
> ORA-03137: TTC PROTOCOL INTERNAL ERROR : [12333] [5] [196] [54] [] []
> [] []
>
> On Oracle 11.1.0.6 on AIX 5.3
>
I have no idea what I'm talking about, but are you seeing lots of
things like FIN_WAIT_2 when you do a netstat -a?
I've off and on had a completely different problem on different
hardware, that turned out to be a flaky server that was being talked
to as a background printer spooler process, which would cut off
communication incorrectly, which would take an hour for the tcp layer
to figure out it should kill. This would take away resources from
other processes, with the net effect of random socket errors in the
client/server environment, made much worse by an abusive transaction
monitor.
Perhaps nothing to do with your problem, but such things need to be
considered with random socket errors.
It could also be a bug or OS patch or... I notice metalink lists a
linux bug 7148457, "closed, could not reproduce" with the [12333] [5]
[196] [54]... so up your SR severity, that makes me think Oracle isn't
handling some situation properly, getting the same error parameters on
different platforms, even if the root cause is configuration or non-
Oracle bugs, or even the drivers.
jg
--
@home.com is bogus.
What must the secrets be? http://www.signonsandiego.com/uniontrib/20080829/news_1b29qualcomm.html
Cristian Cudizio
Thanks Joel for tips. We hadn't considered the possibility of network/
socket problems. We have
to investigate more on this. With netstat -a there not a lot of
FIN_WAIT_2 but i must check
when servers are more loaded. With netstat i'va only noticed that on
AIX on
/etc/services there are this two lines:
ncube-lm 1521/tcp # nCube License
Manager
ncube-lm 1521/udp # nCube License
Manager
while having oracle listener on port 1521.
I've also to put up the SR serverity to make Oracle Support handling
the request.
Fletch
corresponding
javax.servlet.ServletException: [17410] java.sql.SQLException: No more
data to read from socket
We too have had a case open with Oracle - but with the random
unreproducible nature of the issue we have not been able to progress
very far with them
I've taken tcpdumps of the inter-connect and its perfectly clean - now
I am looking at the bonded (RedHat) VIP interfaces...
thanks for any feedback,
Fletcher
On 31 Aug, 23:56, Cristian Cudizio <cristian.cudi...@yahoo.it> wrote:
> On 29 Ago, 18:47, joel garry <joel-ga...@home.com> wrote:
>
>
>
> > On Aug 29, 2:33 am, Cristian Cudizio <cristian.cudi...@yahoo.it>
> > wrote:
>
> > > Our customer is having sometimes this error .
> > > ORA-03137:TTCPROTOCOL INTERNAL ERROR : [12333] [5] [196] [54] [] []
Cristian Cudizio
Hi Fletcher,
we still have the problem, it seems proportional to application load.
Have you tried to change JDBC Drivers?
What version of java and jdbc are you using? We have tried also with
10.2.0.4 versions of drivers but without
changes.
I've also heard another person with same problem on Win 64 single
instance, so i think that it's not RAC related.
Is your platform 64 bit?