Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. The above command will enable the Unified Auditing on the DB.

  2. Restart all the Oracle Services.

    Code Block
    sqlplus / as sysdba
    startup mount
    exit
    
  3. Start the listener service.

    Code Block
    lsnrctl start
    
  4. Now again login into Oracle

    Code Block
    sqlplus / as sysdba
    
  5. Run the below Query.

    Code Block
    SQL> ALTER DATABASE OPEN;
    
  6. Now run the Query.

    Code Block
    SQL> select * from vsoption where PARAMETER = 'Unified Auditing';
    PARAMETER                  VALUE          CON ID
    Unified Auditing.          TRUE
    
  7. Now the Unified auditing is enabled.

 To Enable Unified_Auditing on DB.

  1. To enable Unified Auditing on DB please follow Step 13 to Step 23 under section Enable Unified_Auditing on Linux Syslog

...