Re: RAC & NFS noac mount option under AIX

Mount Options for Oracle files for RAC databases and Clusterware when used with NFS on NAS devices (Doc ID 359515.1) covers for a RAC database.
But I don't know if there is anything specific about external tables and utl_file

Hemant K Chitale

On Fri, Aug 20, 2021 at 12:10 AM Thomas Ranchon <thomas_at_ranchon.org> wrote:

> Hi,
>
> One of our production databases is a 2 node RAC extended cluster, OS is
> AIX 7.2
> (Oracle 18c that should be migrated to 19c by the end of the year)
> We are using 3 NFS mounts for :
>
> - reading golden gate trail files (There is a golden gate Replicat
> running on this database)
> - writing RMAN backups
> - writing csv files with utl_filesand reading csv files with external
> tables
>
> Those three NFS are mounted on both RAC nodes.
>
> In production the golden gate and RMAN NFS mounts are mounted without the
> noac option, the NFS for csv files is mounted with the noac option.
>
> We are currently testing a migration from an old NAS to a new NAS for
> those 3 NFS mounts.
>
> - For RMAN the documentation states that we should not be using the
> noac option, that's ok.
> - For Goldengate the documentation states that we should be using the
> noac option. (Oracle GoldenGate Best Practice: NFS Mount options for
> use with GoldenGate (Doc ID 1232303.1)).
> - I have not found anything related to the NFS mount option in a RAC
> database for reading and writing csv files using respectively external
> tables and utl_file.
>
> We have a process that is writing ~2500 csv files, on the old NFS with the
> noac option is was taking 3 minutes, with the new NFS with the noac option
> it's now taking more than 30 minutes, on the new NFS without the noac
> option it's taking 30 seconds.
> I have no metrics for the goldengate replication in our testing
> environment.
>
> Does anyone know if there is a mount option best practice for my third
> case? Should I consider those csv files as datafiles which means we should
> use the noac option.
>
> If noac is mandatory, I'll try to convince dba and storage teams to use
> ACFS instead of NFS. (We are currently using ASM for datafiles)
>
> Best regards,
> Thomas Ranchon
>
>

--
http://www.freelists.org/webpage/oracle-l