Hi Steve,

Insert the below lines in the top of your web server tnsnames.ora file. I too had a similar problem few days back and resolved in this way.

I presume you have already set SERVICE_NAMES & LOCAL_LISTENER values in the Database.

LISTENER =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxxx)(PORT = 1521))

Thanks,