Re: oraenv - I am sure it used to be so simple

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Thu, 27 Feb 2014 10:07:50 -0600
Message-ID: <CAEueRAUPz_63k725-K0GhPZy71a8XkSwEDsgx_G=Fv9A5PU2Kg_at_mail.gmail.com>



oraenv and the oratab are readable by any user on the server. However, the oraenv script checks for proper permissions on ORACLE_BASE for the user running the script and spits out the error in the event they don't have privileges.

if [ -x $ORABASE_EXEC ]; then
 else

            echo "The $ORACLE_HOME/bin/orabase binary does not have execute privilege"

            echo "for the current user, $USER. Rerun the script after changing"

            echo "the permission of the mentioned executable."
            echo "You can set ORACLE_BASE manually if it is required."
fi

Seth Miller

On Thu, Feb 27, 2014 at 10:01 AM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> For users/developers that need the Oracle environment set, we usually put
> it in their profiles by exporting ORAENV_ASK=NO, export ORACLE_SID and
> execute oraenv to set the ORACLE_HOME path variable.
>
> I find it curious that Oracle documentation would say it's for DBA users
> only, otherwise you have to export all the variables manually on all boxes
> instead of just changing the ORACLE_SID in a vanilla profile setup.
>
> Chris
>
>
> On Thu, Feb 27, 2014 at 9:50 AM, Peter Hitchman <pjhoraclel_at_gmail.com>wrote:
>
>> Hi,
>> An Oracle client install:
>> Release 11.2.0.4.0
>>
>> Then when a non dba user calls oraenv:
>>
>> "ORACLE_SID = [CLIENT_1] ?
>> ORACLE_BASE environment variable is not being set since this
>> information is not available for the current user ID tspstest1.
>> You can set ORACLE_BASE manually if it is required."
>>
>> Now I have come across this before, but I decided to check on MOS and
>> came across
>> note 1387463.1, which really confuses me.
>>
>> First it says:
>> "The 'oraenv' script is used to allow the DBA to set a common
>> environment for all users and make it easier for users to move between
>> databases."
>>
>> but then a bit later on in reference to the above message:
>>
>> "This is expected behaviour as oraenv script is intended to be used by
>> dba users only"
>>
>> So which is it,is oraenv for the use of all users or just DBAs?
>>
>> I have always been confused by the test in the oraenv script to see if
>> oraclehomeproperties.xml is writeable, although that could be related to a
>> bug I logged in the 11.1 release with Oracle, about the fact that the
>> orabase command always re-wrote this file even when it did not need to.
>>
>> So what do other people do, when it comes to setting up an Oracle
>> environment for non dba users? Manually set ORACLE_BASE, ignore the error
>> or not use oraenv at all?
>>
>> Regards
>>
>> Pete
>>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 27 2014 - 17:07:50 CET

Original text of this message