The following errors are observed in event_log file when activating a config:
Warning 2018-11-08 15:05:20.242868 13673 1022424928 Activation: 13007 - No unique keys or primary key for object id 107035 (activating datasource o.ora11gr2) [module osp]
Error 2018-11-08 15:05:20.258495 13673 1022424928 Activation: no match found for alvsypl19:q1@o.ora11gr2 (activating datasource o.ora11gr2) [module rim]
sp_ctrl returns the following error when activating that config file:
sp_ctrl> activate config <configfile>
All routing maps in a partition scheme must also be listed on a line in the configuration file. (Scheme: scheme1)(Route: alvsypl19:q1@o.ora11gr2)
Here is the config file:
sp_ctrl> view config <configfile>
datasource:o.ora11gr2
owner.test owner.test !scheme1
Here is the partition specification:
sp_ctrl> view partitions all
Scheme Name Route Condition
------ ---- ----- ---------
scheme1 q1 alvsypl19:q1@o.ora11gr2 SNO>=1