Posted by: null January 14, 2008
DBAs Assistance Required
Login in to Rate this Post:     0       ?        
what does "lsnrctl status" say?  Check if you are using the right service name as shown in that output in tnsnames.ora.  Try to set TNS_ADMIN environment variable, if there are multiple ORACLE_HOME
Read Full Discussion Thread for this article