#27696 [Opn->Asn]: ORA-24327 error

ID: 27696 Updated by: derick@php.net Reported By: gioppo at csi dot it -Status: Open +Status: Assigned Bug Type: OCI8 related Operating System: System Linux 2.2.19-6.2.1 PHP Version: Irrelevant -Assigned To: +Assigned To: tony2001 Previous Comments: ------------------------------------------------------------------------ [2004-03-25 16:59:39] gioppo at csi dot it I've red the changelog between the 4.3.2 and the actual php version but it doesn't seems to have any mods on oci part. I've red somewhere that the problem could be bacause on oci code could be called the session init before the attach. Really do not understand it how expecially since in the situation where we have just 1 web server everithing goes well but with 4 behind a balancer we get the error. No code change so really getting mad about it, any hint on where to look for more data is appreciated. ORACLE_HOME is set, the tnsname is correct (otherwise we should never connect) going to look also on metalink for some other help. ------------------------------------------------------------------------ [2004-03-25 16:49:07] gioppo at csi dot it Using ADODB project, istanciating this chunk of code: $dbconn = ADONewConnection($dbtype); $dbh = $dbconn->Connect($dbhost, $dbuname, $dbpass, $dbname); This means that the code executed is: $this->_connectionID = OCILogon($argUsername,$argPassword, $argDatabasename); ------------------------------------------------------------------------ [2004-03-25 10:34:58] derick@php.net Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. ------------------------------------------------------------------------ [2004-03-25 10:33:10] gioppo at csi dot it Description: ------------ Making a connection using OCILogon in a webfar with 4 server against a single Oracle DB we get a ORA-24327 error but not everytime. Some time it connects sometimes not. It seems that it should have been correcte on CVS but apparently it doesn' any hint on how to solve this problem? PHP API 20020918 PHP Extension 20020429 Zend Extension 20021010 Thread Safety disabled Apache Version Apache/1.3.29 Apache Release 10329100 Apache API Version 19990320 OCI8 Support enabled Revision $Revision: 1.183.2.5 $ Oracle Version 8.1 Reproduce code: --------------- We use adodb ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=27696&edit=1