in reply to ORACLE HOME ENVIRONMENT

you need to install oracle client on your box, the same version (8 or 9 or 10) as on the server having the oracle server software. oracle is freely downloadable from www.oracle.com when you install the client, one of the pre-installation steps is to choose a directory for the install which becomes (and you must set this environment variable in your login script) $ORACLE_HOME. Oracle software (when installed) refers to this environment variable when finding it's own binaries etc.

Replies are listed 'Best First'.
Re^2: ORACLE HOME ENVIRONMENT
by exussum0 (Vicar) on Sep 30, 2004 at 14:12 UTC
    Not entirely true on the version thing. 8 client works with 9 server. Don't ask me why :) Though it's silly not to keep the client versiosn in sync.

    Update: clarified what works with what from my experience.

    ----
    Then B.I. said, "Hov' remind yourself nobody built like you, you designed yourself"