2 Replies Latest reply on Jun 15, 2012 3:44 PM by Rasheed_

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

      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
      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


      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,