note 79919 deleted from oci8.installation by cmb
| From: | cmb@php.net | Date: | Sun, 20 Oct 2019 08:52:14 +0000 |
| Subject: | note 79919 deleted from oci8.installation by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-212701@lists.php.net to get a copy of this message | ||
Note Submitter: ashnazg at php dot net
----
Do not underestimate the importance of NLS_LANG in your environment.
The Oracle error "ORA-03106: fatal two-task communication protocol error" is indicative of
not having NLS_LANG set.
In my case, I had a successfully processing INSERT statement followed by a failing SELECT statement
that was resulting in that ORA-03106 error. The successful INSERT implied that all Oracle
environment settings were fine. Ultimately we found that the NLS_LANG was not set, and I have to
assume that only the SELECT of data back from the database actually _needed_ it, and therefore it
was the SELECT statement that triggered the failure. Though, that is all speculation.