Re: ORACLE8i+APACHE+PHP error ORA-12154

"Sébastien Le Floc'h" wrote:
>
> Hi, somtimes (once a day...) I encounter error ORA-12154 on my web server.
> I restart apache deamon with apachectl then the error disapears ...
> I connect with php ociplogon.
> When the error appears, it is still possible to connect via sqlplus...

ORA 14154 means: The listener can't identify the service the client wants to connect to. Most often this is due to a wrong client configuration.

In your case it seems to be more tricky. I suggest analyzing the listener log file when this appears (tail -f $ORACLE_HOME/network/log/listener.log). This should give you a good hint what's going wrong at the clients.

Uwe

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Karlsdorfer Str. 31 | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!