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???
Printable View
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.Quote:
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???
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.
Have him model his .profile after one of the other dba's, this way it is all set up (the variables) upon login.
Who are you and how did you get Mr.Hanky's password??? ;)Quote:
Originally posted by Mr.Hanky
Have him model his .profile after one of the other dba's, this way it is all set up (the variables) upon login.
You are being exceptionally helpful and non-sarcastic.
Certainly copying someone else's .profile is the easiest way to setup a new user,
as there are probably other things that the user will need.