Re: RAC -- unable to Connect using service name

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 28 Mar 2012 20:56:56 +0100
Message-ID: <CABe10sY2+dVW30KP2PcjD4seBAxJb6oRNUy3wMH_yAQ_tEEf7A_at_mail.gmail.com>

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_at_gmail.com> 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_at_gmail.com>
> wrote:
>
> > Is there an entry in the tnsnames in the home you are running "sqlplus
> > system/******_at_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.)
> >
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 28 2012 - 14:56:56 CDT