Error: "Failed to execute migration actions" when upgrading DLP

Products

• Data Loss Prevention

Issue/Introduction

The DLP migrator fails when starting the upgrade and throws this error in the migrator log:

SEVERE: Failed to execute migration actions. Please refer to the log file for details
com.symantec.dlp.migrationcommon.MigrationException: Failed to run migration action "CompileDbPackages"
 at com.symantec.dlp.migrationcommon.MigrationActionsExecutor.runMigrationAction(MigrationActionsExecutor.java:72)
 at <snipped data>
Caused by: com.symantec.dlp.migrationcommon.MigrationException: Failed to compile migration SQL script
 at <snipped data>
Caused by: java.lang.Exception: Failed to execute SQLPlus
 at com.symantec.databasemigration.oracle.sqlplus.SQLPlusExecutor.execute(SQLPlusExecutor.java:154)
 at <snipped data>
Caused by: java.io.IOException: Cannot run program "sqlplus.exe" (in directory "D:\Program Files\Symantec\DataLossPrevention\EnforceServer\<version>\Protect\Migrator\SQL"): CreateProcess error=2, The system cannot find the file specified
 at java.lang.ProcessBuilder.start(ProcessBuilder.java:1048)
 at com.symantec.databasemigration.oracle.sqlplus.SQLPlusExecutor.execute(SQLPlusExecutor.java:150)
 ... 9 more
Caused by: java.io.IOException: CreateProcess error=2, The system cannot find the file specified
 at <snipped data>
 ... 10 more

Environment

Release: 15.x

Cause

The cause of this error is that the Migrator is not able to find sqlplus.exe .
This is usually caused when the PATH variable does not include any reference to the location of sqlplus. 
This is required for the Migrator to be able to successfully run sqlplus and connect to the database to proceed with migration actions.

Resolution

These requirements from the Upgrade Guide should be configured to resolve this error:

1. Log on to the Enforce Server as a domain administrator.
2. In the administrator command prompt, run the following command to set the ORACLE_HOME variable.
3. Confirm your Oracle version and installation path before setting this variable.
   
   For example:
   
   set ORACLE_HOME=c:\oracle\product\<version>\db_1
   
   
4. Run the following command to set the PATH variable:
   
   set PATH=%ORACLE_HOME%\bin:%PATH%