Oracle Instant Client Setup

[indigo]

I downloaded and unzipped the oracle instant client and sqlplus support into C:\Oracle\InstantClient_10_2\ I copied my TNSNAMES.ORA file into C:\Oracle. I then created a string registry entry for TNS_ADMIN in HKEY_LOCAL_MACHINE/Software/Oracle/. I added C:\Oracle to the windows path (Windows XP Pro).

When I run C:\Oracle\InstantClient_10_2\Sqlplus.exe, I connect to my database via tnsnames.ora.

When I try to select the logon database in TOracleSession I get:

Initialization Error
SQL*Net not properly installed
oraclehomekey:
oraclehomedir:

Instant client is working correctly with SQLPlus but is not working correctly with DOA. Can you tell me the minimum registry entries needed to get DOA to work?

Thanks.

 

[indigo]

I created the following string values in HKEY_LOCAL_MACHINE/Software/Oracle:

OracleHomeDir=c:\oracle\InstantClient_10_2
OracleHomeKey=Software\Oracle

The problem is solved.

 

[Marco Kalter]

You should not use the registry. You need to use the following 2 environment variables instead:

• PATH
  Must include the Instant Client directory (where oci.dll is located).
• TNS_ADMIN
  Must point to the directory where your tnsnames.ora file is located