Toad World® Forums

Oracle ODAC/ODP.Net


#1

Is anyone here familiar with Oracle’s ODP.Net? I tried installing the latest version (11.1.0.6.21, though it seems 11.1.0.7.20 was just released) and I’m having issues. The install didn’t seem as clean as the 10.2.0.2.21 version we are using now and I had to move some files around. I also had to modify some registry settings to have things point over to the new Home (though this was necessary in 10.2 as well).

When I triy to connect using the 11g home in TOAD, nothing happens. I click Connect in TOAD and nothing happens. Using my old 10.2 home works fine. When I open up the Oracle Home Editor, I notice that the “Instant Client” is “invalid”. Is this somehow related to my issue? Was this a bad install? Am I missing somethnig obvious? Do I have too many Oracle Homes installed?

Any help would be appreciated. I have provided a listing of my Oracle Homes per the Toad Home Editor below.

Thanks!

SOFTWARE\ORACLE (Oracle Root)
ORACLE_HOME_NAME: OraClient11g_home1
ORACLE_HOME: C:\oracle\product\11.1.0\client_1
ORACLE_SID:
NLS_LANG: NA
SQLPATH:
LOCAL:
C:\oracle\product\11.1.0\client_1\Bin exists.
C:\oracle\product\11.1.0\client_1\Bin is in PATH.
Client DLL: C:\oracle\product\11.1.0\client_1\Bin\oci.dll
Client Version: 11.1.0.1.0
Home is valid.

SOFTWARE\ORACLE\HOME0
ORACLE_HOME_NAME: Default_HOME92
ORACLE_HOME: C:\ORAWIN92
ORACLE_SID:
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
SQLPATH: C:\ORAWIN92\dbs
LOCAL:
C:\ORAWIN92\Bin exists.
C:\ORAWIN92\Bin is in PATH.
Client DLL: C:\ORAWIN92\Bin\oci.dll
Client Version: 9.2.0.1.0
Home is valid.

SOFTWARE\ORACLE\KEY_ODACHOME1
ORACLE_HOME_NAME: ODACHome1
ORACLE_HOME: C:\oracle\product\10.2.0\client_1
ORACLE_SID:
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
SQLPATH:
LOCAL:
C:\oracle\product\10.2.0\client_1\Bin exists.
C:\oracle\product\10.2.0\client_1\Bin is in PATH.
Client DLL: C:\oracle\product\10.2.0\client_1\Bin\oci.dll
Client Version: 10.2.0.1.0
Home is valid.

SOFTWARE\ORACLE\KEY_ORACLIENT11G_HOME1
ORACLE_HOME_NAME: OraClient11g_home1
ORACLE_HOME: C:\oracle\product\11.1.0\client_1
ORACLE_SID:
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
SQLPATH:
LOCAL:
C:\oracle\product\11.1.0\client_1\Bin exists.
C:\oracle\product\11.1.0\client_1\Bin is in PATH.
Client DLL: C:\oracle\product\11.1.0\client_1\Bin\oci.dll
Client Version: 11.1.0.1.0
Home is valid.

Instant Client - 11.1.0.1.0
ORACLE_HOME_NAME: C:\oracle\product\11.1.0\client_1
ORACLE_HOME: C:\oracle\product\11.1.0\client_1
ORACLE_SID:
NLS_LANG:
SQLPATH:
LOCAL:
C:\oracle\product\11.1.0\client_1 exists.
C:\oracle\product\11.1.0\client_1 is in PATH.
Client DLL: C:\oracle\product\11.1.0\client_1\oci.dll
Client Version: 11.1.0.1.0
Home is NOT valid!