Provide a pre-configured virus scanner and SMTP server for deliveries

Doug Ross

Description

Since OAC is managed by Oracle, by default there should be a virus scanner and SMTP server pre-configured and allow for customers to override if necessary.

Use Case and Business Need

We have experienced multiple issues with certificates and patching clearing SMTP settings for OAC environment.   There should be a default SMPT server available out of the box. 

For the virus scanner, we get the message about not having a virus scanner configured when uploading data models and data.  If a default virus scanner cannot be included, then allow a system settings to disable the virus scanning for the entire instance if customer desires.

More details

Oracle managed OAC should include all capabilities built-in.

Original Idea Number: 8785aac4a5

Bill_Marcellus

Totally agree on both of these. "Autonomous" service, by its very definition, should include managed virus scanning.

Doug Ross

January 2020 release for Autonomous Database includes built-in SMTP.. why not do the same for OAC?

"Autonomous Database now includes the UTL_SMTP package. This makes it possible to send emails via PL/SQL from within Autonomous Database. However, note that the only supported email provider is Oracle Cloud Infrastructure Email Delivery service - for example:

• smtp.us-phoenix-1.oraclecloud.com
• smtp.us-ashburn-1.oraclecloud.com
• smtp.email.uk-london-1.oci.oraclecloud.com
• smtp.email.eu-frankfurt-1.oci.oraclecloud.com
• "
• https://www.oracle.com/database/technologies/datawarehouse-bigdata/adw-features.html

M_Kumaran

I agree. Managed service then, I expect it to have Pre-configured SMTP server and Virus Scanner.

Doug Ross

Revisiting this request again three years later... every time we deploy a data model we get the message about a virus scanner not being configured... either provide one by default or else allow for a system setting to ignore the virus scanner check