Re: RAC -- unable to Connect using service name
- From: kathryn axelrod <kat.axe@xxxxxxxxx>
- To: Krishna <krishna.setwin@xxxxxxxxx>
- 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@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
Other related posts:
