Release 6.0.9.0

KeySummaryWorkaround
DLPX-72186CDB logfile retention works incorrectly if a PDB has multiple timeflows pointing to the same CDB timeflow.

No workaround.

DLPX-74749Oracle ENVIRONMENT_REFRESH_AND_DISCOVER job may fail with "The object OraclePDBConfig does not exist on the system".Manually run an environment refresh after the ENVIRONMENT_REFRESH_AND_DISCOVER job fails.

DLPX-75517

Provisioning an Oracle vPDB to a vCDB fails with "ORA-00959: tablespace 'TEMP' does not exist" if there is no temporary tablespace named TEMP within the production PDB$SEED database.

One of the following two workarounds can be applied:

  1. Re-attempt the vPDB provision to a linked CDB. The provision should succeed.
  2. Manually create (or rename) the TEMP tablespace in the production PDB$SEED database, take a new snapshot of the vPDB, and provision from that snapshot to the vCDB.
DLPX-75737Retention saves unnecessary logs if bookmark falls exactly on a snapshot end SCN or snapshot end timestamp.No workaround.
DLPX-75995On Windows 2019 Server, with KB4598230 cumulative update, adding or refreshing an environment fails when PowerShell transcription is enabled.The user has to turn off the transcription if the staging is on Windows 2019 Server with recent updates.
DLPX-76388Entering key pairs directly into hook environment variables (a new feature in 6.0.9.0) results in an internal error.Use password variables instead, or use a password vault. See Passing Credentials Securely to Hook Operations.
DLPX-76821JSchExceptionthrown for pattern-based SFTP masking with file count > 10.No workaround

Release 6.0.8.0

KeySummaryWorkaround

DLPX-64307

Environment refresh should ignore cluster discovery for VDBs

The following workaround should resolve the issue without Delphix support intervention.

For RAC databases

1. Add the instances to the clusterware configuration, ensuring you add all instances configured via Delphix. For example:

srvctl add instance -db <Database Name> -instance <Instance Name> -node <Node Name>

2. Refresh the environment. At this point, Delphix will add the instances back to the Delphix configuration, and you should be able to perform actions such as stop, start, disable, enable, etc.

From here, we recommend removing the clusterware configuration.

3. Stop the VDB via the Delphix GUI or CLI.
4. Remove the instances from clusterware

srvctl remove instance -db <Database Name> -instance <Instance Name>

5. Remove the database from clusterware

srvctl remove database -db <Database Name>

6. Refresh the environment.
7. Start the VDB via the Delphix GUI or CLI.

For RACOne databases

1. Stop the instance.

sqlplus "/as sysdba"
shutdown immediate

2. Ensure the RACOne configuration has the "instance prefix" configuration set.

[oracle@mwtestx1 ~]$ srvctl config database -d <vdb name> | grep "Instance name prefix"
Instance name prefix: VDB

3. If this is not set, then set it using

srvctl modify database -db <vdb name> -instance <instance prefix>

4. Set the pfile location to allow clusterware to start the instance

srvctl modify database -db <vdb name> -spfile <path to pfile>

The pfile is located in

<Delphix Mount base>/<VDB Name>/datafile/spfile.ora

5. Start the instance using clusterware

srvctl start database -d vdb

When querying the status of the database, it should now show a running instance. As an example:

[oracle@mwtestx1 ~]$  srvctl status database -d VDB
Instance VDB_1 is running on node mwtestx1
Online relocation: INACTIVE

6. Refresh the environment. At this point, Delphix will add the instances back to the Delphix configuration, and you should be able to perform actions such as stop, start, disable, enable, etc.

From here, we recommend removing the clusterware configuration.

7. Stop the VDB via the Delphix GUI or CLI.
8. Remove the database from clusterware

srvctl remove database -db <Database Name>

9. Remove the database from clusterware

srvctl remove database -db <Database Name>

10. Refresh the environment.
11. Start the VDB via the Delphix GUI or CLI.

DLPX-72186CDB logfile retention works incorrectly if a PDB has multiple timeflows pointing to the same CDB timeflowNo workaround.
DLPX-73409Duplicate listener entry gets generated in MDS if Oracle listener is manually started with non-uppercase name

Follow these steps:

1. Restart the listener without a name parameter so it displays in uppercase.

2. Update VDBs to use uppercase LISTENER.

3. Refresh the environment. lowercase listener will be removed and LISTENER updated appropriately.

DLPX-74749Oracle ENVIRONMENT_REFRESH_AND_DISCOVER job may fail with "The object OraclePDBConfig does not exist on the system"Manually run an environment refresh after the ENVIRONMENT_REFRESH_AND_DISCOVER job fails.

DLPX-74860

Provisioning a 2nd generation VDB from a dSource with imported RO transportable tablespaces fails with ORA-19654No workaround.
DLPX-74882Masking's SFTP client no longer compatible with SolarWinds and Goanyware SFTP serversNo workaround.

DLPX-75517

Provisioning an Oracle vPDB to a vCDB fails with "ORA-00959: tablespace 'TEMP' does not exist" if there is no temporary tablespace named TEMP within the production PDB$SEED database

One of the following two workarounds can be applied:

  1. Re-attempt the vPDB provision to a linked CDB. The provision should succeed.
  2. Manually create (or rename) the TEMP tablespace in the production PDB$SEED database, take a new snapshot of the vPDB and provision from that snapshot to the vCDB.
DLPX-76821JSchException thrown for pattern-based SFTP masking with file count > 10.No workaround

Release 6.0.7.0

Key

Summary

Workaround

DLPX-74457Cluster discovery for Oracle RAC partially fails on Solaris 10

Switch the default login shell for the Delphix OS user from /bin/sh to /bin/bash.


DLPX-74749Oracle ENVIRONMENT_REFRESH_AND_DISCOVER job may fail with "The object OraclePDBConfig does not exist on the system"Manually run an environment refresh from the Delphix UI if the ENVIRONMENT_REFRESH_AND_DISCOVER job fails with the mentioned error.
DLPX-76718Time required to display the point-in-time pop-over on timelines for Self-Service Templates with replicated objects can degrade linearly with each replication.No workaround but reducing replication frequency can reduce the impact.
DLPX-76821JSchException thrown for pattern-based SFTP masking with file count > 10.No workaround

Release 6.0.6.0

KeySummaryWorkaround
DLPX-73224When provisioning from a non-multitenant source to a virtual pluggable database (vPDB), the post-plug hook script (dx-post-plug-hook.sh) should exit with the vPDB either closed or open unrestricted. If the vPDB is left open with restricted access subsequent Snapshots of the vPDB will fail with "oracle.ucp.UniversalConnectionPoolException"  and " java.sql.SQLException: ORA-01035 ORACLE only available to users with RESTRICTED SESSION privilege" .

To prevent the issue:  Ensure that the vPDB is either closed/mounted or open unrestricted when exiting from dx-post-plug-hook.sh.

After it has happened: close and reopen the vPDB.

DLPX-72749Provisioning a TDE-enabled vPDB with system encrypted tablespaces fails with the error "ORA-28374: typed master key not found". No workaround, contact Delphix Support (TBD)
DLPX-72655Provisioning an Oracle TDE-enabled vPDB fails intermittently if the dSource is encrypted after linkingEnabling TDE on an existing non-encrypted dSource is not supported. Detach, rename the Delphix dSource name and re-attach it as a new TDE-enabled dSource before re-attempting the provisioning operation.
DLPX-73224When provisioning from a non-multitenant source to a virtual pluggable database (vPDB), the post-plug hook script (dx-post-plug-hook.sh) should exit with the vPDB either closed or open unrestricted. If the vPDB is left open with restricted access subsequent Snapshots of the vPDB will fail with "oracle.ucp.UniversalConnectionPoolException"  and " java.sql.SQLException: ORA-01035 ORACLE only available to users with RESTRICTED SESSION privilege"

To prevent the issue:  Ensure that the vPDB is either closed/mounted or open unrestricted when exiting from dx-post-plug-hook.sh.

After it has happened: close and reopen the vPDB.

DLPX-73357Rewinding an Oracle TDE-enabled vPDB to the snapshot before vPDB migration may fail with  exception.oracle.tde.export.keys.failed if all of the steps of the keystore merge procedure are not followed correctly

Verify that the CDB is restarted after merging the keys of the old target CDB into the new target CDB and re-attempt the rewind operation.

If the rewind still fails, provision a new vPDB from the required snapshot instead of the rewind operation.

DLPX-72181The "Restore Self-Service data container from the bookmark of sibling data container" operation may fail in an Oracle TDE environment with exception.oracle.tde.export.keys.failed if the keystore merge procedure is not followed correctly. In this case, the warning "Refresh operation on the TDE-configured container <target container> from the Timeflow of another container <sibling container> requires merging of the TDE keystores." will be displayed in the Delphix UI events logVerify that the procedure for merging the sibling keystores is followed correctly and re-attempt the self-service operation.
DLPX-73742Provisioning an Oracle TDE-enabled vPDB may fail with the error "ORA-28367: wallet does not exist" if the TDE wallet for the target linked CDB is stored on ASM storageStoring the TDE wallet on ASM storage is currently unsupported. Modify sqlnet.ora to point to the keystore location outside of the ASM diskgroup and re-attempt the provisioning operation.
DLPX-73788Provisioning or enabling an Oracle TDE-enabled vPDB fails when $ORACLE_BASE is used in sqlnet.oraAny environment variable referenced in sqlnet.ora must always be set in the environment for the Delphix OS user. Ensure that the environment variable $ORACLE_BASE is set in the shell initialization file for the Delphix OS user and re-attempt the operation.
DLPX-73789If WALLET_ROOT initialization parameter is configured on a TDE-enabled dSource PDB, provisioning may fail since the auxiliary CDB instance uses dSource keystore location.If the provision fails, there are 2 workarounds:
1. Provide permissions to the Delphix OS user to create files in the location identified by WALLET_ROOT directory of the source keystore on the target host.
2. Modify the dSource database to not use WALLET_ROOT to identify the TDE keystore. 

Release 6.0.2.0

KeySummaryWorkaround
DLPX-69638Masking job created on engine 6.0.1.1 or prior is failing after the upgrade to version 6.0.2.0 or laterMasking jobs created in 6.0.1.x using a Hana JDBC driver will need to be updated to grant the following permission {"java.io.FilePermission" "/", "read"} in 6.0.2.0. All drivers created in and after 6.0.2.0 will be granted this permission by default.

Release 6.0.0.0

KeySummaryWorkaround
DLPX-60397If a mapping algorithm is included in multiple jobs, only one job should be run at a time. If multiple jobs are run at the same time, then the mapping algorithm might contain multiple mappings to the same value or the jobs might deadlock.Only run one job at a time.
DLPX-60947Self-Service template with replica VDB is not updated with new Timeflow on incremental replication update

The latest replica VDB data can still be accessed by doing a Self-Service container Refresh, rather than a point-in-time restore from the template.

DLPX-61079

Certificate import validation may incorrectly reject a root CA certificate

Support must manually import the certificate into the truststore.

DLPX-61405

Masking operation should wait for zfs delete queue to drain

Replication may send more data than expected if masking involves dropping large DBF files.

DLPX-64493

V5 API /roles endpoint missing certain items

View and set these privileges through the GUI

DLPX-66155

Failed DSP engine test leads to multiple blocked client.jar processes on target hosts.

Restarting a Delphix Engine during a network throughput test is not recommended as it may lead to a system hang.

DLPX-66860

ADFS does not like NameIDPolicy sent by SSO app

Create an explicit rule in ADFS that transforms the {{emailAddress}} attribute into a {{nameid}}. The rule type must be "Transform an incoming claim". The incoming claim type must be "Email address" and the outgoing claim type "Name ID". The nameid format must be "Email address".

DLPX-66973

Date format is changed after importing the environment

Either (a) use the GUI import feature and then review the imported date formats for correctness or (b) use EngineSync to export/import jobs, which will not alter the date format.