Print Thread
cant see tnsnames or connect
#40921 06/09/11 08:56 AM
Joined: Jun 2011
Posts: 5
B
Brun Offline OP
Member
OP Offline
Member
B
Joined: Jun 2011
Posts: 5
I am using windows 7, have installed it to the non () path i have installed on the same machine 11.2.0.2 oracle client and 11.2.0.2 database.

For some reason its not picking up tnsnames correctly i have tried reinstalling plsql developer multiple times with no luck any suggestions will be useful!

[quote]PL/SQL Developer
Version 8.0.4.1514
Windows 7 (64-bit) 6.1 Build 7600

Physical memory : 4,194,304 kB (2,623,956 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,962,492 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: True

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Users\brettm\AppData\Roaming\PLSQL Developer\Preferences\brettm\default.ini

Plug-Ins

Aliases

Homes

DLLs
C:\app\oracle\product\11.2.0\client_1\oci.dll

TNS File

Using
Home:
DLL:
OCI: not initialized[/quote]


[quote]
PATHS
C:\app\oracle\product\11.2.0\client_1
C:\app\oracle\product\11.2.0\client_1\bin
%CommonProgramFiles%\Microsoft Shared\Windows Live
C:\app\oracle\product\11.2.0\dbhome_1\bin
C:\Program Files (x86)\Common Files\NetSarang
C:\Windows\system32
C:\Windows
C:\Windows\System32\Wbem
C:\Windows\System32\WindowsPowerShell\v1.0\
C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static
C:\Program Files (x86)\QuickTime\QTSystem\
C:\Program Files\Common Files\Microsoft Shared\Windows Live[/quote]

Re: cant see tnsnames or connect
Brun #40926 06/09/11 10:10 AM
Joined: Aug 1999
Posts: 22,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
Perhaps you need to set the TNS_ADMIN environment variable? It needs to be set to the directory where the tnsnames.ora file is located.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.025s Queries: 14 (0.006s) Memory: 2.5015 MB (Peak: 3.0427 MB) Data Comp: Off Server Time: 2024-05-20 14:52:03 UTC
Valid HTML 5 and Valid CSS