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