Thanks for the question, Dmitry.
Asked: November 25, 2020 - 7:21 pm UTC
Last updated: November 30, 2020 - 2:34 am UTC
Version: Oracle 184.108.40.206
Viewed 100+ times
Our Billing system works with Oracle DB of version 220.127.116.11 (next year we are planning to upgrade all DBs to 19C with RAC).
Oracle DBs run on LINUX servers.
We got a requirement from our customer to install Anti-Malware Software on all LINUX servers (DB and Application).
Please advise how it will affect the Oracle software and DBs.
What will be the Oracle recommendations for such approach.
Thank you in advance!
and we said...
Paraphrasing from MOS note 782354.1
Such software *may* lock a file as its scan it.. This lock interrupts the normal functioning of the database. To prevent any disaster situation such as database crash/hang, we recommend the following files to be excluded from online anti-virus scanning.
- Oracle datafiles
- Control files
- Redo-log files
- Archived redo-log files if database is in archive log mode
- Files with extension '.ora'
- Password file
- Files with extension ' .log' under ORACLE_HOME
- File in ADR directory
- Oracle Software directories (including Oracle_HOME and Oracle base)
You can also contact your anti-virus vendor to know more on the details of the scanning mechanism of the particular anti-virus software and for any additional Oracle files that has to be excluded from the scanner. Sometimes excluding only these files are not sufficiant, so exclude the entire folder/directory of oracle database files.