Audit trail file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Audit trail file

  1. #1
    Join Date
    Nov 2001
    Posts
    55
    Hi,

    When I am trying 'connect internal' oracle is giveing me unable to initialize audit trail file (ora-09945). Please someone help me how to clean up the audit trail file and what is the name of the audit trail file & how to stop this in the future.

    ThanX in advance
    Raj

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Error: ORA-9945
    Text: Unable to initialize the audit trail file
    ---------------------------------------------------------------------------
    Cause: ORACLE unable to write header information to the file being used as
    the audit trail.
    Action: Check the UNIX error number for a possible operating system error. If
    there is no error, contact ORACLE customer support.


    Change your init.ora parameter AUDIT_TRAIL to either off or false.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    You probably will not be able to change anything with AUDIT_TRAIL init.ora parameter here.

    When you connect as INTERNAL or as SYSDBA/SYSOPER, Oracle allways records this in a operating system's audit trial, even if you have database auditing disabled.

    If you are on NT/2000 then probably your event log file is full. Clean or make more space to your event log with Event Viewer, priviledged database accesses are recorded in ApplicationLog part of event log.

    On Unix check the directory $ORACLE_HOME/rdbms/audit (or whatever you have set in AUDIT_FILE_DEST init.ora parameter) to see if it is full or if Oracle's owner quota on it has been exceeded.

    [Edited by jmodic on 02-16-2002 at 03:49 PM]
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Nov 2001
    Posts
    55

    NLS_CHARACTERSET

    Hi,

    My current NLS_CHARACTERSET is UTF8 I would like to know what are the implications If I run ALTER DATABASE CHARACTER SET to US7ASCII, is this compatible?

    ThanX
    Raj

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width