Data Loss Prevention

 View Only
  • 1.  14.6 to 15.1 migration assistant error VerifyDBPermissions

    Posted Oct 23, 2018 09:26 AM
      |   view attached

    Hello DLP Fam,

     

    I have run the upgrade readiness tool, which appeared to say I am good to go. Juts 8 warnings, all about constraints which seem benign. I ran the recommended permissions from the guide : 

    sqlplus sys/[schema user name] as sysdba GRANT READ,WRITE ON directory DATA_PUMP_DIR TO [schema user name]; GRANT SELECT ON dba_registry_history TO [schema user name]; GRANT SELECT ON dba_temp_free_space TO [schema user name];

    Am I missing additional permissions? 

    I'm attempting to upgrade my lab, and getting the following : 

     

    C:\Program Files\Symantec\Data Loss Prevention\Single Tier Server\15.1\Protect\M
    igrator>SingleTierServerMigrationUtility.exe -cli
    1. Version VERSION_14_6 (installed at "C:\SymantecDLP")
    Select a source installation: 1
    Running migration action "VerifyURTZipIsExtracted"
    Completed migration action "VerifyURTZipIsExtracted"
    Running migration action "StopServices"
    Completed migration action "StopServices"
    Running migration action "StopServices"
    Completed migration action "StopServices"
    Running migration action "DisableServices"
    Completed migration action "DisableServices"
    Running migration action "DisableServices"
    Completed migration action "DisableServices"
    Running migration action "VerifyOracleVersion"
    Completed migration action "VerifyOracleVersion"
    Running migration action "CompileDbPackages"
    Completed migration action "CompileDbPackages"
    Running migration action "VerifyDBPermissions"
    Migration failed, rolling back changes.  Please refer to the log file for detail
    s.
    Completed rollback of migration actions
    Exception: Failed to execute migration actions

     

    One further note, I had to hardcode the full path to the URT. It didn't like the relative path... 

     

    Thanks

    -Phil

     



  • 2.  RE: 14.6 to 15.1 migration assistant error VerifyDBPermissions

    Posted Oct 24, 2018 02:45 AM

    Hi Phillip,

     

    Check below and make sure you're running the task as an admin:

    https://symwisedownload.symantec.com//resources/sites/SYMWISE/content/live/DOCUMENTATION/9000/DOC9258/en_US/Symantec_DLP_15.1_Upgrade_Guide_Win.pdf?__gda__=1536191797_fa26aa64f01b094a074cb4564223907c

    Thanks!



  • 3.  RE: 14.6 to 15.1 migration assistant error VerifyDBPermissions

    Posted Oct 24, 2018 08:37 AM

    Hi Craig,

    The command prompt was run as administrator. ( See screenshot from the first post) The db credential is not able to be specified in the migration assistant. 

     



  • 4.  RE: 14.6 to 15.1 migration assistant error VerifyDBPermissions

    Posted Oct 25, 2018 03:54 PM

    Can you be more specific about the suggestion you have?