Results 1 to 15 of 15

Thread: sql*plus

  1. #1
    Join Date
    Dec 2002
    Posts
    4

    Unanswered: sql*plus

    Hello,

    how do you bring the sql plus interface/environment up on oracle 9i
    in solaris9?
    thanks

  2. #2
    Join Date
    Jul 2002
    Posts
    29

    Re: sql*plus

    Originally posted by tsee
    Hello,

    how do you bring the sql plus interface/environment up on oracle 9i?

    thanks

    Just type SQLPlus at your prompt

    -- rajXesh
    All you need in this life is ignorance and confidence, and then success is sure.
    -- Mark Twain (1835 - 1910)

  3. #3
    Join Date
    Dec 2002
    Posts
    4
    i have oracle installed on /oracle/home/export
    i did that and i get sqlplus no found.

    must be in other directory?


    thanks

  4. #4
    Join Date
    Jan 2003
    Posts
    18
    Just check the Path variable
    ie wether it leads to the directory where "sqlplus" is present.
    the Path variable is set in .env
    so u also look for the .env file

    Regards,
    Senthil


    Originally posted by tsee
    i have oracle installed on /oracle/home/export
    i did that and i get sqlplus no found.

    must be in other directory?


    thanks

  5. #5
    Join Date
    Jan 2003
    Posts
    18
    Hi,
    pls check "echo $ORACLE_HOME" in ur machine
    this gives the path where the "sqlplus" executable is present.
    So set the path accordingly.
    hope this will work

    Regards,
    Senthil



    Originally posted by senthil5_kumar
    Just check the Path variable
    ie wether it leads to the directory where "sqlplus" is present.
    the Path variable is set in .env
    so u also look for the .env file

    Regards,
    Senthil

  6. #6
    Join Date
    Dec 2002
    Posts
    17
    echo $ORACLE_HOME

    returns $

    that means?

    echo /home/oracle/export
    returns the path that the oracle has been installed.

    thanks

  7. #7
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107
    Originally posted by 4ou
    echo $ORACLE_HOME

    returns $

    that means?

    echo /home/oracle/export
    returns the path that the oracle has been installed.

    thanks
    Hi,
    As Senthil mentioned, the path is not set.
    Log into the solaris machine as the super user or the administrator,
    then find for the file sqlplus using the following command

    find / -name sqlplus 2 > /dev/null

    Note down the path where the file "sqlplus" is located.

    Add this path to the PATH variable in your .profile file.

    Example:

    PATH=/usr/bin; /home/oracle/bin;
    export PATH
    nn

  8. #8
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Smile

    Another way to find sqlplus binary is:

    $ which sqlplus
    /app/oracle/product/817/bin/sqlplus

    It's recommended that you add Oracle binaries path to your shell PATH. If you are using Korn Shell, add this line to .profile file

    PATH=${PATH}:${ORACLE_HOME}/bin

    export PATH



    Hope that helps,

    clio_usa - OCP - DBA


  9. #9
    Join Date
    Dec 2002
    Posts
    17
    where ${ORACLE_HOME}
    do i have to insert the equivalent path
    or leave as it is?

    thanks,

  10. #10
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Smile

    If you already defined

    ORACLE_HOME=/apps/.../...

    why type it again. ${ORACLE_HOME} is translated to the absolute path you already defined. Less typing - less errors you do.


    Hope that helps,

    clio_usa - OCP - DBA

  11. #11
    Join Date
    Dec 2002
    Posts
    17
    I defined path as:


    PATH=${PATH}.:${ORACLE_HOME}/bin


    LD_LIBRARY_PATH=${ORACLE_HOME}/lib:/usr/X/lib:/usr/openwin/l
    ib:/usr/dt/lib


    where:

    ORACLE_HOME=$/export/home/oracle/app/oracle
    ORACLE_SID=voyager


    BUT WITH

    # which sqlplus i get:

    no sqlplus in /usr/sbin /usr/bin /usr/dt/bin /usr/openwin/bin /bin /usr/ucb

    Why can't find the sqlplus?

    thanks

  12. #12
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Thumbs up

    ORACLE_HOME=$/export/home/oracle/app/oracle
    That's wrong...

    Unless you make that global with export, PATH variable will not pick up the value. Do:

    ORACLE_HOME=/export/home/oracle/app/oracle


    PATH=$PATH:${ORACLE_HOME}/bin

    export ORACLE_HOME PATH

    Then

    $ echo $PATH

    If you see

    $ /export/home/oracle/app/oracle/bin

    then you should see the sqlplus, with

    $which sqlplus

    BTW, your ORACLE_HOME=/export/home/oracle/app/oracle doesn't look right. That's more your ORACLE_BASE.

    Your ORACLE_HOME has to be something like:

    /export/home/oracle/app/oracle/product/8.1.7 or whatever version you are using...


    Hope that helps,

    clio_usa
    OCP - DBA

  13. #13
    Join Date
    Dec 2002
    Posts
    17
    The mount point is /export/home
    Do i have to keep any $ and what is the meaning of the $?

    this is what i have as .profile
    which ORACLE_BASE to keep?

    thanks


    ORACLE_SID=voyager
    ORACLE_BASE=/export/home/oracle/app/oracle
    ORACLE_BASE=/apps/oracle
    ORACLE_ADMIN={ORACLE_BASE}/admin/{ORACLE_SID}
    ORACLE_HOME={ORACLE_BASE}/product/9.2.0
    ORACLE_TERM=xsun5
    NLS_LANG=american_america.WE8ISO8859P1
    ORA_NLS33={ORACLE_HOME}/ocommon/nls/admin/data
    TNS_ADMIN=/var/opt/oracle
    PATH=$PATH:${ORACLE_HOME}/bin
    export ORACLE_HOME PATH LD_LIBRARY_PATH={ORACLE_HOME}/lib:/usr/openwin/lib:/usr/dt/lib
    export ORACLE_SID ORACLE_BASE ORACLE_ADMIN ORACLE_HOME ORACLE_TERM NLS_LANG
    ORA_NLS33 TNS_ADMIN PATH LD_LIBRARY_PATH
    $DISPLAY=xxx.xx.xxx.xxx_TEST:0.0
    $export DISPLAY
    xhost +xxx.xx.xxx.xxx
    ${ORACLE_HOME}\bin\dbassist &e

  14. #14
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482
    It's very simple:

    $ echo PATH
    PATH

    $ echo $PATH
    /bin:/usr/bin:/usr/ucb:/usr/bin/X11:/usr/local/bin:/opt/SSHssh/bin:/usr/local/bin:/usr/local/sbin:/usr/openwin/bin:/opt/SSHssh/bin:/opt/bin:/bin:/usr/ccs/bin:/usr/X/bin:/usr/bin/X11:/usr/bin:/usr/ucb:/etc:/usr/local/bin:/usr/sbin:.

    $ means the value of the variable after the $ sign. As you can see - echo $PATH returns the value of the variable PATH.

    So fix your .profile file like that:

    ORACLE_SID=voyager
    ORACLE_BASE=/export/home/oracle/apps/oracle
    ORACLE_ADMIN=${ORACLE_BASE}/admin/${ORACLE_SID}
    ORACLE_HOME=${ORACLE_BASE}/product/9.2.0


    I don't know what is that:

    $DISPLAY=xxx.xx.xxx.xxx_TEST:0.0
    $export DISPLAY
    xhost +xxx.xx.xxx.xxx
    ${ORACLE_HOME}\bin\dbassist &e

    Guess it's your command line output. If so then this is wrong:

    ${ORACLE_HOME}\bin\dbassist &e

    In UNIX there is no meaning for "\" when used for the directory. It's "/" - forget the Windows and welcome to the UNIX world. You have extra "e" after the "&" too...


    Hope that helps,

    clio_usa - OCP - DBA

  15. #15
    Join Date
    Dec 2002
    Posts
    17
    i did all the changes but

    which sqlplus

    gives the same outpout as

    echo $PATH

    what is missing and i don't get the sqlplus?

    do i have any changes in env values also?


    Do you have in your profile or it is necessary to have:

    $DISPLAY=xxx.xx.xxx.xxx_TEST:0.0
    $export DISPLAY
    xhost +xxx.xx.xxx.xxx
    ${ORACLE_HOME}\bin\dbassist &


    where xxx.xx.xxx.xxx the ip address

    helps a lot and i appreciate your time.
    thanks

Posting Permissions

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