PHP 4.0 Bug #8984 Updated: Intermittent TNS-12154 (cannot resolve service name) error

ID: 8984 Updated by: sniper Reported By: danab@mail.gonext.co.il Status: Open Old-Bug Type: Oracle related Bug Type: OCI8 related Assigned To: Comments: reclassified Previous Comments: --------------------------------------------------------------------------- [2001-01-29 11:27:27] danab@mail.gonext.co.il This is basically a rehash of bugs #4307, #5569 & #8232. Running PHP 4.0.1pl1 as an Apache 3.1.12 module, I often run into this problem during OCILogon() calls. Regarding the solution to #4307 - ALL oracle-related env vars I can think of are set before Apache is started. The /etc/rc3.d script that starts apache sources a file setting the lot of them before starting the server. The solution I saw in #5569 - make user "nobody" a member of group "dba" - is, frankly, unacceptable (and I haven't even tried it). I have a public portal to run, and can't afford the secrity hole. Essentially, I am also reiterating bug report #8232, which I see has remained open for over a month now. The problem appears intermittently in virtually all places that OCILogon() is used, so I see now point in osting yet another code example. Any help will be appreciated. Thanks, Dan Abarbanel, GoNext Ltd. Israel --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=8984