PHP 4.0 Bug #4307: OCILogon often causes ORA-12154 TNS error
| From: | chris_milner at hotmail dot com | 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