Smaller Footprint Oracle Client Software

Do you need to bundle Oracle Client Software with your application and want something leaner than the Oracle Instant Client? Do you need a quick and simple way to make a native Oracle 10 connection from your Windows PC?

Here’s an option that will provide Oracle 10 native connectivity (not ODBC) under Windows 32-bit using as few Oracle files as possible. Compressed size is 10 Megs compared to 17 Megs for the Oracle Client Basic Lite package.

Oracle10Client.zip

To install, you simply unzip the contents. The oracle key file contains a registry path that must correspond to the folder in which you have installed the client software. In the zip file, bin / oracle.key has

SOFTWARE\ORACLE\myOracle10Client

and the oracle10.reg file has

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\myOracle10Client]
“Oracle_Home”=”C:\\Program Files\\Oracle\\myOracle10Client”

You can use the oracle10.reg file to create the required registry entry.

You should update these files to point to the location in which you install the client software.

You can assemble this distribution yourself by paring down an Oracle 10 Client install to just:

BIN/
NETWORK/
RDBMS/
nls/
oracle10.reg
oracore/

./BIN:
ORASLAX10.DLL
TNSPING.EXE
oci.dll
oracle.key
oraclient10.dll
oracommon10.dll
oracore10.dll
orageneric10.dll
orahasgen10.dll
oraldapclnt10.dll
oran10.dll
orancds10.dll
orancrypt10.dll
oranhost10.dll
oranl10.dll
oranldap10.dll
oranls10.dll
orannzsbb10.dll
oranro10.dll
orantcp10.dll
orantns10.dll
oraocr10.dll
oraocrb10.dll
oraplp10.dll
orapls10.dll
orasnls10.dll
orasql10.dll
oraunls10.dll
orauts.dll
oravsn10.dll
oraxml10.dll

./NETWORK:
ADMIN/
mesg/

./NETWORK/ADMIN:
SAMPLE/
sqlnet.ora
tnsnames.ora

./NETWORK/ADMIN/SAMPLE:
SQLNET.ORA
TNSNAMES.ORA

./NETWORK/mesg:
tnsus.msb

./RDBMS:
mesg/

./RDBMS/mesg:
ocius.msb
oraus.msb

./nls:
data/

./nls/data:
lx00001.nlb
lx10001.nlb
lx1boot.nlb
lx20001.nlb
lx200b2.nlb
lx20367.nlb
lx207d0.nlb

./oracore:
zoneinfo/

./oracore/zoneinfo:
readme.txt
timezlrg.dat
timezone.dat

I should mention how this list was assembled. Initially, I used a very expensive product called AppSight (now BMC AppSight). Once I discovered by Mark Russinovich’s sysinternals, that worked just as well.

Advertisements
Published in: on April 23, 2008 at 6:27 pm  Comments (8)  
Tags: , ,

The URI to TrackBack this entry is: https://dmcmeans.wordpress.com/2008/04/23/smaller-footprint-oracle-client-software/trackback/

RSS feed for comments on this post.

8 CommentsLeave a comment

  1. Hi Dave,

    This package is good and useful. I was maintaining a similar package, but I didn’t spent much time to collect all the DLL(s) which are required by TnsPing.exe

    Your package actually supports TnsPing.exe! However, Did you use the instant client 10.2.0.1 to build your package? I ran into a DLL error for TnsPing.exe when I replaced the following files from the instantclient-basic-win32-10.2.0.4.zip

    oci.dll
    ocijdbc10.dll
    ociw32.dll
    ojdbc14.jar
    orannzsbb10.dll ## this file causes the error
    oraocc10.dll
    oraociei10.dll

    So I have to keep orannzsbb10.dll as your version. Can you confirm and upgrade your package based on the latest instant client please?

    Thanks again for the great package!

    Eric

  2. This package was put together before Oracle offered the Instant Client. Now that the Instant Client is available, there’s not so much need for a home-grown solution like this, so this offering may be more academic than anything else.

  3. This package is much better than Oracle Instant Client.
    This allows to use M$ OLE DB provider for Oracle. That one I used for setting linked server in MSSQL 2003 Express.
    But then it seems you have to add to your installation path to Oracles BIN directory in PATH and ORACLE_HOME or TNS_ADMIN variable so that provider “knows” where to find TNS parameters.

  4. I faces with a problem:
    I need another LNS_LANG setting than default – without LNS_LANG paremeter I am losing accentuated characters in results from queries.
    When I am trying to use my setting – I am getting ORA-12705 error.
    I tried to use another *.nlb files from working installation of big 9.x client, but it does not help.
    😦

  5. I’ve never had to change the NLS_LANG setting, so I have no knowledge what extra files are required. Your tests are exactly what I would do to figure it out. Perhaps googling NLS_LANG is a place to start? And be sure to check asktom.oracle.com. I’m glad this package is helpful, but I am surprised it’s offering capability you cannot get from the Oracle Instant Client. Best of luck.

  6. Hi! I was surfing and found your blog post… nice! I love your blog. 🙂 Cheers! Sandra. R.

  7. Nice! I also had such an installation but mine was a little bit bigger (but smaller than the Oracle one). Did you have the same for 11g?

    • My need for it expired (because I discovered the Instant Client) before 11g entered the picture.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: