OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » connectivity issues

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

connectivity issues [message #230992]

Fri, 13 April 2007 11:45

khushi2000
Messages: 29
Registered: April 2007

Junior Member

I have installed d2k and then installed oracle database. I can connect to oracle database using it's sql plus env. But not able to connect from D2k . It says "TNS could not resolve the service". I copied the tnsnames.ora and sqlnet.ora in database folder to D2k folder. But still it is not working!! what else can be done?Please help

khushi

Report message to a moderator

Re: connectivity issues [message #231137 is a reply to message #230992]

Sat, 14 April 2007 22:33

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

Dose your tnsnames.ora have the correct entries in it and identify the correct port for the listener?
It sounds like the database is running and the listener is started.
I apologize but I do not know what d2k means. Is it an o/s? Is it an application software package?

Report message to a moderator

Re: connectivity issues [message #231178 is a reply to message #230992]

Sun, 15 April 2007 12:54

khushi2000
Messages: 29
Registered: April 2007

Junior Member

Hi,
Entries are correct in tnsnames.ora. By D2k i mean developer 2000.
Khushi

Report message to a moderator

Re: connectivity issues [message #231179 is a reply to message #231178]

Sun, 15 April 2007 13:20

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

Khushi,

Seems entries are not correct, kindly forward both tnsentry from server side and from client side. Confirm the TNS_ADMIN path.

Regards,
Harshad

Report message to a moderator

Re: connectivity issues [message #232781 is a reply to message #231179]

Mon, 23 April 2007 04:40

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

Hi Khushi,
I am also facing the same problem.

If the tnsnames.ora file located on both places i.e FORM_HOME and ORACLE_HOME then is it required to set TNS_ADMIN environmental variable?

Shahnaz.

Report message to a moderator

Re: connectivity issues [message #233429 is a reply to message #230992]

Thu, 26 April 2007 02:23

kp_prasanth
Messages: 3
Registered: April 2007
Location: India

Junior Member

Make an connection entry in the tnsnames of D2K installation.

Report message to a moderator

Previous Topic:	Managing databases on multiple domains
Next Topic:	Roles of Development DBA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 00:22:14 CST 2024