xm_multiline module for Oracle alert.log on AIX System

View thread

gfouere

Hello,



I would like to obtain information in alert.log multiple lines for an event but without success. Below, my configuration :



<Extension multiline>

        Module       xm_multiline

        HeaderLine   /^\w\w\w\s\w\w\w\s\d\d\s\d\d:\d\d:\d\d\s\d\d\d\d/

</Extension>



<Extension syslog>

        Module  xm_syslog

</Extension>



<Input aix_syslog>

        Module  im_file

        File "/var/log/syslog.out*"

        Exec        to_syslog_bsd();

</Input>



<Input oracle_log_DBA102XX>

        Module      im_file

        InputType   multiline

        File        "/oradata/DBA102XX/admin/trace/bdump/alert_DBA102XX.log"

        Exec        to_syslog_bsd();

        Exec        $SourceName = "DBA102XX";

</Input>



<Output fluent_aix>

        Module om_udp

        Host 172.31.12.104

        Port 5139

</Output>



<Output fluent_oracle>

        Module om_udp

        Host 172.31.12.104

        Port 5127

</Output>



########################################

# Routes                               #

########################################

<Route 1>

        Path    aix_syslog => fluent_aix

</Route>



<Route 2>

    Path        oracle_log_DBA102XX => fluent_oracle



</Route>



Result Fluentd side :



7 Jun 2016 23:21:21     oracle.user.notice      {"host":"xmgpoc01","ident":"Tue","message":"21:21 DFT 2016"}

7 Jun 2016 23:21:21     oracle.user.notice      {"host":"xmgpoc01","ident":"Thread","message":"1 advanced to log sequence 66 (LGWR switch)"}

7 Jun 2016 23:21:21     oracle.user.notice      {"host":"xmgpoc01","ident":"","message":"/oradata/DBA102XX/oraredo01/LOG3A_DBA102XX.ORA"}

7 Jun 2016 23:21:21     oracle.user.notice      {"host":"xmgpoc01","ident":"","message":"/oradata/DBA102XX/oraredo02/LOG3B_DBA102XX.ORA"}



This line "Exec        $SourceName = "DBA102XX";" doesn't works, i dont know why.



Thank you for your help.