Re: RAC -- unable to Connect using service name

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Wed, 28 Mar 2012 18:42:09 -0700 (PDT)
Message-ID: <1332985329.99733.YahooMailNeo_at_web160902.mail.bf1.yahoo.com>

You can set up your sqlnet.ora file to automatically add that to the service name you specify.  
David Fitzjarrell
 

---

 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...

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
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 28 2012 - 20:42:09 CDT