php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #23585 TNS 12154 sometimes occuring
Submitted: 2003-05-11 16:52 UTC Modified: 2003-05-12 01:47 UTC
From: flop dot m at usa dot net Assigned:
Status: Not a bug Package: OCI8 related
PHP Version: 4.3.1 OS: Windows 2000
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2003-05-11 16:52 UTC] 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.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-05-12 01:47 UTC] magnus@php.net 
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
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat May 11 17:01:35 2024 UTC