Re: Client Libraries

From: ChrisF <chris.freel_at_gmx.ch>
Date: 1 Jun 2006 06:09:04 -0700
Message-ID: <1149167344.296257.134340_at_i40g2000cwc.googlegroups.com>


It does work on Oracle 9i, so "should" work on Oracle 10. I have an Oracle client on a USB stick, which I can plug into a PC without needing Administrator privileges and run up SQL*Plus, Oracle Forms etc.

The trick is that you must start your client applications from a Command File.
When you install Oracle client, it puts a large number of settings into the registry; Oracle home directory, tns_names location, etc. etc. All these settings can be overridden by DOS environment variables with the same names.

So long as your Command file sets *ALL* of these up before starting your client executable, you can have a client-on-a-network drive which can be run from any PC, regardless of whether it has ever had Oracle installed, and without needing Administrator privileges.

But, if you've missed out one setting from your Command File, it is not easy to find out what it is. Received on Thu Jun 01 2006 - 15:09:04 CEST

Original text of this message