1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Audit trail Oracle 11g R2 RAC two insrance

Discussion in 'SQL PL/SQL' started by Hedou, Feb 17, 2014.

  1. Hedou

    Hedou Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    55
    Hi
    i want activate audit trail with option audit_trai=XML,EXTENDED and audit_dest_file is other server specialy for the log
    please help me , i am a new in this domaine
    thinks
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    audit_dest_file must be local to the instance; you can't enable the audit trail for instance 1 and send the logs, etc to the server for instance 2.
     
  3. Hedou

    Hedou Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    55
    Hi
    thinks you for your help ,
    can you send me more information for what i do to enable the audit for database in RAC with option audit_trai=XML,EXTENDED
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    I'm not running 12.1 but in 11.2 you cannot set audit_trail to xml,extended. You c an set extended, db_extended, xml (among others).


    You will need to use alter system to do this:


    alter system set audit_trail=xml scope=spfile sid='*';


    then restart your database.