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

go to bug id or search bugs for

Bug #24911 intermittent error conecting to oracle
Submitted: 2003-08-01 15:42 UTC Modified: 2003-08-13 15:00 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: nilza at mg dot gov dot br Assigned:
Status: Not a bug Package: Oracle related
PHP Version: 4.3.2 OS: Solaris 8
Private report: No CVE-ID: None
View Developer Edit
 [2003-08-01 15:42 UTC] nilza at mg dot gov dot br 
Description:
------------
Oracle=7.3.4 in another server
Apache/1.3.9 (Unix) PHP/4.3.2 mod_perl/1.21 

PHP was compiled with:

'./configure' '--with-apxs=/usr/apache/bin/apxs' '--enable-track-vars' '--with-oracle=/produtos/ora_tmp' '--enable-sigchild' '--without-mysql' 

No errors on compilation and no errors to start apache.
It works most fine some time, but we got intermittent errors:

ORA-12154 (main error)

and in error_log file of apache these messages:

[Fri Aug  1 17:18:43 2003] [info] [client 10.17.206.4] (32)Broken pipe: client stopped connection before send mmap completed
[Fri Aug  1 17:21:06 2003] [info] [client 192.168.168.48] (32)Broken pipe: client stopped connection before rwrite completed

All my oracle environment variables are set before the apache start, my user nobody belongs to the group dba and the session.trans_sid is set to on.

Can someone help me?

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-08-01 20:28 UTC] sniper@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.
 [2003-08-04 08:43 UTC] nilza at mg dot gov dot br 
What I did:

<?php
$con = ora_logon( "ssaf@titanio" , "ssaf" );
?>

What I wanted to happen:

A connection to the oracle. The oracle is Ok and the listener too. All the environment variables are ok and the
tnsname.ora is correct.

titanio.world =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= titanio)(Port= 1527))
    (CONNECT_DATA = (SID = bdo))
  )


What actually happened:

Some times (in a intermittent way) I got the message:

Warning: Oracle: Connection Failed:ORA-12154: TNS:could not resolve service name in /web/sipnet/IndexUsu/connect.inc on line 2

The connect.inc is the code listed above (What I did).
There is no problem with Oracle when this message happens.
If I try again I usually can connect to Oracle.
As I told you in the first message, I noticed the following messages in Apache log:

[Fri Aug  1 17:18:43 2003] [info] [client 10.17.206.4] (32)Broken pipe:
   client stopped connection before send mmap completed
   [Fri Aug  1 17:21:06 2003] [info] [client 192.168.168.48] (32)Broken
   pipe: client stopped connection before rwrite completed

Thanks for your help.
 [2003-08-11 00:17 UTC] sniper@php.net 
There are many reasons why this happens, maybe this solution works for you:

http://www.macromedia.com/support/coldfusion/ts/documents/tn17267.htm

(yes, I know it's for coldfusion :)
 [2003-08-11 00:21 UTC] sniper@php.net 
I'm pretty sure this is not PHP problem.
Try searching for "ORA-12154" from google to see why..
 [2003-08-13 15:00 UTC] nilza at mg dot gov dot br 
I had already tried put the server name in /etc/hosts which is searched before dns.
I found a reference of a similar problem that hapens when there are very fast solicitations to oracle listener, that exceed the backlog. It?s determined by the QUEUESIZE parameter in listener.ora file. I?m searching how to change it and I?ll try this possibility.
Thanks.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Mon Dec 30 14:01:28 2024 UTC