Re: RAC -- unable to Connect using service name
Date: Wed, 28 Mar 2012 18:42:09 -0700 (PDT)
You can set up your sqlnet.ora file to automatically add that to the service name you specify.
From: Krishna <krishna.setwin_at_gmail.com> To: Niall Litchfield <niall.litchfield_at_gmail.com> Cc: kathryn axelrod <kat.axe_at_gmail.com>; Chandra Pabba <Chandra_Pabba_at_verizon.net>; Oracle List <oracle-l_at_freelists.org> Sent: Wednesday, March 28, 2012 4:43 PM
Subject: Re: RAC -- unable to Connect using service name
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...
On Wed, Mar 28, 2012 at 3:56 PM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:
> 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
>> On Wed, Mar 28, 2012 at 11:56 AM, kathryn axelrod <kat.axe_at_gmail.com>
>> > 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.)
> Niall Litchfield
> Oracle DBA