Antivirus software on Oracle server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Antivirus software on Oracle server

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    Antivirus software on Oracle server

    Hi,

    Does anybody have any experience with this:

    Is antivirus software such as McAfee Antivirus going to affect performance of Oracle on Windows 2000 server?

    I have a file-based email server with antivirus installed and the McShield on-access scanner is constantly using CPU time whenever a emailbox file is accessed. I wonder if it does the same thing as database file access. I am more concerned about contention for datafile access than stealing CPU cycle.

    thanks,

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Most virus software can be configured to ignore files based on various criteria, and commonly the file xtension is one of them. Your data files probably are *.dbf and/or *.ora, so you could configure it to ignore those type for a start.

    Maybe you could get the anti-virus software to ignore particular directories instead, though.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Smile

    Some users are complaining of locking the control files from the anti-virus software. Then you will get error messages in your alert log that Oracle cannot write to the control file.

    You have to disable checking of *.dbf, *.log and *.ctl files to avoid that.


    Hope that helps,

    clio_usa
    OCP 8/8i/9i DBA

    Visit our Oracle DBA site

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width