Re: oracle_home

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 5 Apr 2013 18:50:13 +0100
Message-ID: <CABe10sYnn0gU_Q1NVntqhdG8sQTpPMNjOq+76NmA=FP+eOK-8Q_at_mail.gmail.com>

FYI That link points to AUDIT on my phone... I agree entirely. <RANT> I really, really, wish though that by default oraenv got installed in /usr/bin OR that the script was configured by root.sh so that calling scripts from cron with ORAENV_ASK=NO just worked. I've lost track of the number of cronjobs I've seen that don't work when called from cron, but do interactively. root.sh does allow you to 'misspecify' the local binary directory of course.

And whilst I've got you all in the back of my cab, wouldn't it be great if Oracle came up with a common oraenv across products and version controlled it so you didn't need to decide whether to answer Y/N to replacing the oraenv and associated scripts
</RANT>
On Apr 5, 2013 6:21 PM, "Hans Forbrich" <fuzzy.graybeard_at_gmail.com> wrote:

> On 05/04/2013 10:14 AM, Norman Dunbar wrote:
> > Oraenv is supplied to make your life easy, I'm puzzled as to whay you
> > are not using it. Cheers, Norm.
> It is surprising how few DBAs are aware of oraenv, and even fewer seem
> to have read the relevant docs at
>
> http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_4007.htm#i2059073
> (Section 1.2.3 describing how and why oraenv is used)
>
> The idea of PATH=$PATH:$ORACLE_HOME/bin is, unfortunately, taught in
> Oracle University classes and has become a widespread practice. Even OU
> course developers were, for the longest time, not aware that oraenv
> cleans up the PATH.
>
> /Hans
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 05 2013 - 19:50:13 CEST