PHP 4.0 Bug #4307: OCILogon often causes ORA-12154 TNS error

From: Date: Wed, 03 May 2000 15:14:58 +0000
Subject: PHP 4.0 Bug #4307: OCILogon often causes ORA-12154 TNS error
Groups: php.dev 
Request: Send a blank email to php-dev+get-18385@lists.php.net to get a copy of this message
From: chris_milner@hotmail.com Operating system: Sun Solaris 5.7 PHP version: 4.0 Release Candidate 1 PHP Bug Type: Oracle related Bug description: OCILogon often causes ORA-12154 TNS error When the Apache server is rebooted, this OCILogon call works. After a few attempts, it fails with the error message below: Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name in /opt/www/shopsmart/uk/htdocs/connect_test.html on line 12 connect_test.html just has a simple OCILogon call to the database. The client and server Oracle software is set up with Net8 and works fine, it's only from the browser the error occurs. No tracing is produced at the Net8 level for the error. If I leave a refresh for a minute or so, it will reconnect OK, but if I try and reconnect frequently, I always get the error message. Oracle Support seem to be washing their hands of this, can anyone give me any help. Regards Chris

« previous php.dev (#18385) next »