Core Issue
In SA 2.0, the Master Provisioned Data Store (MPDS)/Oracle is set up as a multi-master database configuration to allow for the high fault tolerance. The Oracle databases utilize replication jobs to keep each other in sync with the most up-to-date data. These jobs are responsible for data replication between MPDS instances.
Resolution
To check for Oracle replication in SA 2.0, connect as the repadmin user. Refer to this information:
sql> select job, what, to_char(next_date, 'MM/DD/YYYY HH24:MI:SS'), broken from dba_jobs;
sql> select count(*) from deftran;
sql> select count(*) from deferror;
sql>exit;
If a high number of jobs fail, contact Cisco Technical Support.
