Data Loss Prevention

 View Only
  • 1.  Unable to run migration action due to failure at upgradeReadinessTool(object validation failed)

    Posted Jan 24, 2023 12:21 PM
    Unable to run migration action due to failure at upgradeReadinessTool(object validation failed)

    Invalid object validation failed with two error shown below.
     
    Start: Invalid Object Validation - 
    Invalid Needed System objects
    Object Type Object Owner   Object Name         Status    Granted Priv
    ------------------- -------------------- ---------------------------------------- -------- -------------
    VIEW            SYS                 DBA_LOBS             MISSING    NONE
    VIEW           SYS                  DBA_TABLES         MISSING     NONE
    Invalid objects
    Object Type  Object Owner   Object Name
    ------------------- -------------------- ----------------------------------------
    PACKAGE   BODY   PROTECT     DLP_LOBSPACE_MGMT
    End : Invalid Object Validation - elapsed 5.58s - FAILED (2 errors, 1 warning)

    kindly let me know if anyone come across this issue and which POA might help to resolve this issue.


  • 2.  RE: Unable to run migration action due to failure at upgradeReadinessTool(object validation failed)

    Posted Jan 26, 2023 02:42 AM
    Please make sure you have granted the required privileges to protect user.

    https://knowledge.broadcom.com/external/article/160076/verify-or-grant-oracle-database-permissi.html

    BR
    Atif


  • 3.  RE: Unable to run migration action due to failure at upgradeReadinessTool(object validation failed)

    Posted Jan 31, 2023 12:39 AM
    Thank you for the reply.
    We have performed the steps mentioned in the article still issue exist.


  • 4.  RE: Unable to run migration action due to failure at upgradeReadinessTool(object validation failed)

    Posted Feb 01, 2023 01:01 AM
    Hello Harsha,
    create new user in Oracle data base and grant all access, don't used Protect user for migration, used that created user during run UpgradeReadiness tool


    Regards,
    AmanY
    Jainam technology's Pvt ltd


  • 5.  RE: Unable to run migration action due to failure at upgradeReadinessTool(object validation failed)

    Posted Feb 02, 2023 10:49 AM
    Hello Aman,

    Can you please share the article which has the steps to create a new user in Oracle DB and grant all the access ?

    Thanks,
    Rahul V


  • 6.  RE: Unable to run migration action due to failure at upgradeReadinessTool(object validation failed)

    Posted Feb 03, 2023 01:53 PM
    Hello Harsha,

    Please Follow the below steps to resolve the issue

    1. Take a cold backup of your Oracle DB.

    2. After the backup is complete, connect to SQL Plus using the "Protect" account. Run below commands:
    sqlplus /nolog
    conn protect@protect

    3. Then Run this command to drop the DLP_LOBSPACE_MGMT package from the protect schema:
    DROP PACKAGE DLP_LOBSPACE_MGMT;
    After executing the command, run the URT again to ensure the errors are resolved.

    4. Once this package has been dropped, run the URT again to verify that the errors and warnings have cleared up. Then proceed with the migration.

    Thanks,
    Rahul V