Saturday, November 16, 2013

Oracle SQLPLUS Client Installation on Windows Troubleshooting


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, and I unzipped them under the same directory. When I ran sqlplus, nothing happened.

$ sqlplus myuser/mypasswrod@


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.

"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@

SQL*Plus: Release 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 - Production

I have written a newer post about the installation Oracle SQLPLUS Client Installation on Windows 64.

1 comment:

Unknown said...

There are a few ways to fix Msvcr110.dll error. The easiest is just to download this file from or similar website, but it could be not very save, check it with antivirus before you will copy it to your system folder.