Skip to main content

VPDB provisioning fails due to error "Failed to create directories for temporary tablespace files" (KBA10899)







Attempts to provision or refresh a VPDB may fail due to

        messageCommandOutput: Failed to create temporary directory "/mnt/provision/MWVPDB-MWVCDB/temp/MWVCDB/126846DA37E7305EE0638E362B0ABA53/datafile" on host ( using user "dlpxqa":
/mnt/provision/MWVPDB-MWVCDB/temp/MWVCDB/126846DA37E7305EE0638E362B0ABA53/datafile does not exist.
/mnt/provision/MWVPDB-MWVCDB/temp/MWVCDB/126846DA37E7305EE0638E362B0ABA53 does not exist.
/mnt/provision/MWVPDB-MWVCDB/temp/MWVCDB exists.
/mnt/provision/MWVPDB-MWVCDB/temp/MWVCDB is not writable. <--- To fix: grant write permission to the user.

        messageDetails: Failed to create directories for temporary tablespace files.



This error occurs under specific conditions

  • The target Oracle version is between 19.19 and 19.22
    Note: Other versions may be effected, the versions listed are known offenders.
  • dNFS is enabled on the Oracle Home
  • New tempfiles have been added after the Delphix Snapshot.

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Date Release
Feb 21, 2024
Jan 25, 2024
Dec 20, 2023 | Jan 10, 2024 |
Nov 21, 2023
Oct 18, 2023
Sep 21, 2023
Aug 24, 2023
Jul 24, 2023
Jun 21, 2023
May 25, 2023
Apr 13, 2023 |
Mar 13, 2023 | Mar 20, 2023 |
Feb 13, 2023
Jan 12, 2023
Releases Prior to 2023
Major Release All Sub Releases


To resolve the issue, apply Oracle patch 35750253. If this is not available for your version of Oracle, please request a backport from Oracle.

Alternatively any of the following actions should also allow provisioning to be successful:

  • Change the Delphix OS user to match the Oracle instance owner ( typically "oracle" ).
  • Disable dNFS on the Oracle Home
  • Take a fresh snapshot of the dSource, then provision/refresh from the latest snapshot.


The issue is caused by an unpublished Oracle bug 35750253. In these specific versions of Oracle, when a new directory is created by the instance on the NFS filesystem, it is created with the incorrect permissions.

An example can be seen below:

[oracle@mw-rac19191 datafile]$ ls -la
total 5
drwxr-x---. 5 oracle asmadmin 6 Mar  1 00:49 .
drwxr-x--x. 7 oracle asmadmin 7 Feb 29 22:36 ..
drwxr-x---. 3 oracle asmadmin 3 Feb 29 22:36 +DATA
drwxrwx--x. 2 oracle asmadmin 3 Feb 29 22:41 delphix_group_writable
-rw-r-----. 1 oracle asmadmin 0 Feb 29 22:36 includedParameters.ora
drwxr--rwx. 3 oracle asmadmin 3 Mar  1 00:49 MYCDB   <------ CREATED BY ORACLE

Note that the permissions on the directory created by the Oracle instance are incorrect, as it has been created with world read/write/execute, and importantly, no group execute permissions.  The correct permissions should be:

drwxr-x---. 3 oracle asmadmin 3 Mar  1 00:54 MYCDB 

This permissions issue prevents the Delphix workflows from interacting with any files created within this directory.



Related Articles

The following articles may provide more information or related information to this article: