| 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
|
|
|
|
|
|
| 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
|
|
|
|
|
|
| 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?
|
|
|
|
|
|
|
|
|
|
|
|
| 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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
