Re: RAC -- unable to Connect using service name

  • From: kathryn axelrod <kat.axe@xxxxxxxxx>
  • To: krishna.setwin@xxxxxxxxx
  • Date: Wed, 28 Mar 2012 08:56:40 -0700

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


Other related posts: