Problem when I use TNSNAMES.ORA file to connect with database

Asked By 210 points N/A Posted on -
qa-featured

Hi,

I'm a bit confused with TNSNAMES.ORA file. 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 to 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 what is happening here as this name is simply an alias.

What is the impact of this service name?

Thanks.

SHARE
Answered By 10 points N/A #84919

Problem when I use TNSNAMES.ORA file to connect with database

qa-featured

Hi There,

To answer your queries regarding the Impact, there is NO Impact or whatsoever since you confirm that the connection is still responding . The "utv015.seml.xyz.net" is just a service name that defines a link to a remote server to your (Host = <hostname>). Please see picture below.

If you try to make configuration alteration on the server ($ORACLE_HOME/network/admin/tnsnames.ora) please make certain you can connect to the database throughout the listener if you are logged on to the server. If you build configuration changes on the user in India (c:oracleproduct10.2.0db_1networkadmintnsnames.ora) again, ensure you can connect from your client workstation to the database through the listener in succession on the server. Try to TNSping <addressname>, this is the proper command line for TNSPING. If you can connect with ease, there is nothing you need to worry about.

 

Regards,

A.Wright

About Anderson Wright
Questions
2
Answers
48
Best Answers
11

ORA-01555 caused by SQL statement

Previous

Some Unusual Pixels in Laptop Monitor

Next

Related Questions