When trying to activate a config file, you see the following error:
sp_ctrl (hrdb-1p:51100)> activate config config_file_06212007
The data source name in the config file must be preceded by "o."
The config file may have missing entry for datasource.
In its simplest form the config file should conform to the following template:
Datasource:o.sourceSID
source_owner.table target_owner.table targetsystem@o.targetSID
.
.
.
.
Where sourceSID and targetSID refer to the Oracle SIDs on source and target respectively and they need to precede with "o.", and if the entry for source SID is missing then you will see the above error. Please note that the entry for source SID occurs only once, whereas for target SID it occurs as many times as the entries for tables to be replicated. To correct the error, one simply needs to insert that line on the top and activate the config. To see a sample template, view the file named ORA_config.
