cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
596
Views
0
Helpful
0
Comments
TCC_2
Advocate
Advocate

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.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Quick Links