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

Thread: Audit trail file

  1. #1
    Join Date
    Nov 2001

    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

  2. #2
    Join Date
    Nov 2000
    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
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    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



    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?


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