Yes, I changed service name(to test.domain) in tnsnames.ora and now I dont get that error. Should I always use test.domain.com as service name? what changes should I have to do to avoid the domain extension in the service name?? please let me know Thanks everybody for helping me... krishna On Wed, Mar 28, 2012 at 3:56 PM, Niall Litchfield < niall.litchfield@xxxxxxxxx> wrote: > Krishna > > The error you are receiving means that you are asking to connect to a > different service name than the one the listener knows. The listener knows > about test.domain.com : I suggest you check what the tnsnames entry that > has the alias "test" refers to. > > On Wed, Mar 28, 2012 at 5:53 PM, Krishna <krishna.setwin@xxxxxxxxx> wrote: > >> Yes, I have an entry in tnsnames.ora for "test" >> I have attached tnsnames.ora && listener.ora >> I will rewrite tnsnames.ora... >> How to re-write listener.ora ?? >> >> please let me know >> >> Krishna >> >> On Wed, Mar 28, 2012 at 11:56 AM, kathryn axelrod <kat.axe@xxxxxxxxx> >> wrote: >> >> > Is there an entry in the tnsnames in the home you are running "sqlplus >> > system/******@test" from? >> > >> > If so, I have also seen a situation where everything appeared proper >> > but the db gave an ORA-12514 and the fix was to manually (no >> > copy/paste) rewrite the listener.ora entry. Apparently it had some >> > hidden character/space/other format glitch that caused issues as the >> > rewrite fixed it. (Manually rewriting the tnsnames entry is worth >> > trying as well.) >> > >> >> >> >> -- >> //www.freelists.org/webpage/oracle-l >> >> >> > > > -- > Niall Litchfield > Oracle DBA > http://www.orawin.info > -- //www.freelists.org/webpage/oracle-l