When ANO is Enabled, OXTA (and SOA Gateway) Fail with Error "Protocol Violation" (Doc ID 1507543.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle XML Gateway - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle E-Business Suite Integrated SOA Gateway - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

After enabling ANO (Advanced Networking Option) to have connection to the database encrypted, OXTA fails with:

[Jul 12, 2012 3:33:32 AM PDT]:1342089212255:-1:-1:....:....:oafm.default_group.2:725974204:-1:-1:ANONYMOUS(-1):-1:Thread[Thread-6,5,main]:....:11855:1342089212257:1:UNEXPECTED:[ecx.oxta.TransportHandler.run]:Closing this Connection because of the SQLException :java.sql.SQLException: Protocol violation
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
at oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:898)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:656)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:184)
at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:873)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1161)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3093)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4286)
at oracle.apps.ecx.oxta.OXTAQueueImpl.deQueue(OXTAQueueImpl.java:88)
at oracle.apps.ecx.oxta.TransportHandler.run(TransportHandler.java:122)
..
[Jul 12, 2012 3:35:26 AM PDT]:1342089326708:-1:-1:....:....:oafm.default_group.2:725974204:-1:-1:ANONYMOUS(-1):-1:Thread[Thread-65,5,main]:....:11855:1342089266703:2:UNEXPECTED:[ecx.oxta.TransportAgentMain.clientMain]:TransportHandler Thread 0 is dead. This is the 2 time a thread has died. Creating new.
[Jul 12, 2012 3:35:26 AM PDT]:1342089326727:-1:-1:....:....:oafm.default_group.2:725974204:-1:-1:ANONYMOUS(-1):-1:Thread[Thread-76,5,main]:....:11855:1342089326727:4:UNEXPECTED:[ecx.oxta.TransportHandler.run]:Closing this Connection because of the SQLException :java.sql.SQLException: Bigger type length than Maximum
  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
  at oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:898)

 

Changes

 Enabled ANO (Advanced Networking Option) to have encrypted connections to the database.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms