Enable auditing in database - oracle database script

-- Auditing is disabled, when audit_trail is set to NONE,  SQL> show parameter audit_trail  NAME               TYPE               VALUE  ------------------------------------ ----------- --------------------------  audit_trail       string                NONE  - Either set audit_trail to DB or DB,EXTENDED.  alter system set audit_trail='DB' scope=spfile;  (or)  alter system set audit_trail='DB, EXTENDED' scope=spfile;  -- Restart the database.  shutdown immediate;  startup;  SQL> show parameter audit_trail  NAME                 TYPE                   VALUE  ------------------------------------ ----------- --------------------------  audit_trail           string               DB