Re: RAC -- unable to Connect using service name

From: Krishna <krishna.setwin_at_gmail.com>
Date: Wed, 28 Mar 2012 12:53:46 -0400
Message-ID: <CAF6DRCpt8mvOULQ1PMi98NXEiFi_eW4NwnJ9TghZ2U9JR3xFcA_at_mail.gmail.com>

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

Received on Wed Mar 28 2012 - 11:53:46 CDT