Setting up Oracle Instant Client

[davidelewis]

I've managed to sucessfully set up the Oracle Instant Client (version 10.1.0.3) with PL/SQL 6.x. I ran into a few problems, but managed to resolve them. I put together a readme file - which I thought I would share in case anyone else could use the information ...

ORACLE INSTANT CLIENT

INSTALLATION:

[1] Unzip all the files in "instantclient-basic-win32-10.1.0.3.zip" into a directory (example: "C:\dev\oracle_ic_10_1") on the file system.
[2] Unzip any other Instant Client modules (such as JDBC or ODBC) into the same directory.
[3] Add ORACLE_HOME to the system properties, specifying the directory that files were unzipped into.
[4] If installing the ODBC module, a) at the command prompt, change directory the ORACLE_HOME, then b) execute the "odbc_install.bat" batch file.
[5] Create a "ORACLE_HOME\network\admin" directory where the "tnsnames.ora" file can be located.
[6] Update the "tnsnames.ora" file with database/schema entries as required.

TROUBLESHOOTING:

If having problems connecting with the Oracle Instant Client and getting the ORA-12705 error, edit the registry and remove all HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE keys.

 

[Marco Kalter]

Thanks for the info

 

[Hady Lattouf]

HI,
I was following those steps, but I keep having the following error whenever I launch plsql :

---------------------------
plsqldev.exe - Unable To Locate Component
---------------------------
This application has failed to start because MSVCR71.dll was not found. Re-installing the application may fix this problem.
---------------------------
OK
---------------------------

Any idea?

 

[Marco Kalter]

I found this note on Oracle MetaLink

Symptoms
Downloaded the following files from OTN to a local Windows 2000 machine.

instantclient-basic-win32-10.2.0.1-20050930.zip size 34,390,521 (via properties window)
instantclient-sqlplus-win32-10.2.0.1-20050930.zip size 720,691 (via properties window)

Extracted both files into the Downloads directory.
This resulted in a new sub directory named instantclient_10_2 and 11 new files.

Set the PATH using:
PATH=C:\DOWNLOADS\INSTANTCLIENT_10_2;%PATH%

Typed "sqlplus" and received an error that MSVCR71.DLL could not be found.

Cause
The MSVCR71.DLL file does not exist.

Solution
1 - Download .NET from the Microsoft Website as this will include this run-time library.
This should install the file under the Windows\System32 directory automatically.
OR
2 - Search for available sites to Download the MSVCR71.DLL file.
This can be placed within the Windows\System32 directory or any other location but the location
must be found listed within the PATH environment variable. Keep in mind, downloading this file from a site other than Microsoft's may have some adverse affect to your machine as the actual source of the file may be unknown.

 

[davidelewis]

Hmmm ... I'm not sure why you are needing the .NET libraries. Here's my most recently updated readme:
-------------------------------------------------
ORACLE INSTANT CLIENT
Last Updated: November 25, 2005 11:25 AM

INSTALLATION:

[1] Unzip all the files in "instantclient-basic-win32-10.2.0.1-20050930.zip"
into a directory (example: "C:\dev\instantclient_ic_10_2") on the file system.
[2] Unzip any other Instant Client modules (such as JDBC or ODBC) into the
same directory.
[3] Add ORACLE_HOME to the system properties, specifying the directory that
files were unzipped into.
[4] If installing the ODBC module, a) at the command prompt, change directory
the ORACLE_HOME, then b) execute the "odbc_install.bat" batch file.
[5] Create a "ORACLE_HOME\network\admin" directory where the "tnsnames.ora"
file can be located.
[6] Update the "tnsnames.ora" file with database/schema entries as required.

TROUBLESHOOTING:

If having problems connecting with the Oracle Instant Client and
getting the ORA-12705 error, edit the registry and remove all
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE keys.