The command “target <target_server_name> set metadata” results in “Target must be fully qualified (o.<sid>, x.jms)” (185282)

The following errors are observed when running the sp_ctrl command “target <target_server_name> set metadata”:

sp_ctrl (alvsupl19:8648)> target alvsupl19 set metadata source

  Target must be fully qualified (o.<sid>, x.jms)

  Example: target o.orasid set source eastern division

There is a syntax error in the command issued.

The metadata commands have the target SID name and not the target server name prefixed by the keyword target. So the correct command would be:

sp_ctrl (alvsupl19:8648)> target o.SID set metadata source  (or x.jms or c.SID as the case may be)

Where c.SID is for a Change History target and x.jms is for JMS target