Re: SQL Plus - Connection Query

Maybe setting environment variable
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH would help.

HTH,
Juhan

Aoife wrote:
>
> Thank Steve.
> I have found where SQLPlus is installed now, however when I type sqlplus at
> the prompt ( in the oracle home bin directory)
> I get the following error:
>
> ld.so.1: sqlplus : fatal :libclntsh.so.1.0: open failed: No such file of
> directory
> Killed
>
> Any Ideas
>
> Thanks Again
> Aoife
>
> Steve Blomeley wrote in message <39F448A6.5238F46B_at_yahooDOTco.uk>...
> >Aoife,
> >
> >On your UNIX system there should be an environment variable
> >(ORACLE_HOME) that points to the root directory of the Oracle
> >installation - Beneath this root directory is a "bin" directory
> >containing all the Oracle executables, including SQLPlus. Eg:
> >
> >> echo $ORACLE_HOME
> >/u01/app/oracle/product/8.1.5
> >
> >> ls -l $ORACLE_HOME/bin/sqlplus
> >-rwxr-x--x 1 oracle oinstall 629753 Jun 24 01:17
> >/u01/app/oracle/product/8.1.5/bin/sqlplus
> >
> >
> >So to run SQLPlus from a UNIX shell :
> >
> >> $ORACLE_HOME/bin/sqlplus
> >
> >
> >Or add "$ORACLE_HOME/bin" to your PATH environment variable, then :
> >
> >> sqlplus
> >
> >
> >Regards
> >Steve Blomeley
 

-- 
+-----------------+
|NB! Please remove|
|   .NICHT-SPAM   |
|  when replying  |
|    to get my    |
|     *REAL*      |
| e-mail address! |
|                 |
|  Cheers, Juhan  |
+-----------------+