ID: 24911
User updated by: nilza at mg dot gov dot br
Reported By: nilza at mg dot gov dot br
-Status: Feedback
+Status: Open
Bug Type: Oracle related
Operating System: Solaris 8
PHP Version: 4.3.2
New Comment:
What I did:
<?php
$con = ora_logon( "[EMAIL PROTECTED]" , "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.
Previous Comments:
------------------------------------------------------------------------
[2003-08-01 20:28:52] [EMAIL PROTECTED]
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-01 15:42:46] 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?
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=24911&edit=1
