The values in this table are useful for displaying a visual representation of multi-master configurations. Master and master definition sites are not required to have database links to their snapshot sites. Snapshot schemas are currently not registered in the replication catalog at their associated master site. Given an oraRepMasterSchema Table in an arbitrary replication environment, it is not be possible to locate all snapshot sites based solely on the information in this table.
Information is also provided for the detection of replication administration request errors and a relative count of the number of conflicts encountered at the current site. The table provides a count of the number of resolved conflicts. Not all conflicts may be resolved (the DBA did not declare the appropriate conflict resolution method(s) or a conflict was unable to be resolved due to other problems).
| Variable Name | Object ID |
| oraRepMasterSchemaRequestErrors | 1.3.6.1.4.1.111.4.3.3.1.1 |
| oraRepMasterSchemaResolvedConflicts | 1.3.6.1.4.1.111.4.3.3.1.2 |
| oraRepMasterSchemaOtherMasters | 1.3.6.1.4.1.111.4.3.3.1.3 |
| Syntax | Gauge32 |
| Max-Access | read-only |
| Explanation | This indicates the number of administration requests that have encountered errors. The errors themselves are stored in the administration queue at the source database of the request. |
| Typical Range | 0 |
| Significance | If the variable is > 0, then 1 or more administration commands failed at 1 or more remote sites. |
| Related Variables | oraRepLinkAdminRequests |
| Suggested Presentation | gauge or warning idicator |
| Syntax | Gauge32 |
| Max-Access | read-only |
| Explanation | This indicates the number of conflicts that were successfully resolved at the local database. For this variable to be valid, the DBA must activate statistics collection for conflict resolution. |
| Typical Range | configuration dependent |
| Significance | If the environment is configured to be conflict-free, this value always should be 0. Otherwise, this value gives the adminsdtrator a rough count of the conflicts that are occuring, although it is imprecise because it does not include any conflicts that have not been resolved. |
| Related Variables | none |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER32 |
| Max-Access | read-only |
| Explanation | This indicates the number of remote master databases involved in the replication of the schema. |
| Typical Range | configuration dependent |
| Significance | useful for displaying a map of the replication environment. |
| Related Variables | oraRepSchemaLinks |
| Suggested Presentation | simple string |