Problem
I wanted to install Oracle Instant Client On Windows for my laptop, a 32 bit system running Windows 7. I went to the Instant Client Downloads for Microsoft Windows (32-bit) and downloaded two zip files, instantclient-basic-nt-12.1.0.1.0.zip and instantclient-sqlplus-nt-12.1.0.1.0.zip. I unzipped them under the same directory. When I ran sqlplus, nothing happened.
$ $ sqlplus myuser/mypasswrod@192.168.1.5:1521/xe $
Solution
Under the directory that I unzipped the downloaded files, I found a number of executable file such as adrci.exe in addition to sqlplus.exe. I ran adrci.exe and got the following error message.
$adric.exe "error while loading shared libraries: MSVCR100.dll"After doing some research about MSVCR100.dll on the internet, I went to Microsoft Download Center: Microsoft Visual C++ 2010 Redistributable Package (x86). Once I downloaded and install the package, I can run sqlplus and connect to the database server without issue.
$ sqlplus myuser/mypasswrod@192.168.1.5:1521/xe SQL*Plus: Release 12.1.0.1.0 Production on Sat Nov 16 13:07:04 2013 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production SQL>I have written a newer post about the installation Oracle SQLPLUS Client Installation on Windows 64.
1 comment:
There are a few ways to fix Msvcr110.dll error. The easiest is just to download this file from http://fix4dll.com/msvcr110_dll or similar website, but it could be not very save, check it with antivirus before you will copy it to your system folder.
Post a Comment