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

From: danab@mail.gonext.co.il Operating system: Solaris 2.6 PHP version: 4.0.1pl2 PHP Bug Type: Oracle related Bug description: Intermittent TNS-12154 (cannot resolve service name) error 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 -- Edit Bug report at: http://bugs.php.net/?id=8984&edit=1