Monday, 25 March 2013

ORA-03106: fatal two-task communication protocol error

Error:

ORA-24330: internal OCI error
ORA-03106: fatal two-task communication protocol error
ORA-03114: not connected to ORACLE


Where: Error logged on oracle 11.2.0.2 client application server. Application based on c/c++ coding. Solaris 10 SPARC

Database 11.2.0.2 compatible, Solaris 10 SPARC

Background:
ORA-24330: internal OCI error & ORA-03114: not connected to ORACLE errors caused due to session disconnection byORA-03106: fatal two-task communication protocol error

Solution:
1. Set db_securefile to PERMITTED & re-create all LOB data type tables (Workaround)
2. Replace blank row column values of the table by some value or NULL flag, and enable NOT NULL constraint for those columns

Lesson Learned:

As the parameter db_securefile default value is PERMITTED , which got changed to ALWAYS as a part if databasehardening as per CSI benchmark 11g


Need to have proper testing & review from application after DB hardening
 
NOTE:-- If need more details please check below blog:-
http://www.moreajays.com/2013/03/ora-03106-fatal-two-task-communication.html
 
 

No comments:

Post a comment