#23585 [Opn->Bgs]: TNS 12154 sometimes occuring

ID: 23585 Updated by: magnus@php.net Reported By: flop dot m at usa dot net -Status: Open +Status: Bogus Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 4.3.1 New Comment: Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Because of this, we hope you add your comments to the existing bug instead. Thank you for your interest in PHP. See bug #19517 Previous Comments: ------------------------------------------------------------------------ [2003-05-11 16:52:25] flop dot m at usa dot net Hello, Same as bug #19517 I'm having the same trouble (not always, but often - when server is receiving lots of user queries). TNS-12154 when executing OCILogon method. It seems that an error occurs at the same time on the Oracle side, at least, in the sqlnet.log, some errors is logged, and I could not find the description of that error on Oracle's web site. Thus, I changed my OCILogon from OCILogon('user', 'pass', 'tns alias'); to $tns = <the actual line describing my listener from the tnsnames.ora file>; OCILogon('user', 'pass', $tns); and bingo, no more crashes ;) My guess is when PHP sends too many lookups in a short time, something in the oci call crashs. So, is it in PHP side, or Oracle side, I don't know. I hope this will help to pinpoint/correct that pretty much annoying bug. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=23585&edit=1