I'm assuming you're under Unix.  Make sure you can use sqlplus as the
webserver user (nobody under most Linuxes).  I had to add the Oracle_home
env variable to the system .profile script.  Also try setting Oracle_home
inside the httpd.conf script (SetEnv?) 

For windows users having the ORA-12154 error in PHP, upgrade to the Oracle
8.1.6 client, it seems to fix everything.  (Many, many, MANY thanks to the
user that suggested that, it saved me from having to port all my stuff
to ASP.)


On Mon, 26 Feb 2001, Kevin Porter wrote:

> Hi,
> We're moving a web site to new servers. We've recreated the DB and imported
> all the data from the old
> database. I've compiled a new Apache/PHP (1.3.9 / 4.0.1pl2). tnsnames.ora is
> set up correctly as far as we
> can tell, but I'm _still_ getting the dreaded 12154 error.
> We cannot see anything wrong. We've tried shutting down the web server, then
> the DB server and listener,
> then starting DB and listener, then starting Apache, but this has not
> worked.
> We have $ORACLE_HOME set, and we can log into the DB perfectly OK with
> sqlplus (as oracle8i user).
> Any ideas anyone?
> thanks in advance,
> - Kev
> --
> http://www.megasoccer.com - Global Soccer
> http://www.fa-premier.com - English Premier League Football

"The greatest dangers to liberty lurk in insidious enroachment by mean of
zeal, well-meaning but without understanding."
-- Justice Louis O. Brandeis, Olmstead vs. United States

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to