I had the 9i client on this machine and have since uninstalled it and reinstalled 10g. I am able to successfully run SQLPLUS and attach to my remote database.

Notice the Help->Support output doesn't have any information about my TNSnames.ora file... even though it exists.


When I run PL/SQL Developer I get:

Initialization error
SQL*NET not properly installed

OracleHomeKey:
OracleHomeDir:


When I rerun the client install program, I can see where SQL*Net has been installed.

Why or how do I set these values? Why is it telling me it's not properly installed when it seems to work with SQLPLUS? I'm not a power user, so be gentle :-) I'm trying to learn.

Thanks.
Stephen


Here's the post from my Help->Support screen:


--- Info ---


PL/SQL Developer
Version 7.0.3.1123 (MBCS)
01.37532 - 1 user license
Windows XP version 5.5 (build 3790) Service Pack 1

Physical memory : 2,094,460 kB (1,205,928 available)
Paging file : 4,057,372 kB (3,414,324 available)
Virtual memory : 2,097,024 kB (2,015,340 available)

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

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

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\susrey\default.ini

Plug-Ins
TNSEditor Plugin (C:\Program Files\PLSQL Developer\PlugIns\TNSEditorPlugin.dll)

Aliases

Homes

DLLs

TNS File

Using
Home:
DLL:
OCI: not initialized


--- Registry ---


SOFTWARE\ORACLE


--- Path ---

D:\oracle\product\10.2.0\client_1\bin
C:\Perl\bin\
C:\PROGRA~2\Borland\CBUILD~1\Bin
C:\PROGRA~2\Borland\CBUILD~1\Projects\Bpl
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
C:\Program Files (x86)\Common Files\Roxio Shared\DLLShared\


--- TNS names ---