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
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