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