RE: Oracle/Server Audit

Though this one requires $$, another winner nonetheless.

http://www.virtualbeer.com/vb/images/gallery/labels/lowedunkb.jpg

Jared

                                                                                       
                                 
                    "Murray, Margaret"                                                 
                                 
                    <mamurray_at_husseyse       To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>        
                    ating.com>               cc:                                       
                                 
                    Sent by:                 Subject:     RE: Oracle/Server Audit      
                                 
                    root_at_fatcity.com                                                   
                                 
                                                                                       
                                 
                                                                                       
                                 
                    09/24/01 02:43 PM                                                  
                                 
                    Please respond to                                                  
                                 
                    ORACLE-L                                                           
                                 
                                                                                       
                                 
                                                                                       
                                 

Jared,
You might take a look at https://www.ecora.com/ecora/products.asp. Doesn't look like they cover everything on your list (and more than one module covers what you stated), but I saw an early demo that looked good. Margaret

> -----Original Message-----
> From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]
> Sent: Monday, September 24, 2001 3:28 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle/Server Audit
>
>
>
> First off, let me state that this post is NOT referring to
> Oracle Database
> Auditing.
>
> That may be one of the criteria in the audit I'm referring
> to, but is only
> peripherally
> relevant to my question.
>
> What I need is a document that can be used to audit a server
> that one or
> more
> Oracle databases are on, audit the setup and configuration of
> the database
> itself, as well as an audit of operational items.
>
> Here are examples:
>
> System:
>
> OS version
> Physical/Logical volume layout.
> Is it local, SAN, NAS or something else?
>
> Backup hardware, software and capabilities.
>
> There can be OS specific sections:
>
> Unix:
> Oracle database owner.
> location of oratab
>
> NT:
>
> Domain:
> Failsafe in use?
> Details if so.
>
>
> Oracle:
>
> Have default passwords been changed?
> Who has DBA access?
> Who requires DBA access?
> Is Archiving on?
> If so, is it setup properly?
>
> Operational:
>
> OS monitoring, backup and deletion of archive logs?
>
> OS level monitoring in place. e.g. disk space, alert.log monitoring,
> sniped session monitor, etc.
>
> Backup/recovery tested?
> Documented?
>
> And lastly, a section with recommendations for all of the above.
>
> All comments, suggestions and recommendations are welcome.
>
> URL's to document(s) with a fair amount of this already in place
> are especially welcome, and will be rewarded with a virtual beer,
> or beverage of your choice. :)
>
> Or if I see you at IOUG, a real one.
>
> Thanks
>
> Jared
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Jared.Still_at_radisys.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Murray, Margaret
  INET: mamurray_at_husseyseating.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).