Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Chane Control

Re: Chane Control

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 06 Apr 2006 16:00:59 -0700
Message-ID: <1144364457.309306@yasure.drizzle.com>


dan.sherwin_at_gmail.com wrote:
> Hi, I'm working on a change control project and looking for the most
> important files in an apps environment that I would want to monitor
> changes on. For example, the init.ora. Not being an "Apps" guy, I'm
> not sure what else I should be monitoring. Are there 3-5 key config
> files I should be watching? Thanks very much.

Oracle, for all intents and purposes, no longer uses the init.ora file unless you are using a desupported version. You would need to look at the spfile and since it is compiled and dynamic this will not get you what I suspect you are looking for. Other than that there are no config files.

I would suggest that you focus on implementing auditing, already built into the database (not reinvent the wheel). The one file you might want to review for changes is the alert log.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Apr 06 2006 - 18:00:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US