Home » SQL & PL/SQL » Client Tools » PL/SQL Developer & tnsnames.ora 10g
PL/SQL Developer & tnsnames.ora 10g [message #311088] Thu, 03 April 2008 06:58 Go to next message
**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 Go to previous messageGo to next message
BlackSwan
Messages: 22903
Registered: January 2009
Senior Member
set TNS_ADMIN environmental variable to point to folder/directory where tnsnames.ora resides.
Re: PL/SQL Developer & tnsnames.ora 10g [message #311180 is a reply to message #311134] Thu, 03 April 2008 11:36 Go to previous messageGo to next message
**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
Re: PL/SQL Developer & tnsnames.ora 10g [message #311182 is a reply to message #311180] Thu, 03 April 2008 11:41 Go to previous messageGo to next message
**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
Re: PL/SQL Developer & tnsnames.ora 10g [message #543403 is a reply to message #311182] Tue, 14 February 2012 10:48 Go to previous message
hvirguez
Messages: 1
Registered: October 2007
Location: Venezuela
Junior Member
Thank you so much
Previous Topic: column ROWID doesn't display
Next Topic: Facing issue in wls1034_oepe111161_win32
Goto Forum:
  


Current Time: Wed Oct 22 21:04:30 CDT 2014

Total time taken to generate the page: 0.09110 seconds