OraFAQ Forum: Networking and Gateways » Ora-12154 :Please Help Me

Home » RDBMS Server » Networking and Gateways » Ora-12154 :Please Help Me

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

Ora-12154 :Please Help Me [message #111427]

Wed, 16 March 2005 06:17

JoinNepal
Messages: 33
Registered: October 2003

Member

Hello,
I tried to connect my Database from Delhi but my Database Server in Kathmandu, Nepal.... and the error Ora-12154: TNS:could not resolve service name...............
but I can connect it inside Kathmandu Valley from anywhere once I am able to ping my Private IP of my Server. and Latency rate is about 200 and 300 MS.. But when my Server is Pinged from Delhi it returns the latency rate about 900 MS..................
How can I solve this???? Is it because of the slow connection speed from India and Nepal?
Hope to be answered this question..
Thank you.
Best Regards,
Roshan

Report message to a moderator

Re: Ora-12154 :Please Help Me in Oracle 8i [message #111512 is a reply to message #111427]

Wed, 16 March 2005 23:53

JoinNepal
Messages: 33
Registered: October 2003

Member

This problem is occurring in Oracle 8i..
Thanks..
Urs,
Roshan

Report message to a moderator

Re: Ora-12154 :Please Help Me [message #112547 is a reply to message #111427]

Sun, 27 March 2005 05:50

JoinNepal
Messages: 33
Registered: October 2003

Member

Hi All,
Thank You for ur time to view my problem and FOr ur kind information, I connected my Server here in Kathmandu, Nepal from Delhi, India....
Thank you.
Regards,
Roshan

Report message to a moderator

Re: Ora-12154 :Please Help Me [message #116250 is a reply to message #112547]

Mon, 18 April 2005 17:49

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

can u tell describe us how u were able to solve this problem ?

by the way ....

• ORA-12154: TNS:could not resolve service name: This means that the Net8 client (running on the application’s server) was unable to find what server and database the Net8 alias provided by the application maps to. You should check the tnsnames.ora file on the client to make sure it includes the Net8 alias you wish to use. Also, make sure the tnsnames.ora file is in the right location—typically

$ORACLE_HOME/network/admin.

You should be able to connect to the database immediately after fixing the problem with tnsnames.ora.

sunil

Report message to a moderator

Previous Topic:	ORA-12545 Error "Connect Failed Target host or object does not exist", pls HELP
Next Topic:	oracle Ora-12203 cannot connect to the destination

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 13 00:12:08 CDT 2024