Re: libclntsh error

Michael,
I saw Alex's reply and he's correct, but I wanted to add a few things, since I just wrestled with this problem myself and it can be caused by more than one thing:

In the .profile or .cshrc or oraenv or coraenv, it's the environment variable: LD_LIBRARY_PATH that has to be set to $ORACLE_HOME/lib.

I also discovered, that if you upgrade the OS or move the $ORACLE_HOME, you might have to relink the executables. There's a document on METALLINK DOC ID: Note: 74991.1 that explains what needs to be done.

Also, I glanced at the script :$ORACLE_HOME/bin/genclntsh. This creates a shared library for the precompilers like: Pro*C, XA for x-windows and OCI, none of which are used by SQLPLUS.

Melissa A. Harris
Oracle DBA / DuPont Pharmaceuticals Co.
Phone: (302) 892-8363
Cell: (302) 388-2077
Email: Melissa.A.Harris_at_DuPontPharma.com

In article <mjm.962953290_at_fraser>,
  mjm_at_barwonwater.vic.gov.au (Michael McGarrigle) wrote:
> We are able to successfully run sqlplus from an NT client
> and on the host machine (Solaris 2.7) where Oracle is installed.
> However when I try to run sqlplus from other unix clients
> I get the message :
> ld.so.1: sqlplus: fatal: libclntsh.so.1.0: open failed:
> No such file or directory
>
> I recall somebody talking about a utility called genclntsh.
>
> Would anyone know whether this would fix the above problem.
> I am not much of a unix guru so I would appreciate
> some feedback on what this utility actually
> does (does it cause anything to break ?)
>
> TIA
>
> --
> Michael McGarrigle Michael.McGarrigle_at_BarwonWater.Vic.Gov.Au
> Information Systems Barwon Water
> 61-67 Ryrie St Geelong Phone: +61 352 262326
> Victoria 3220 Australia Fax: +61 352 218236
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 10 2000 - 00:00:00 CDT