Hi,
I have an Oracle database on a Oracle Linux VM.
I want to send Message in AlertLog to local Rsyslog and Forward it to a local Solution Centralization of Log.
I have no problem to send AlertLog to rsyslog local with this configuration file :
[root@dbserver ~]# cat /etc/rsyslog.d/oracle.conf
$ModLoad imfile
# ALERTLOG BASE DBTESTGM
$InputFilePollInterval 10
$PrivDropToGroup oinstall
$InputFileName /u02/app/oracle/diag/rdbms/dbtestgm/DBTESTGM/trace/alert_DBTESTGM.log
$InputFileTag ora-dbtestgm-alertlog
$InputFileStateFile stat-ora-dbtestgm-alertlog
$InputFileSeverity info
$InputFileFacility local6
$InputRunFileMonitor
$InputFilePersistStateInterval 1000
And the file to forward all OS and Database Log to Local Solution Logs:
[root@dbserver ~]# cat /etc/rsyslog.d/forward.conf
*.* @192.168.1.1:6201;RSYSLOG_SyslogProtocol23Format
I receive the message in Local Solution to manage All Logs, but do you have an idea to format correctly the output of AlertLog ?
Example :
Remove line with only date
Get only one line for an instruction (Switch Redo to create an ArchiveLog/ ORA- Error /etc.)
Thanks for your help,
Matt