Home » RDBMS Server » Networking and Gateways » TNSNAMES.ORA
TNSNAMES.ORA [message #281816] Mon, 19 November 2007 07:00 Go to next message
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
Re: TNSNAMES.ORA [message #281847 is a reply to message #281816] Mon, 19 November 2007 09:08 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
The difference is between listener.ora between the two sites.
Re: TNSNAMES.ORA [message #281852 is a reply to message #281847] Mon, 19 November 2007 09:49 Go to previous messageGo to next message
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
Re: TNSNAMES.ORA [message #281854 is a reply to message #281816] Mon, 19 November 2007 09:53 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>so why it is this difference?
The difference is between listener.ora between the two sites.
Re: TNSNAMES.ORA [message #282006 is a reply to message #281854] Tue, 20 November 2007 06:14 Go to previous messageGo to next message
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?
Re: TNSNAMES.ORA [message #282008 is a reply to message #282006] Tue, 20 November 2007 06:27 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Can you post here your both tnsnames.ora files.
Re: TNSNAMES.ORA [message #282038 is a reply to message #281816] Tue, 20 November 2007 09:16 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: TNSNAMES.ORA [message #282569 is a reply to message #282038] Thu, 22 November 2007 06:53 Go to previous messageGo to next message
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!!!!!!
Re: TNSNAMES.ORA [message #282577 is a reply to message #282569] Thu, 22 November 2007 07:13 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

what you changes in sqlnet.ora file ???
Re: TNSNAMES.ORA [message #282588 is a reply to message #282577] Thu, 22 November 2007 07:38 Go to previous messageGo to next message
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
Re: TNSNAMES.ORA [message #282589 is a reply to message #282588] Thu, 22 November 2007 07:40 Go to previous messageGo to next message
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
Re: TNSNAMES.ORA [message #282590 is a reply to message #282589] Thu, 22 November 2007 07:42 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Thank You.Smile
Previous Topic: HS ODBC set isolation level when reading from ext non oracle db
Next Topic: ORA-12516: TNS:
Goto Forum:
  


Current Time: Thu Dec 08 08:22:40 CST 2016

Total time taken to generate the page: 0.07787 seconds