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
Oracle Shell Scripting book has full details on locating a
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
Next, we start SQL*Plus with the sqlplus command.
When starting SQL*Plus include the user name that you wish to
Here are examples of the use of this command:
Release 10.1.0.2.0 - Production on Sun Feb 20 11:28:13 2005
make the change permanent, add the settings to your .login,
.profile, or .kshrc file . . .
Get the Complete
Oracle SQL Tuning Information
The landmark book
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
for 30% off directly from the publisher.