-
Can't Access sqlplus on the server
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???
-
Re: Can't Access sqlplus on the server
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.
-
Have him model his .profile after one of the other dba's, this way it is all set up (the variables) upon login.
I remember when this place was cool.
-
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.
Who are you and how did you get Mr.Hanky's password???
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|