Help Center/ Database and Application Migration UGO/ FAQs/ Evaluation Project/ What Do I Do If the Assessment Task Is Connected but the Pre-check Fails?
Updated on 2024-11-07 GMT+08:00
View PDF
Share

What Do I Do If the Assessment Task Is Connected but the Pre-check Fails?

Symptom

The DBA permission was granted to the connection user who created the evaluation project. The connection test of the evaluation task was successful, but the pre-check failed.

Possible Cause

The user has the DBA permission, but is not the default DBA role.

Solution

  1. Log in to the source database and run the following SQL statement to check whether the current user is the default DBA role:

    select * from dba_role_privs where grantee='user_name';

    • If the value of default_role of dba is no, the role is not the default DBA role.
    • user_name indicates the name of the user used to connect to the source database.

  2. Run the following SQL statement to change the role to the default one:

    ALTER USER user_name DEFAULT ROLE dba;

  3. After the modification, perform the pre-check again.
Parent topic: Evaluation Project