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
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: chris_milner at hotmail dot com
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2024 The PHP Group
All rights reserved.
Last updated: Tue Oct 15 22:01:26 2024 UTC