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

please make sure that you set you oracle-specific environmet variables *before* you start your apache and not using php's PutEnv() function (ORACLE_HOME, ORACLE_SID, NLS... etc) report if the problem persists. On Wed, May 03, 2000 at 03:14:58PM -0000, chris_milner@hotmail.com wrote: > 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 > > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany