Home » RDBMS Server » Networking and Gateways » connectivity issues
connectivity issues [message #230992] Fri, 13 April 2007 11:45 Go to next message
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
Re: connectivity issues [message #231137 is a reply to message #230992] Sat, 14 April 2007 22:33 Go to previous messageGo to next message
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?
Re: connectivity issues [message #231178 is a reply to message #230992] Sun, 15 April 2007 12:54 Go to previous messageGo to next message
khushi2000
Messages: 29
Registered: April 2007
Junior Member
Hi,
Entries are correct in tnsnames.ora. By D2k i mean developer 2000.
Khushi
Re: connectivity issues [message #231179 is a reply to message #231178] Sun, 15 April 2007 13:20 Go to previous messageGo to next message
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

Re: connectivity issues [message #232781 is a reply to message #231179] Mon, 23 April 2007 04:40 Go to previous messageGo to next message
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.
Re: connectivity issues [message #233429 is a reply to message #230992] Thu, 26 April 2007 02:23 Go to previous message
kp_prasanth
Messages: 3
Registered: April 2007
Location: India
Junior Member

Make an connection entry in the tnsnames of D2K installation.
Previous Topic: Managing databases on multiple domains
Next Topic: Roles of Development DBA
Goto Forum:
  


Current Time: Sun Dec 04 20:36:50 CST 2016

Total time taken to generate the page: 0.05423 seconds