2 Replies Latest reply: Jun 15, 2012 10:44 AM by Rash_ RSS

    Error : ORA-32001 & ORA-02095 occurs when trying to alter audit_trial

    715689
      Hi All,

      I am trying to alter the audit_trial parameter to 'db,extended' as need to log SQLTEXT and SQLBIND into the SYS.AUD$.
      But when I tried to alter the system parameter it gives me the below error.

      Connected to Oracle Database 11g Release 11.2.0.2.0
      Connected as SYS

      SQL> ALTER SYSTEM SET audit_trail=db,extended SCOPE=SPFILE;

      ALTER SYSTEM SET audit_trail=db,extended SCOPE=SPFILE

      ORA-32001: write to SPFILE requested but no SPFILE is in use

      SQL> ALTER SYSTEM SET audit_trail=db,extended;

      ALTER SYSTEM SET audit_trail=db,extended

      ORA-02095: specified initialization parameter cannot be modified

      SQL>

      Currently there is no server parameter file (SPFILE) in use for this database.
      Is it not possible to alter the audit_trail parameter without using SPFILE scope?
      I highly appreciate all your help to overcome this issue.

      Best Regards,
      Nipuna86