Re: RAC -- unable to Connect using service name

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


________________________________
 From: Krishna <krishna.setwin@xxxxxxxxx>
To: Niall Litchfield <niall.litchfield@xxxxxxxxx> 
Cc: kathryn axelrod <kat.axe@xxxxxxxxx>; Chandra Pabba 
<Chandra_Pabba@xxxxxxxxxxx>; Oracle List <oracle-l@xxxxxxxxxxxxx> 
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@xxxxxxxxx> 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@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.)
>> >
>>
>>
>>
>> --
>> 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


Other related posts: