Re: How to find out concrete ORACLE_HOME via SQL?

On Mon, 14 Aug 2006 00:18:54 +0000, Bob Jones wrote:

> Actually it is quite common for the spfile to be placed outside of
> $ORACLE_HOME directory, such as /u01/admin.

You and me definitely have the different understanding of DBA job. I don't see any reason to change this parameter, unless I have a need for maintaining a RAC system with shared spfile. What would be a reason for such a change? Why would I want to move that file elsewhere? To confuse the enemy or to make life harder for the possible new DBA? What is there to be gained by moving it to non-standard place? As an old school DBA, I'm always trying to abide by the old "don't fix it if it ain't broken" wisdom. It doesn't make me look fancy and wise, but it does usually make my environments stable.

-- 
http://www.mgogala.com