Data Loss Prevention

Expand all | Collapse all

DLP upgradation issue 15.5 to 15.7

Jump to Best Answer
  • 1.  DLP upgradation issue 15.5 to 15.7

    Posted 12 days ago
    Hi Team,

    I have encountered issue with DLP upgradation from 15.5 Mp2 to 15.7. After installation 15.7 i ran the migration utility on enforce server.
    i got the below error message while running the enforcemigration utility.

    I have verified Oracle home path in environment variable. it was there. Can someone help me on this.

    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Jul 20, 2020 10:01:44 PM com.symantec.dlp.migrationcommon.MigrationUtility runMigrationUtilityJul 20, 2020 10:01:44 PM com.symantec.dlp.migrationcommon.MigrationUtility runMigrationUtilitySEVERE: Failed to read installation parameterscom.symantec.dlp.migrationcommon.MigrationException: ORACLE_HOME environment variable not set at com.symantec.dlp.migrationcommon.implementations.CommonInstallationParametersReader.getOracleParameters(CommonInstallationParametersReader.java:60) at com.symantec.dlp.migrationcommon.implementations.CommonInstallationParametersReader.readInstallationParameters(CommonInstallationParametersReader.java:239) at com.symantec.dlp.enforceservermigrationutility.EnforceMSIInstallationParametersReader.readInstallationParameters(EnforceMSIInstallationParametersReader.java:35) at com.symantec.dlp.migrationcommon.MigrationUtility.runMigrationUtility(MigrationUtility.java:97) at com.symantec.dlp.migrationcommon.MigrationUtility.runMigrationUtility(MigrationUtility.java:70) at com.symantec.dlp.enforceservermigrationutility.EnforceServerMigrationUtility.runMigration(EnforceServerMigrationUtility.java:17)
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    ------------------------------
    Regards,
    Rahul V
    ------------------------------


  • 2.  RE: DLP upgradation issue 15.5 to 15.7

    Posted 8 days ago
    Hi Rahul,

    From the log entry posted, it appears that the migration utility is not seeing the variable.  In my experience, setting the ORACLE_HOME variable from the command prompt (in Windows) will not make the variable permanent so as soon as the instance of the command prompt is closed, the variable is gone.  Did you set the variable using a command prompt or have you gone into the advanced system properties to create the system variable there?


  • 3.  RE: DLP upgradation issue 15.5 to 15.7

    Posted 5 days ago
    Hello Eric,

    We have gone into the advanced system properties and created the system variable there.


    Thanks,
    Rahul V


  • 4.  RE: DLP upgradation issue 15.5 to 15.7

    Posted 5 days ago
    As a simple test, on the Enforce server open a new command prompt and type in "set ORACLE_HOME" (without the quotes). The command should output the value you have specified for the variable in the advanced system properties.  Similarly, type in the command "set path" to verify that your path variable contains the expected installation path to Oracle.  Provided that the output is returned as expected and there isn't any mis-spelling of the variable name, if the migration utility continues to provide errors of the environment variable not being set then you may consider opening a ticket with the technical support team to look more closely at the scenario with you.


  • 5.  RE: DLP upgradation issue 15.5 to 15.7

    Posted 5 days ago
    Hello Eric,

    Thanks for your reply. As per your suggestion, I ran set ORACLE_HOME command in CMD and got output as "Environment variable ORACLE_HOME not defined"

    And after running set path command I have got output as " Path=D:\oracle\product\12.2.0.1\db_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC "

    Can you please let me know the correct process for setting Oracle Home ?




  • 6.  RE: DLP upgradation issue 15.5 to 15.7
    Best Answer

    Posted 5 days ago
    Hi Rahul,

    So it looks like your path variable is set up, just not the ORACLE_HOME variable.  To set this variable on the Enforce server, open up Control Panel > System and Security > System.  In the left pane of the System window you should see a link to open the Advanced System Settings that will launch your System Properties screen.  Now you should see a button for Environment Variables that you need to click on.  Under the section for System Variables, click "New" and proceed to input ORACLE_HOME for the name and the path for the value, which for you appears to be D:\oracle\product\12.2.0.1\db_1.

    If you still have your command prompt running from the initial test I suggested today, you will need to close and relaunch the command prompt so that instance is aware of any new environment variables that have been set.  Try the "set ORACLE_HOME" once again to see if returns the value of the variable you just set.  I expect you should see the output now for this test.


  • 7.  RE: DLP upgradation issue 15.5 to 15.7

    Posted 5 days ago
    Hello Eric,

    I have added the ORACLE_HOME manually in Advanced System Settings and now we are able to view the expected output.

    We shall try upgrading now and I will keep you posted if went successful.


    Thanks,
    Rahul


  • 8.  RE: DLP upgradation issue 15.5 to 15.7

    Posted 3 days ago
    Hello Eric,

    Thanks for your support.
    We have upgraded DLP to 15.7 successfully.


    Thanks,
    Rahul V