OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » TNSNAMES.ORA

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNSNAMES.ORA [message #281816]

Mon, 19 November 2007 07:00

gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA

Senior Member

Hi,
I'm bit confused with TNSNAMES.ORA file. i.e. When I was connecting my database from my client location(UK) with service name "utv015"(as it is in tnsnames.ora), it was working fine. But when I try to connect the same database with same service name and setting from India it is not connecting even within the same client network. However If I change the tnsnames.ora file to reflect the service name to "utv015, utv015.seml.xyz.net = ( blaa..bla...)"(only the service name not other information) and connect the database with service name "utv015.seml.xyz.net", it is responding. I am just wondering with what is happening here as this name is simply an alias.

What is the impact of this service name??

//Thangam

Report message to a moderator

Re: TNSNAMES.ORA [message #281847 is a reply to message #281816]

Mon, 19 November 2007 09:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

The difference is between listener.ora between the two sites.

Report message to a moderator

Re: TNSNAMES.ORA [message #281852 is a reply to message #281847]

Mon, 19 November 2007 09:49

gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA

Senior Member

Anyhow we are connecting the same server which is placed in UK regardless of whether I am connecting from India or UK. so why it is this difference?

//Thangam

Report message to a moderator

Re: TNSNAMES.ORA [message #281854 is a reply to message #281816]

Mon, 19 November 2007 09:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>so why it is this difference?
The difference is between listener.ora between the two sites.

Report message to a moderator

Re: TNSNAMES.ORA [message #282006 is a reply to message #281854]

Tue, 20 November 2007 06:14

gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA

Senior Member

I'm bit confused here. As I have only one server, eventually I should have only one listener.ora file in the server side(UK), right? How come this difference happen between the sites. Please explain me bit details. If I want to resolve it, what should I do?

Report message to a moderator

Re: TNSNAMES.ORA [message #282008 is a reply to message #282006]

Tue, 20 November 2007 06:27

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Can you post here your both tnsnames.ora files.

Report message to a moderator

Re: TNSNAMES.ORA [message #282038 is a reply to message #281816]

Tue, 20 November 2007 09:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I was juggling too many balls yesterday & gave an incorrect response.
The problem is that the sqlnet.ora files are different between the two systems where the client s/w (yet unnamed) is invoked.

Report message to a moderator

Re: TNSNAMES.ORA [message #282569 is a reply to message #282038]

Thu, 22 November 2007 06:53

gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA

Senior Member

Wov... It finally works when I change the sqlnet.ora file.

Thank you very much!!!!!!

Report message to a moderator

Re: TNSNAMES.ORA [message #282577 is a reply to message #282569]

Thu, 22 November 2007 07:13

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

what you changes in sqlnet.ora file ???

Report message to a moderator

Re: TNSNAMES.ORA [message #282588 is a reply to message #282577]

Thu, 22 November 2007 07:38

gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA

Senior Member

Actually I did not change anything in sqlnet.ora file. I simply got rid of this file from ORACLE_HOME/network/admin folder.

//Thangam

Report message to a moderator

Re: TNSNAMES.ORA [message #282589 is a reply to message #282588]

Thu, 22 November 2007 07:40

gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA

Senior Member

Because I could see the content "NAMES.DEFAULT_DOMAIN = emea.xyz.net" in sqlnet.ora file.

//Thangam

Report message to a moderator

Re: TNSNAMES.ORA [message #282590 is a reply to message #282589]

Thu, 22 November 2007 07:42

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Thank You. Smile

Report message to a moderator

Previous Topic:	HS ODBC set isolation level when reading from ext non oracle db
Next Topic:	ORA-12516: TNS:

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 22:46:13 CDT 2025