cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

How to check Oracle replication jobs in Service Agent (SA) 2.0

578
Views
0
Helpful
0
Comments

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.

Create
Recognize Your Peers
Content for Community-Ad