Oracle Data Integrator 12c: Integration and Administration Ed 3 — Lesson 1: Topology, Agents, Repositories, and Security

Technical Scope

• master and work repositories, domains, logical schemas, contexts, and physical architecture
• standalone, JEE, and colocated agents, scheduling services, and connectivity
• users, profiles, object security, credentials, and environment separation
• repository backup, agent testing, connection diagnostics, and access remediation

Instructor Demonstration

The instructor diagnoses master and work repositories, domains, logical schemas, contexts, and physical architecture, then connects it to standalone, JEE, and colocated agents, scheduling services, and connectivity. The demonstration captures the exact configuration, transaction, command, query, log, or screen evidence needed to prove intended behavior and the applicable control boundary.

Applied Workshop

Learners execute a guided lab focused on standalone, JEE, and colocated agents, scheduling services, and connectivity and users, profiles, object security, credentials, and environment separation. The exercise introduces a realistic exception related to repository backup, agent testing, connection diagnostics, and access remediation and requires a reversible correction supported by before-and-after evidence.

1. Confirm scope, identities, data, dependencies, controls, and expected result.
2. Perform the product-specific configuration or analysis and record exact steps.
3. Validate functional behavior, security, data integrity, and operational observability.
4. Introduce the defined failure condition, diagnose the cause, and apply a safe correction.
5. Document rollback, acceptance evidence, unresolved risk, and ownership.

Validation Standard

Acceptance requires accurate handling of users, profiles, object security, credentials, and environment separation, traceable proof for master and work repositories, domains, logical schemas, contexts, and physical architecture, and a repeatable recovery path for repository backup, agent testing, connection diagnostics, and access remediation. Results must be understandable to both implementers and operational support teams.

Failure Analysis

Learners compare symptoms, logs, state, dependencies, and recent changes when repository backup, agent testing, connection diagnostics, and access remediation occurs. The final diagnosis must separate the immediate fix from the preventive control.

Practical Outcome

The completed output is a tested topology, agents, repositories, and security implementation or analysis, with validation evidence, troubleshooting notes, rollback guidance, and a concise operational handover.