ORA-12155: TNS:received bad datatype in NSWMARKER packet

The following error was recently reported to my DBA team  :
ORA-12155: TNS:received bad datatype in NSWMARKER packet

While trying to execute a sql query select, the developers were not able to get the response while this very query runs out-of-the-box on the server where the requested database is located.

You might have the following message as well (if your are using JDBC Thin 10.2.0.2) :

Exception in thread “main” java.sql.SQLException: ORA-12155: TNS:received bad
datatype in NSWMARKER packet
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.process Error(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.process Error(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive( T4C8Oall.java:743)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:95 4)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1060)
at oracle.jdbc.driver.T4CCallableStatement.executeMaybeDescribe(T4CCallableStatement.j ava:838)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement. java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.jav a:3361)
at QueryTimeoutTest2.executeQuery(Query TimeoutTest2.java:196)
at QueryTimeoutTest2.selectForUpdate(Qu eryTimeoutTest2.java:114)
at QueryTimeoutTest2.main(QueryTimeoutT est2.java:58)

According to Metalink, here is the solution to implement :

1. Dowload JDBC 10.2.0.3 from:
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
2. Set the correct jdbc driver jar file in the CLASSPATH variable based on the JDK used.
For JDK 1.3, please use classes12.jar
For JDK 1.4 and 1.5, please use ojdbc14.jar.


More information : Metalink Doc. Id  433190.1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s