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