Re: HP-UX Prompting for ORACLE_HOME

From: Peter Marelas <maral_at_fulcrum.com.au>
Date: 1996/03/12
Message-ID: <4i3ft2$qqb_at_spoolie.fulcrum.com.au>#1/1

If its csh its probably sourcing coraenv. If its sh its probably sourcing oraenv.

And its probably running $ORACLE_HOME=`dbhome $ORACLE_SID`

Use the following in .cshrc

setenv ORACLE_SID your_sid
setenv ORACLE_HOME `dbhome $ORACLE_SID`
setenv ORAENV_ASK NO

source $ORACLE_HOME/bin/coraenv
setenv ORAENV_ASK YES
setenv LD_LIBRARY_PATH $ORACLE_HOME/lib

Use the following in .profile

ORACLE_SID=your_sid
export ORACLE_SID

ORACLE_HOME=`dbhome $ORACLE_SID`
ORAENV_ASK=NO
export ORACLE_HOME ORAENV_ASK

 $ORACLE_HOME/bin/oraenv

ORAENV_ASK=YES
export ORAENV_ASK

LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH

In both cases you oratab must have the correct $ORACLE_HOME.

In article <4hurkf$8lq_at_news2.delphi.com>,

        DAGMARA_at_news.delphi.com (DAGMARA_at_DELPHI.COM) writes:
>I have a client using (I believe, but won't swear to it) HP-UX version 8
>with ORACLE version 7.1. For some reason, when logging on, or running
>cron jobs, UNIX prompts for ORACLE_HOME. I looked at the .login and
>..cshrc files, the path is set and the ORACLE_HOME is set; and the value
>are correct. The ORACLE_SID was mis-spelled, but the prompting continues
>even after that was corrected. Any suggestions?
>
>Dagmar Anne Bogan
>
>Kopania & Komorovsky Specializing in Data Architecture
>Richardson, TX 75081 and Performance Engieering
>
>dagmara_at_delphi.com
>
 

-- 
The Fulcrum Consulting Group               Peter Marelas - Consultant
12/10-16 Queen St, Melbourne VIC 3000,Australia   Ph: +61-3-9621-2100
PGP Key -> finger maral_at_fusion.sprint.com.au	  Fx: +61-3-9621-2724

Received on Tue Mar 12 1996 - 00:00:00 CET