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????
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.