php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #4307 OCILogon often causes ORA-12154 TNS error
Submitted: 2000-05-03 11:14 UTC Modified: 2006-07-17 08:08 UTC
Votes:1
Avg. Score:3.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: chris_milner at hotmail dot com Assigned:
Status: No Feedback Package: OCI8 related
PHP Version: 4.0 Release Candidate 1 OS: Sun Solaris 5.7
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2000-05-03 11:14 UTC] chris_milner at hotmail dot com
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

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-05-13 08:03 UTC] thies at cvs dot php dot net
please set all oracle-relates environment variables *before* you start your apache process! do not use SetEnv in httpd.conf not PutEnv() in your php-script to set eny of those!
 [2004-03-13 11:43 UTC] phpdotnet dot hannes at erven dot at
I experienced exactly the same problem.

We had approx. 50% ORA-12541 and 50% "good" connects with an uppercase SID, and the problem seems to vanish if you specify an all-lowercase SID.
 
PHP Copyright © 2001-2017 The PHP Group
All rights reserved.
Last updated: Sun Nov 19 01:31:42 2017 UTC