Re: RAC -- unable to Connect using service name

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: krishna.setwin@xxxxxxxxx
  • Date: Wed, 28 Mar 2012 20:56:56 +0100

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


Other related posts: