Grokbase › Groups › Oracle › oracle-l › September 2005
FAQ
Hi,
I want to enable simple auditing on my database.
I have started with audit_trail = OS, but the audit directory in
ORACLE_HOME/rdbms is not created.
I have run the cataudit.sql.
I know that oracle does basic auditing and puts them in rdbms/audit folder.
This is windows on 9i. Any idea ???
Regards - Chirag

Search Discussions

  • Allen, Brandon at Sep 28, 2005 at 2:41 pm ⇧
    I believe on Windows the default OS audit trail is the Windows Event Viewer.


    Regards,
    Brandon

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org On Behalf Of Chirag DBA
    Sent: Wednesday, September 28, 2005 12:33 PM
    To: askdba_at_freelists.org; Oracle-L Freelists
    Subject: Audit Trail

    Hi,


    I want to enable simple auditing on my database.


    I have started with audit_trail = OS, but the audit directory in ORACLE_HOME/rdbms is not created.


    I have run the cataudit.sql.


    I know that oracle does basic auditing and puts them in rdbms/audit folder.


    This is windows on 9i. Any idea ???


    Regards - Chirag

    Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

    --
    http://www.freelists.org/webpage/oracle-l
  • Chirag DBA at Sep 28, 2005 at 2:48 pm ⇧
    I also did an audit table but as I have put AUDIT_TRAIL = OS, it should go
    somewhere.
    Somewhre.. but where??? I have manually created audit folder in rdbms.
    still no file is generated.
    On 9/28/05, Allen, Brandon wrote:

    I believe on Windows the default OS audit trail is the Windows Event
    Viewer.
    Regards,
    Brandon

    -----Original Message-----
    *From:* oracle-l-bounce_at_freelists.org [mailto:
    [email protected]]*On Behalf Of *Chirag DBA
    *Sent:* Wednesday, September 28, 2005 12:33 PM
    *To:* askdba_at_freelists.org; Oracle-L Freelists
    *Subject:* Audit Trail

    Hi,
    I want to enable simple auditing on my database.
    I have started with audit_trail = OS, but the audit directory in
    ORACLE_HOME/rdbms is not created.
    I have run the cataudit.sql.
    I know that oracle does basic auditing and puts them in rdbms/audit
    folder.
    This is windows on 9i. Any idea ???
    Regards - Chirag

    Privileged/Confidential Information may be contained in this message or
    attachments hereto. Please advise immediately if you or your employer do not
    consent to Internet email for messages of this kind. Opinions, conclusions
    and other information in this message that do not relate to the official
    business of this company shall be understood as neither given nor endorsed
    by it.
    --
    http://www.freelists.org/webpage/oracle-l
  • Vergara, Michael (TEM) at Sep 28, 2005 at 2:46 pm ⇧
    If the directory isn't already there, you can just create it. On my systems, I set the init.ora parameter
    audit_file_dest to a directory like $ORACLE_BASE/admin/SID/audit. On 10, I've noticed that the
    default is $ORACLE_BASE/admin/SID/adump, so that might be a good place to start.


    I have audit_trail = DB on my systems, and then the audit records are in a SQL-queryable table called
    SYS.AUD$. There are a bunch of predefined views of this table (like DBA_AUDIT_TRAIL) that make it very easy to query.


    Cheers,
    Mike


    Michael P. Vergara Be good and you will be lonesome
    Oracle Database Administrator Mark Twain

    (951) 914-2000 (Voice)
    (951) 914-2990 (FAX)

    www.guidant.com <http://www.guidant.com/>


    From: oracle-l-bounce_at_freelists.org On Behalf Of Chirag DBA
    Sent: Wednesday, September 28, 2005 12:33 PM
    To: askdba_at_freelists.org; Oracle-L Freelists
    Subject: Audit Trail

    Hi,


    I want to enable simple auditing on my database.


    I have started with audit_trail = OS, but the audit directory in ORACLE_HOME/rdbms is not created.


    I have run the cataudit.sql.


    I know that oracle does basic auditing and puts them in rdbms/audit folder.


    This is windows on 9i. Any idea ???


    Regards - Chirag
  • Reidy, Ron at Sep 28, 2005 at 2:56 pm ⇧
    He answered it for you. Read this:
    http://www.dbasupport.com/oracle/ora9i/holdOnThereSYSter.shtml and/or
    the Oracle docs.


    rr
    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Chirag DBA
    Sent: Wednesday, September 28, 2005 1:46 PM
    To: Allen, Brandon
    Cc: Oracle-L Freelists
    Subject: Re: Audit Trail

    I also did an audit table but as I have put AUDIT_TRAIL = OS, it should
    go somewhere.


    Somewhre.. but where??? I have manually created audit folder in rdbms.


    still no file is generated.


    On 9/28/05, Allen, Brandon wrote:

    I believe on Windows the default OS audit trail is the Windows
    Event Viewer.


    Regards,
    Brandon

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Chirag DBA
    Sent: Wednesday, September 28, 2005 12:33 PM
    To: askdba_at_freelists.org; Oracle-L Freelists
    Subject: Audit Trail

    Hi,

    I want to enable simple auditing on my database.

    I have started with audit_trail = OS, but the audit

    directory in ORACLE_HOME/rdbms is not created.


    I have run the cataudit.sql.


    I know that oracle does basic auditing and puts them in
    rdbms/audit folder.


    This is windows on 9i. Any idea ???


    Regards - Chirag

    Privileged/Confidential Information may be contained in this
    message or attachments hereto. Please advise immediately if you or your
    employer do not consent to Internet email for messages of this kind.
    Opinions, conclusions and other information in this message that do not
    relate to the official business of this company shall be understood as
    neither given nor endorsed by it.

    This electronic message transmission is a PRIVATE communication which contains
    information which may be confidential or privileged. The information is intended
    to be for the use of the individual or entity named above. If you are not the
    intended recipient, please be aware that any disclosure, copying, distribution
    or use of the contents of this information is prohibited. Please notify the
    sender of the delivery error by replying to this message, or notify us by
    telephone (877-633-2436, ext. 0), and then delete it from your system.

    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 28, '05 at 2:34p
activeSep 28, '05 at 2:56p
posts5
users4
websiteoracle.com

4 users in discussion

Chirag DBA: 2 posts Reidy, Ron: 1 post Allen, Brandon: 1 post Vergara, Michael (TEM): 1 post

Content

People

Support

Translate

site design / logo © 2023 Grokbase