Repair fails with “Logon credentials not defined for <routing spec>” and “Define logon credentials by running ora_setup” (4301542)

When running repair or “repair using” with the “for <source SID>” option, the following errors are observed (shown here for “repair using”):

sp_ctrl>repair owner.source_table to owner.target_table for o.SOURCE_SID

  repair owner.source_table

   Logon credentials not defined for o.SOURCE_SID

   Define logon credentials by running ora_setup

Re-issue the command with the correct source SID name for the command to work.

The option “for <source SID>” also exists for compare or “compare using” and the error can also show up if incorrect source SID is provided.