OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Tns names problem

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

Tns names problem [message #4886]

Sat, 18 January 2003 10:27

Vivek nath
Messages: 9
Registered: August 2002

Junior Member

I am getting a problem that when i try to supply the HostString value and log on to the database ,it throws me a TNS Names error but if i do not supply any value in that ,it allows me to connect.In this case i m trying to connect to my local machine database and not any external one.

Report message to a moderator

Re: Tns names problem [message #4888 is a reply to message #4886]

Sat, 18 January 2003 19:51

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

first,
if you can database and client in the same machine
you no need HostString.
if you intend to use one,
you have to edit tnsnames.ora and add entries.
If something goes wrong with tnsnames.ora entries,
u will get the tnsnames error

Report message to a moderator

Re: Tns names problem [message #4890 is a reply to message #4886]

Sat, 18 January 2003 23:29

Vivek nath
Messages: 9
Registered: August 2002

Junior Member

Yes i know that i do not need it but if i have to connect to remote machine i do need that and i have made the relevant entries in my tnsnames.ora file still i get the Tns names error and thats the reason i have ben trying to test if it connects to my local with by giving it some host string.Now is there any way around..

Report message to a moderator

Previous Topic:	could not resolve service name
Next Topic:	Listener consuming lot of CPU

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 02:13:43 CDT 2025