The dreaded 12154!!

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