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
's ok, we've sorted it now...
we had installed the oracle s/w in oracle8i user's home directory - we had
to set permissions of that
to 755. Then, we found we hadn't installed the right language options on the
client installations (web
server box), so we're nearly there now.
- Kev
""Kevin Porte
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 w