Data Loss Prevention

 View Only
  • 1.  Update Readiness Tool Error

    Posted Mar 14, 2019 09:33 AM

    Hello,

    I am trying to run URT to check readiness of database but I get follorwing error.

    C:\Users\shr00098\Desktop\Symantec_DLP_15.5_Update_Readiness_Tool_15.5.0-1>java

    UpdateReadinessTool

    Please enter the database username: protect

    Please enter the database user password:

    Please enter the database readiness username: dlpupgrade

    Please enter the database readiness user password:

    Please enter the database system identifier (sid): protect

    In progress...

    Error: Export: Release 12.2.0.1.0 - Production on Thu Mar 14 15:58:34 2019

    Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

    UDE-00018: Data Pump client is incompatible with database version 12.1.0.2.0

     

    Error: UpdateReadinessTool failed to run.

     

    This tool was working yesterday but generated some errors. We had to grant some permissions for this.

     

    SQL> GRANT SELECT ON DBA_REGISTRY_HISTORY TO PROTECT;

    GRANT SELECT ON DBA_TEMP_FREE_SPACE TO PROTECT;

    GRANT EXECUTE ON DBMS_LOB TO PROTECT;

     

    Grant succeeded.

     

    SQL>

    Grant succeeded.

     

    SQL>

    Grant succeeded.

     

    SQL>

    SQL> GRANT READ, WRITE on DIRECTORY DATA_PUMP_DIR TO PROTECT;

     

    Grant succeeded.
     

    Aftrer running these commands, I tried to run URT today but failed.

    Please guide.

     

    Best Regards,

    Atif



  • 2.  RE: Update Readiness Tool Error
    Best Answer

    Posted Mar 17, 2019 05:15 AM

    Issue resolved.

    Solution:

    C:\Users\shr00098\Desktop\Symantec_DLP_15.5_Update_Readiness_Tool_15.5.0-1>java UpdateReadinessTool --username <schema user name> --password <password> --readiness_username <readiness_username> --readiness_password <readiness_password> --sid <database_system_id> [--quick]

    When I inserted these parameters manually in single instruction, it executed.

     

    Atif