Re: SQL Plus - Connection Query

From: Steve Blomeley <steveblomeley_at_yahooDOTco.uk>
Date: Mon, 23 Oct 2000 15:18:14 +0100
Message-ID: <39F448A6.5238F46B@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:18:14 CDT