Data Loss Prevention

 View Only

Using the upgrader data pre-checker tool for Symantec DLP v14.5 with Screenshots 

Jul 26, 2016 06:47 AM

Using the upgrader data pre-checker tool for Symantec DLP v14.5

 

The latest version (14_5_0_0) of the Symantec Data Loss Prevention 14.5.x Upgrader Data Pre-checker Tool is attached to this article. To use this tool, download the file and extract the Upgrader_Data_Prechecker folder to your Oracle Database host computer, or any other computer that has access to your Oracle host.

 

Download and extract the zip file where you can easily access.

 

To run the upgrader data pre-checker tool
 

  1. On the Oracle host computer, log on as the Oracle user: su – oracle
  2. Open a command prompt with administrator permission and navigate to the Upgrader_Data_Prechecker folder you extracted from your Platform ZIP file.

Screen Shot 2016-07-26 at 1.14.50 PM.png

Figure 1: Navigating to Upgrader_Data_Prechecker folder

 

  1. Log in to SQL*Plus as the Symantec Data Loss Prevention Oracle user:

sqlplus sys as sysdba

Enter password.

Screen Shot 2016-07-26 at 1.19.12 PM.png

Figure 2: Login to SQL*Plus

 

  1. Run the run.sql script: @run.sql

Screen Shot 2016-07-26 at 1.23.31 PM.png

Figure 3: Execution of run.sql script

 

  1. The script runs for a few minutes and generates the report: Upgrader_Data_Prechecker.html.
  2. Open the report in a web browser to view the results, then take one of the following actions:
  • If the report lists any violated constraints, contact Symantec Technical Support at www.symantec.com/business/support.
  • Your support contact will Ask you to email the Upgrader_Data_Prechecker.html file to assist in Resolving any violated constraint issues in your database before you upgrade Your system.
  • If the report does not list any violated constraints, proceed with the upgrade Process.

Statistics
0 Favorited
0 Views
2 Files
0 Shares
0 Downloads
Attachment(s)
pdf file
Symantec DLP 14.5.x Upgrader Data Pre-checker tool Guide.pdf   819 KB   1 version
Uploaded - Feb 25, 2020
zip file
Upgrader_Data_Prechecker_14_5_0_0.zip   10 KB   1 version
Uploaded - Feb 25, 2020

Tags and Keywords

Comments

Aug 17, 2016 12:09 PM

I think it's important to note that in the screenshot, the errors like this:

ERROR at line 1:
ORA-20003: 
ORA-06512: at "SYS.UPGRADER_DATA_PRECHECK", line 640
ORA-20003: 
ORA-06512: at line 5

 

Can be avoided by running the pre upgrade checker script under the protect user instead of sys (as described on the upgrade guide page 13.

 

Related Entries and Links

No Related Resource entered.