-
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.
-
make sure dbhome is in your path before you invoke coraenv. This is why it is usually in /usr/local/bin or something similar...
-
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....=(
-
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
-
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..
