Originally posted by lesstjm
I have a use that logs onto the server with the dba group in development that is getting an error trying to run sqlplus

/mydir>sqlplus
ksh: sqlplus: not found


Is there a permission they need in unix or a PATH problem???
You need to do the following assuming that you are using the ksh/bsh, etc.

export ORACLE_HOME=/u01/app/oracle/product/9.2.0
export LD_LIBRARY_PATH=/u01/app/oracle/product/9.2.0/lib32:$LD_LIBRARY_PATH
export ORACLE_SID=mysid

If you are using the csh you need to do a setenv. Of course your Oracle home will not be in the same location. You will also want to put this in your .profile assuming ksh again. It really depends on the shell that you are using and the directory where Oracle is installed.