#19129 [Fbk->NoF]: Oracle 'ORA-12541: TNS:no listener' causes OCI8 to break

ID: 19129 Updated by: sniper@php.net Reported By: dante.lorenso@atmosenergy.com -Status: Feedback +Status: No Feedback Bug Type: OCI8 related Operating System: RedHat Linux 7.3 PHP Version: 4.2.1 New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. Previous Comments: ------------------------------------------------------------------------ [2002-09-13 11:59:11] thies@php.net plz send me a minimal _SELF_CONTAINED_ (= complete) script that i can run on my dev-box. ------------------------------------------------------------------------ [2002-09-12 09:20:11] dante.lorenso@atmosenergy.com I can't let you inside the firewall to see the problem first-hand, but I'll run any tests you want. Here is some phpinfo() for you: ---------- System ---------- Linux dfw1wu19 2.4.18-5 #1 Mon Jun 10 15:31:48 EDT 2002 i686 unknown ---------- Build Date ---------- Jul 10 2002 11:11:19 ---------- Configure Command ---------- './configure' '--with-oracle=/opt/app/oracle/product/8.1.5' '--with-oci8=/opt/app/oracle/product/8.1.5' '--enable-sigchild' '--with-ldap' '--with-gd' '--with-config-file-path=/www/apache/conf/php' '--with-apache=../apache_1.3.26/' '--enable-track-vars' '--enable-bcmath' '--enable-ftp' ---------- Server API ---------- Apache ---------- Virtual Directory Support ---------- disabled ---------- Configuration File (php.ini) Path ---------- /www/apache-1.3.26_ssl/conf/php/php.ini ---------- Debug Build ---------- no ---------- Thread Safety ---------- disabled ------------------------------------------------------------------------ [2002-09-12 04:58:12] thies@php.net seems to work for me (oracle 9.2.0.1) any chance i could get a login on your box to see the problem? ------------------------------------------------------------------------ [2002-09-12 04:58:12] thies@php.net seems to work for me (oracle 9.2.0.1) any chance i could get a login on your box to see the problem? ------------------------------------------------------------------------ [2002-08-27 15:05:08] dante.lorenso@atmosenergy.com I use the following code to loop through an array of SIDs for Oracle...and attempt to change the password for a given username on each Oracle database... ================================================== foreach ($names as $SID => $CONN_SID) { // make a connection $dbconn = @OCINLogon($username, $old_password, $SID); if (! $dbconn) { $this->dumpError("ORAPASS[OCILogon]"); continue; } // parse the SQL statement... $sql_statement = @OCIParse($dbconn, $sql); if (! $sql_statement) { error_log("ORAPASS[OCIParse]"); @OCILogOff($dbconn); continue; } // execute sql query $exec_result = @OCIExecute($sql_statement); if (! $exec_result) { error_log("ORAPASS[OCIExecute]"); @OCILogOff($dbconn); continue; } // disconnect... @OCILogOff($dbconn); unset($dbconn); // show the results... $text .= sprintf ('Success: %s<br>', $SID); } ================================================== However, for some reason if the SID I connect to results in the following OCIError: Failed: SID1 (ORA-12541: TNS:no listener) Then, all subsequent OCINLogon or OCILogon calls will result in this error message: Failed: SID2 (ORA-12154: TNS:could not resolve service name) If I restart Apache/PHP and connect to SID2, it will work, but if I connect to any SID after getting the 'ORA-12541: TNS:no listener' error, my Oracle connections all fail. --Dante ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=19129&edit=1