I am running an LMS with a web server and a database server. Oracle is obiously running on the database server. Here's what's happening.

Using Enterprise Manager (on the Oracle server), it states that the database is up. It also shows that the Listener is up and running correctly. When I run a listener check using Oracle Net Manager, the test runs as successful.

However, from the web server, when I used the Oracle Enterprise Manager Client edition, I cannot access that database. I receive the ORA-12514 error ("The listener does not currently know of the service requested").

There is connectivity between the two servers and the web server's Enterprise Manager Client can "see" the database, I just can't open it from the web server.

Soooo... the database server says the database and listener are fine, but the web server says the listener on for the database can't see it.

Any ideas on where to check? Thanks!

Steve M.