note 54508 modified in function.oci-connect by sixd

From: Date: Wed, 09 Dec 2009 22:26:35 +0000
Subject: note 54508 modified in function.oci-connect by sixd
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-163779@lists.php.net to get a copy of this message
I spent ages trying work out why I was getting the following message when when using ocilogon() on Windows 2000 using PHP 4 and 5: ORA-03106 Fatal two-task communication protocol error This problem is occurs when PHP cannot find ORACLE client environmental variables. The environmental variables can be set in several ways: 1. Within the root 'Directory' directive on Apache httpd.conf: <Directory "d:/path/to/webroot"> SetEnv ORACLE_BASE "c:/oracle" SetEnv ORACLE_HOME "c:/oracle/ora81" SetEnv NLS_LANG "american_america.WE8DEC" SetEnv NLS_CHARACTERSET "WE8DEC" SetEnv NLS_NCHAR_CHARACTERSET "AL16UTF16" </Directory> or 2. Within Windows: Go to the Control Panel>System>Advanced>Environmental Variables Then enter a name value/pair for each of the variables. 3. Using putenv() statements in the PHP file prior to using ocilogon(). This is not ideal because the statements are required evertime you wish to connect to Oracle. --was-- I spent ages trying work out why I was getting the following message when when using ocilogon() on Windows 2000 using PHP 4 and 5: ORA-03106 Fatal two-task communication protocol error This problem is occurs when PHP cannot find ORACLE client environmental variables. The environmental variables can be set in several ways: 1. Within the root 'Directory' directive on Apache httpd.conf: <Directory "d:/path/to/webroot"> SetEnv ORACLE_BASE "c:/oracle" SetEnv ORACLE_HOME "c:/oracle/ora81" SetEnv NLS_LANG "american_america.WE8DEC" SetEnv NLS_CHARACTERSET "WE8DEC" SetEnv NLS_NCHAR_CHARACTERSET "AL16UTF16" </Directory> or 2. Within Windows: Go to the Control Panel>System>Advanced>Environmental Variables Then enter a name value/pair for each of the variables. 3. Using putenv() statements in the PHP file prior to using ocilogon(). This is not ideal because the statements are required evertime you wish to connect to Oracle. http://php.net/manual/en/function.oci-connect.php

« previous php.notes (#163779) next »