oraenv - I am sure it used to be so simple

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