Re: Chane Control
Date: Thu, 06 Apr 2006 16:00:59 -0700
Message-ID: <1144364457.309306_at_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 Fri Apr 07 2006 - 01:00:59 CEST