ORA-12514: tns: LISTENER COULD NOT RESOLVE SERVICE_NAME GIVEN IN CONNECT DESCRIPTOR

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

thanks for your quick response, SQLnet and TNsnames are correct. The reason I know it's correct b/c after a while to troubleshoot, I used the database configuration assistant to create another database, the new database works fine and I copy the connect string of this database and change the SERVICE_NAME and connect string to the one I have the problem with, but it's still not working.

I am runng two Oracle_home on this box(8i,9i) anything special I have to be aware????

Ashley,
If I am correct you are running
1.two listeners from different home...?.
2.Have only one listener.ora file...(Better have entry for both)
If that is the case ...Try...starting the listener from 9i $ORACLE_HOME...ofcourse both the listerners....

As pando had pointed out, the issue should be on the way the service names had been defined. Check your pfile/initSID.ora file and make sure that the service name in that would match the service name that you have defined in the listener.ora and that of the tnsnames.ora file.