Question:
:
I can get into SQL*Plus from OEM, but when I try to enter SQLPLUS from my
UNIX prompt, I get the following error:
sqlplus: command not found
Answer: This says that the OS cannot find the program named sqlplus in
its PATH.
First, the
Oracle Shell Scripting book has full details on locating a
missing executable.
Start by a cd to the $ORACLE_HOME/bin and see if it works . . .
If this works, you need to set your PATH to include your
$ORACLE_HOME/bin directory.
Next, we start SQL*Plus with the sqlplus command.
When starting SQL*Plus include the user name that you wish to
connect to.
Here are examples of the use of this command:
C:\>sqlplus john_dba/mypass
SQL*Plus:
Release 10.1.0.2.0 - Production on Sun Feb 20 11:28:13 2005
To
make the change permanent, add the settings to your .login,
.profile, or .kshrc file . . .
|
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|