Re: RAC -- unable to Connect using service name
Date: Wed, 28 Mar 2012 10:59:54 -0700
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
> 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.)