Re: oracle_home
Date: Fri, 05 Apr 2013 13:09:27 -0600
Message-ID: <515F2167.1030406_at_gmail.com>
On 05/04/2013 11:50 AM, Niall Litchfield wrote:
>
> FYI That link points to AUDIT on my phone... I agree entirely.
>
Incredibly weird. On one of my systems it takes me to the Admin Linux/Unix admin doc, on the other (VM-based) it takes me to the SQL Language ref / Audit. I suspect some form of cursor capture buffer issue or they have a link problem.
Manually, http://tahiti.oracle.com -> Database 11.2 -> Master Book List -> Administrator's Reference for Linux and UNIX-Based Operating Systems
(And, just re-verified
http://docs.oracle.com/cd/E11882_01/server.112/e10839/admin_ora.htm#BGBJGDJE)
> <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.
>
Templates - when I use cron - the DBMS_SCHEDULER has usurped most (but
not all) cron jobs - I have a script template that starts with the
ORAENV_ASK=NO sequence.
Not sure what benefit /usr/bin would have over /usr/local/bin - be interested in some discussion about that.
I agree they might be able to create a 'do I have a TTY' detection to automatically go do non-interactive setting, as well as possibly a 'default SID' capability, would be nice.
> 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
>
Please no! I tailor these often enough that I'll be supremely annoyed
if my changes get overwritten.
UNLESS they provided a hook at the end that would execute customer code if placed in a specific file.
> </RANT>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 05 2013 - 21:09:27 CEST