Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Source Database User Has the Permission to Parse Logs
Updated on 2024-09-25 GMT+08:00
View PDF
Share

Checking Whether the Source Database User Has the Permission to Parse Logs

During an incremental synchronization with Oracle serving as the source database, DRS checks the permissions of the source database user. If the source database user does not have the log parsing permission, the incremental migration will fail.

Failure Cause

  • The source database user does not have the EXECUTE_CATALOG_ROLE role.
  • The source database user does not have the permission to parse logs.

Handling Suggestion

Assign the required role or permission to the user and perform the check again.

  • Run the GRANT EXECUTE_CATALOG_ROLE TO UserName command to assign the EXECUTE_CATALOG_ROLE role to a user.
  • Run the GRANT LOGMINING TO UserName command to grant the log parsing permission to a user.
Parent topic: Database Parameters