DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Oracle 9i

  1. 12-05-2002, 11:50 AM #1
    netbar
    netbar is offline Member
    Join Date
    Jul 2001
    Posts
    181

    Oracle 9i

    Hi,

    I ahve a new installation of 9i on solaris , I am sure my .profile is correct my path statements etc. but I get the error message

    ksh: sqlplus: cannot execute

    When I try to invoke sqlplus

    Any ideas?
    Reply With Quote Reply With Quote
  2. 12-05-2002, 11:57 AM #2
    ramaral
    ramaral is offline Member
    Join Date
    Mar 2001
    Posts
    144
    can you post your profile?

    It does sound like a pathing issue - or login issue.
    Reply With Quote Reply With Quote
  3. 12-05-2002, 12:17 PM #3
    netbar
    netbar is offline Member
    Join Date
    Jul 2001
    Posts
    181
    MANPATH=/usr/man:/opt/SUNWvxvm/man
    export MANPATH

    ORACLE_SID=DST_SURV
    export ORACLE_SID

    ORACLE_BASE=/opt/oracle
    export ORACLE_BASE

    ORACLE_HOME=$ORACLE_BASE/product/9.0.1
    export ORACLE_HOME

    ORACLE_TERM=vt100
    export ORACLE_TERM

    ODBC_HOME=/usr/local/easysoft
    export ODBC_HOME

    LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/local/lib
    export LD_LIBRARY_PATH

    CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip:$ORACLE_HOME/plsql/jlib
    export CLASSPATH

    PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/ccs/bin:/opt/bin:/usr/sbin:/usr/openwin/bin:/usr/local/bin:$
    export PATH

    EDITOR=vi
    export EDITOR

    ORAENV_ASK=YES
    export ORAENV_ASK

    ODBCINI=/usr/odbc/odbc.ini
    export ODBCINI

    # Set the prompt
    PS1="`/usr/bin/uname -n`:$LOGNAME# "

    set -o vi
    stty erase \^H

    umask 022
    alias alerts="vi /opt/oracle/admin/$ORACLE_SID/bdump/alert_$ORACLE_SID.log"
    alias udump="cd /opt/oracle/admin/$ORACLE_SID/udump/"
    alias dumps="cd /opt/oracle/admin/$ORACLE_SID"
    alias exports="cd /opt/exports"
    alias backups="cd /opt/oracle/dba/logs/rman"
    alias scripts="cd /opt/oracle/dba/scripts/rman"
    alias udump="cd /opt/oracle/admin/$ORACLE_SID/udump/"
    alias ll="ls -lart"
    alias tfa='tail -f /opt/oracle/admin/$ORACLE_SID/bdump/alert_$ORACLE_SID.log'

    export CVS_SERVER=$HOME/bin/cvs
    export CVSROOT=server:anonymous@172.17.1.191:/export/home/mad/work/cvsroot
    Reply With Quote Reply With Quote
  4. 12-05-2002, 02:44 PM #4
    ramaral
    ramaral is offline Member
    Join Date
    Mar 2001
    Posts
    144
    how about the permissions on the binary?
    Reply With Quote Reply With Quote
  5. 12-06-2002, 04:09 AM #5
    netbar
    netbar is offline Member
    Join Date
    Jul 2001
    Posts
    181
    -rwxr-xr-x 1 oracle dba 752344 Aug 16 2001 sqlplus
    Reply With Quote Reply With Quote
  6. 12-06-2002, 04:42 AM #6
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    That all seems okay, have you checked that the path is being set correctly for the environment

    Code:
    $ echo PATH
    Or you could make sure it's looking at the right sqlplus

    Code:
    $ which sqlplus
    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  7. 12-06-2002, 04:57 AM #7
    Orca777's Avatar
    Orca777
    Orca777 is offline Senior Member
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    if you hve a korn or a bash-shell
    then look into .kshrc / .bashrc
    these scripts are ALWAYS executetd when a new shell
    is created, probalby there could be overwritten the $PATH-VAR

    Orca
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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