OraFAQ Forum: Client Tools » PL/SQL Developer & tnsnames.ora 10g

Home » SQL & PL/SQL » Client Tools » PL/SQL Developer & tnsnames.ora 10g

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

PL/SQL Developer & tnsnames.ora 10g [message #311088]

Thu, 03 April 2008 06:58

**Snake**
Messages: 47
Registered: December 2005
Location: Italy

Member

Hi guys...
I'm trying to connect to my DBs.
I installed Oracle Client 10g, but PLSQL Dev. 7.1.4 doesn't find my tnsnames.ora.

Anyone can help me ??
Thanks

[Updated on: Thu, 03 April 2008 06:58]

Report message to a moderator

Re: PL/SQL Developer & tnsnames.ora 10g [message #311134 is a reply to message #311088]

Thu, 03 April 2008 09:13

BlackSwan
Messages: 20085
Registered: January 2009

Senior Member

set TNS_ADMIN environmental variable to point to folder/directory where tnsnames.ora resides.

Report message to a moderator

Re: PL/SQL Developer & tnsnames.ora 10g [message #311180 is a reply to message #311134]

Thu, 03 April 2008 11:36

**Snake**
Messages: 47
Registered: December 2005
Location: Italy

Member

It' doesn't work Sad

In the cascade window I don't see any DB connection.
But Enterprise Manager correctly works.

Sad

Report message to a moderator

Re: PL/SQL Developer & tnsnames.ora 10g [message #311182 is a reply to message #311180]

Thu, 03 April 2008 11:41

**Snake**
Messages: 47
Registered: December 2005
Location: Italy

Member

Ok...I found the problem.
The problem is not the tnsnames but the OCI library specification.
I need to specify manually path and name of OCI.dll file.

Now it works!

Thank you Wink

Report message to a moderator

Re: PL/SQL Developer & tnsnames.ora 10g [message #543403 is a reply to message #311182]

Tue, 14 February 2012 10:48

hvirguez
Messages: 1
Registered: October 2007
Location: Venezuela

Junior Member

Thank you so much

Report message to a moderator

Previous Topic:	column ROWID doesn't display
Next Topic:	Facing issue in wls1034_oepe111161_win32

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 20:41:04 CDT 2013

Total time taken to generate the page: 0.12856 seconds