Re: SQL Plus - Connection Query

From: Aoife <aoifeo_at_musgrave.ie>
Date: Mon, 23 Oct 2000 15:43:18 +0100
Message-ID: <18YI5.9961$Bw1.6127@news.indigo.ie>

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
Received on Mon Oct 23 2000 - 09:43:18 CDT