Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find out concrete ORACLE_HOME via SQL?
Mladen Gogala wrote:
> On Mon, 14 Aug 2006 16:22:07 +0000, Brian Peasland wrote:
>
>> Actually, Bob's location, $ORACLE_BASE/admin is OFA compliant. As such, >> I would not consider this a "change" but a "standard". See the following:
It seems to me that you are now changing your tone. In your previous post to this thread, you said "What is there to be gained by moving it to non-standard place?". All I showed was that Bob's location is a defined standard. :) In that same post, you said "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?" When I would opine that putting the parameter file in $ORACLE_BASE/admin/$ORACLE_SID/pfile does not make life harder for the DBA because it conforms to a published standard that all Oracle DBA's should know. This should not be confusing to the Oracle DBA. You did add the adjective "new" to describe the DBA and that could mean one of two things to me...either a Junior DBA who has never seen Oracle before, or someone new to the company, but does have Oracle DBA experience. The individual who is new to the company but does have Oracle DBA experience should not find this confusing. The Junior DBA who has never seen Oracle before is most likely overwhelmed by a lot of things...this being one of them. But then that's what training of standards is for.
The question of whether to move the parameter file from its default location to the published OFA location is a completely different question. Why would one put the parameter file in $ORACLE_BASE/admin/$ORACLE_SID/pfile? Because 1) it centralizes all of your administrative files, 2) backups of all administrative files is as easy as backing up $ORACLE_BASE/admin, and 3) because it is a published standard. Why keep the parameter file in its default location? Because 1) all Oracle DBAs should be able to find it since they should know the default location and 2) the OFA standards were written before SPFILE's and automatic backups of such were implemented. Personally, it does not matter to me which of these two locations are used. Just don't go adding a third location that is not the default nor a published standard, and I'll be able to find the parameter file just fine. I may miss it on my first attempt to locate it, but I'll find it on my second attempt. ;)
Cheers,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Mon Aug 14 2006 - 13:27:47 CDT
![]() |
![]() |