Re: RAC -- unable to Connect using service name

From: Krishna <krishna.setwin_at_gmail.com>
Date: Wed, 28 Mar 2012 20:43:43 -0400
Message-ID: <CAF6DRCqe0UUfi83GOxCKG2+=znqJMXzcP4eL9rTGwX4MrvruEg_at_mail.gmail.com>

Yes, I changed service name(to test.domain) in tnsnames.ora and now I dont get that error.
Should I always use test.domain.com as service name? what changes should I have to do to avoid the domain extension in the service name??

please let me know

Thanks everybody for helping me...

krishna

On Wed, Mar 28, 2012 at 3:56 PM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:

> 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 - 19:43:43 CDT