DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Alter system set auditing failed

  1. #1
    Join Date
    Apr 2003
    Location
    Kuala Lumpur
    Posts
    59

    Alter system set auditing failed

    I issue 'alter system set audit_sys_operations=TRUE' but I got the following error. Pls help.

    Error:
    SQL> alter system set audit_sys_operations=TRUE;
    alter system set audit_sys_operations=TRUE
    *
    ERROR at line 1:
    ORA-02095: specified initialization parameter cannot be modified
    Attached Images Attached Images

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    That means this parameter cannot be modified dynamically. You need to make changes in the init.ora file and bounce the DB.

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    It is a static parameter.

    AUDIT_SYS_OPERATIONS
    Parameter type
    Boolean

    Default value
    false

    Parameter class
    Static

    Range of values
    true | false


    AUDIT_SYS_OPERATIONS enables or disables the auditing of operations issued by user SYS, and users connecting with SYSDBA or SYSOPER privileges. The audit records are written to the operating system's audit trail.
    Last edited by SANJAY_G; 06-10-2003 at 02:58 AM.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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