Can't Access sqlplus on the server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Can't Access sqlplus on the server

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    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???

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999

    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.
    this space intentionally left blank

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    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.

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    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.
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width