VDB Provision Fails with "WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard," when Target Is HP-UX (KBA11170)
KBA
KBA#
Issue
When provisioning an Oracle VDB to a target running HP-UX the job can fail with the following Oracle error:
WARNING:NFS file system /mnt/delphix/<VDB>/datafile mounted with incorrect options WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard, 2024-05-29T10:06:28.712728+02:00 ORA-00210: cannot open the specified control file ORA-00202: control file: '/mnt/delphix/<VDB>/<VDB>_control_1.ctl' ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Prerequisites
This issue only affect targets running HP-UX with a certain patch level when provisioning an Oracle VDB.
Applicable Delphix Versions
- Click here to view the versions of the Delphix engine to which this article applies
-
Date Release Jun 20, 2024 24.0.0.0 May 22, 2024 23.0.0.0 Apr 17, 2024 | May 8, 2024 22.0.0.0 | 22.0.0.1 Mar 20, 2024 | Apr 2, 2024 21.0.0.0 | 21.0.0.1 Feb 21, 2024 20.0.0.0 Jan 25, 2024 19.0.0.0 Dec 20, 2023 | Jan 10, 2024 18.0.0.0 | 18.0.0.1 Nov 21, 2023 17.0.0.0 Oct 18, 2023 16.0.0.0 Sep 21, 2023 15.0.0.0 Aug 24, 2023 14.0.0.0 Jul 24, 2023 13.0.0.0 Jun 21, 2023 12.0.0.0 May 25, 2023 11.0.0.0 Apr 13, 2023 10.0.0.0 | 10.0.0.1 Mar 13, 2023 | Mar 20, 2023 9.0.0.0 | 9.0.0.1 Feb 13, 2023 8.0.0.0 Jan 12, 2023 7.0.0.0 Releases Prior to 2023 Major Release All Sub Releases 6.0 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.0, 6.0.10.1, 6.0.11.0, 6.0.12.0, 6.0.12.1, 6.0.13.0, 6.0.13.1, 6.0.14.0, 6.0.15.0, 6.0.16.0, 6.0.17.0, 6.0.17.1, 6.0.17.2
Resolution
To resolve this issue, either back out the latest patch set or switch to using Oracle DNFS.
Troubleshooting
The issue is caused by an unknown HP-UX patch that changes the behaviour of the data captured in the /etc/mnttab file. Oracle parses this file to check for the mount options
rsize>=32768 & wsize>=32768
An example looks similar to the following:
cat /etc/mnttab | grep <VDB> ##.##.#.#:/domain0/group-#/oracle_db_container-###/oracle_timeflow-### /mnt/delphix/<VDB>/ nfs nosuid, noints, forcedirectio, NFSv3, dev=4007940 0 0 1717757917
After patching, these entires are no longer recorded in the /etc/mnttab file, and so Oracle interprets them as not set.
If you run the following command
nfsstat -m /mnt/delphix/<VDB>/temp from ##.##.#.#:/domain0/group-#/oracle_db_container-###/oracle_timeflow-###/temp Flags: vers=3, proto=tcp, sec=sys, hard, nointr, forcedirectio, link, symlink, acl, devs, rsize=32768,wsize=32768, retrans=5, timeo=600
you will see that the options are in place on the mount.
Related Articles
The following articles may provide more information or related information to this article:
- N/A