Thursday, December 27, 2007

ORA-03106

 Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

===================================================================


ORA-03106: fatal two-task communication protocol error

Cause: The communication path between Oracle and the user task has stopped. This is an internal error message not usually issued.

Action: Contact Oracle Support Services.

Note: There is an ESRI whitepaper about this error.
Subject: Converting from LONG RAW to BLOB in an ArcSDE for Oracle geodatabase
http://support.esri.com/index.cfm?fa=knowledgebase.whitepapers.viewPaper&PID=66&MetaID=1272

The errors can be seen in the sde error log (with SDEVERBOSE turned on).

[Thu Jul 06 12:39:27 2006] [1360] [olive] db_sda_execute_stmt::OCIStmtExecute (3106)
.[Thu Jul 06 12:39:27 2006] [1360] [olive] SDE_Oracle Error: 3106 ORA-03106: fatal two-task communication protocol error
[Thu Jul 06 12:39:27 2006] [1360] [olive] db_array_fetch_spix_recs OCI Fetch Error (3106)
[Thu Jul 06 12:39:27 2006] [1360] [olive] SDE_Oracle Error: 3106 ORA-03106: fatal two-task communication protocol error
[Thu Jul 06 12:39:27 2006] [1360] [olive] db_get_spix_fidlist Fetch Error

All Oracle errors in the blog can be found at: Oracle errors
All ESRI ArcSDE errors in the blog can found at: ArcSDE Errors