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

Thread: dbhome: command not found

  1. #1
    Join Date
    Jun 2001
    Posts
    243
    I log in as just regular user and when I log in I get this error...

    dbhome:command not found
    ORACLE_HOME=[]?


    they log in as csh...so I assume they use coraenv with dbhome right?

    is there problem with coraenv or dbhome?

    this is on solaris 8 with oracle 8.1.7

    The environment variables for all the users have been changed after I installed Oracle 6i. I noticed that because oratab file got changed, which was pointing to oracle6i home instead of oracle rdbms home. So I set back oracle_home to rdbms. and in coraenv I set ORAENV_ASK to NO...

    Here is my coraenv file:

    setenv ORACLE_BASE /ora01/app/oracle
    setenv ORACLE_HOME /ora01/app/oracle/product/8.1.7
    setenv ORACLE_SID JOPES
    setenv ORAENV_ASK NO

    if ($?ORACLE_SID == 0) then

    set ORASID=$LOGNAME
    else
    set ORASID=$ORACLE_SID
    endif
    if ("$ORASID" == '' ) set ORASID='*'

    if ($?ORAENV_ASK == 0 ) then
    set ORAENV_ASK=NO #ORAENV_ASK suppresses prompt when set
    endif

    if ($ORAENV_ASK != NO ) then

    echo -n "ORACLE_SID = [$ORASID] ? "
    set READ=($<)

    if ("$READ" != '') set ORASID="$READ"
    endif
    if ("$ORASID" == '*') set ORASID=""
    setenv ORACLE_SID "$ORASID"

    if ($?ORACLE_HOME == 0) then
    set OLDHOME=$PATH #This is just a dummy value so a null OLDHOME
    else #can't match anything in the switch below
    set OLDHOME=$ORACLE_HOME
    endif

    set ORAHOME=`dbhome "$ORASID"`
    if ($status == 0) then
    setenv ORACLE_HOME $ORAHOME
    else

    echo -n "ORACLE_HOME = [$ORAHOME] ? "
    set NEWHOME=$<

    if ($NEWHOME == "") then
    setenv ORACLE_HOME $ORAHOME
    else
    setenv ORACLE_HOME $NEWHOME
    endif
    endif

    #
    # Reset LD_LIBRARY_PATH
    #
    if ($?LD_LIBRARY_PATH == 0) then
    setenv LD_LIBRARY_PATH $ORACLE_HOME/lib
    else
    switch ($LD_LIBRARY_PATH)
    case *$OLDHOME/lib* :
    setenv LD_LIBRARY_PATH \
    `echo $LD_LIBRARY_PATH | sed "s;$OLDHOME/lib;$ORACLE_HOME/lib;g"`
    breaksw
    case *$ORACLE_HOME/lib* :
    breaksw
    case "" :
    setenv LD_LIBRARY_PATH $ORACLE_HOME/lib
    breaksw
    default :
    setenv LD_LIBRARY_PATH $ORACLE_HOME/lib:${LD_LIBRARY_PATH}
    breaksw
    endsw
    endif

    #
    # Adjust path accordingly
    #

    switch ($PATH)
    case *$OLDHOME/bin* :
    setenv PATH `echo $PATH | sed "s;$OLDHOME/bin;$ORACLE_HOME/bin;g"`
    breaksw
    case *$ORACLE_HOME/bin* :
    breaksw
    case *[:] :
    setenv PATH ${PATH}$ORACLE_HOME/bin:
    breaksw
    case "" :
    setenv PATH $ORACLE_HOME/bin
    breaksw
    default :
    setenv PATH ${PATH}:$ORACLE_HOME/bin
    breaksw
    endsw

    unset ORASID ORAHOME OLDHOME NEWHOME READ

    #
    # Install local modifications here
    #


    what is wrong with this?...or why am I getting error for dbhome:command not found error?.


    please help.....no one can launch the application right now.


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    make sure dbhome is in your path before you invoke coraenv. This is why it is usually in /usr/local/bin or something similar...
    Jeff Hunter

  3. #3
    Join Date
    Jun 2001
    Posts
    243
    I kindda solved this problem, but my other problem and question....TWO_TASK....

    where do I set my TWO_TASK?
    when did I ever set this TWO_TASK?
    what is my TWO_TASK?...and how do I find out or set my TWO_TASK?


    Please help....=(

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    If you want your client to connect to a perticular database then you set the TWO_TASK in your environment, such that it would allow you just to connect to the database without specifying the service name

    sqlplus username


    setenv TWO_TASK service_name

    You can set it in your .login file. The service name is the name of the database instance that you would want to connect to by default. You can find it from $ORACLE_HOME/network/admin/tnsnames.ora file. Remember if you are on the server, then you don't have to set the TWO_TASK instead you would have to set the ORACLE_SID in your environment.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Jun 2001
    Posts
    243
    I finally solved this problem...I can't believe that I had to stay this late. I was at work since 6:30am...=(
    I set the TWO_TASK at the coraenv since they use this environment variable when they first login...I set it that way....

    Everything was working fine...all these incidents happened after I installed Oracle 6i Reports and Forms this afternoon.

    When I checked the coraenv and dbhome under /opt/bin/ the date and time were changed when my installation took place. I was only looking at these two files for a while...and then finally I looked at the /var/opt/oracle/oratab file...There was my first clue. My $ORACLE_SID AND $ORACLE_HOME were changed to Oracle6i settings. So I changed back to original oracle_home and include oracle_sid. Still users cannot launch any applications....

    My second clue came up in the coraenv file.....ORAENV_ASK is equal to YES...so I changed this to NO..and still didn't work.

    My third clue was....let me look at the users .log files.....so I was examing the user's .cshrc file. When I echo $ORACLE_HOME or $ORACLE_SID, it was empty....so I setenv to /opt/bin/coraenv...still did not work....I was getting really frustrated...

    Finally my fourth clue...I had to set my TWO_TASK in coraenv file. Voila......I can launch any applications with any users....Thank God....Thank Jeff...Thank Sam....=)

    However I had to setenv to each users .cshrc. Is there other way to set this?....I should have set at /etc/.login...right?...I don't know...I can't think no more....

    i just had so many problems today other than this...but thank you all for the help....saved my life today...=)

    Thank you..

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