Re: RAC -- unable to Connect using service name
Date: Wed, 28 Mar 2012 10:59:54 -0700
Message-ID: <CAEbHM45SsC3EeFYLUkg0NEL4bW4mT2V5tWxo5zm_Hv_GbqnU4w_at_mail.gmail.com>
What I meant by manually rewriting the listener.ora file, was to create a new file and line by line, manually type out the desired entries. However, I have only seen this help when the original file was in some way manually created or altered to begin with (e.g. someone created it via copy/paste)
If this is the original file that was all created automatically, then unfortunately, a rewrite probably wouldn't help (& could inadvertently add an error).
Does the listener log show anything?
Does the connection with "tibco" work?
On Wed, Mar 28, 2012 at 9:53 AM, 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-lReceived on Wed Mar 28 2012 - 12:59:54 CDT