Help for this page

Select Code to Download


  1. or download this
    #!/bin/sh
    #
    ...
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME
    #
    /usr/bin/dbipoll.pl -dbtype=oracle -server=servername1 -dbport=1521 -d
    +b=development -user=myuser -xpassword=/etc/dbipasswd -table=dba_audit
    +_trail -columns="OS_PROCESS,OS_USERNAME,USERNAME,USERHOST,ACTION,ACTI
    +ON_NAME,TRANSACTIONID,SCN,SQL_BIND,SQL_TEXT,TO_CHAR(EXTENDED_TIMESTAM
    +P,'MM/DD/YYYY HH24:MI:SS'),EXTENDED_TIMESTAMP" -countfile="/app/oracl
    +e/product/monitor/countfile1" -countkey="EXTENDED_TIMESTAMP" -o="/opt
    +/oracledb1.log"
    
  2. or download this
    #!/bin/sh
    #
    ...
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME
    #
    /usr/bin/dbipoll.pl -dbtype=oracle -server=servername2 -dbport=1521 -d
    +b=development -user=myuser -xpassword=/etc/dbipasswd -table=dba_audit
    +_trail -columns="OS_PROCESS,OS_USERNAME,USERNAME,USERHOST,ACTION,ACTI
    +ON_NAME,TRANSACTIONID,SCN,SQL_BIND,SQL_TEXT,TO_CHAR(EXTENDED_TIMESTAM
    +P,'MM/DD/YYYY HH24:MI:SS'),EXTENDED_TIMESTAMP" -countfile="/app/oracl
    +e/product/monitor/countfile2" -countkey="EXTENDED_TIMESTAMP" -o="/opt
    +/oracledb2.log"